//DAl code
public bool Insert(BOL.bolEmpLoanInstallments obj)
{
dbConnection conn =new dbConnection();
string sql = "insert into EmpLoanInstallments(AppId,EmpId,LoanID,LoanType,NoOfInstallments,Premium,Amountsanctioned,LDate,Status,Paymentthrough,Activationstatus,RemainingAmount,Interest) values(@AppId,@EmpId,@LoanID,@LoanType,@NoOfInstallments,@Premium,@Amountsanctioned,'@Date,'pending',@Paymentthrough,@Activationstatus,@RemainingAmount,@Interest)";
OleDbParameter[] oleDbParameters = new OleDbParameter[12];
oleDbParameters[0] = new OleDbParameter("@AppId", OleDbType.Integer);
oleDbParameters[0].Value = obj.AppId;
oleDbParameters[1] = new OleDbParameter("@EmpId", OleDbType.VarChar);
oleDbParameters[1].Value = obj.EmpId;
//sqlParameters[1] = new SqlParameter("@LoanID", SqlDbType.VarChar);
//sqlParameters[1].Value = obj.LoanID;
oleDbParameters[2] = new OleDbParameter("@NoOfInstallments", OleDbType.Integer);
oleDbParameters[2].Value = obj.NoOfInstallments;
oleDbParameters[3] = new OleDbParameter("@Premium", OleDbType.Decimal);
oleDbParameters[3].Value = obj.Premium;
oleDbParameters[4] = new OleDbParameter("@AmountSanctioned", OleDbType.Decimal);
oleDbParameters[4].Value = obj.AmountSanctioned;
oleDbParameters[5] = new OleDbParameter("# @Date#", OleDbType.Date);
oleDbParameters[5].Value = obj.LDate;
oleDbParameters[6] = new OleDbParameter("@LoanType", OleDbType.VarChar);
oleDbParameters[6].Value = obj.LoanType;
oleDbParameters[7] = new OleDbParameter("@LoanID", OleDbType.VarChar);
oleDbParameters[7].Value = obj.LoanID;
oleDbParameters[8] = new OleDbParameter("@Paymentthrough", OleDbType.VarChar);
oleDbParameters[8].Value = obj.Paymentthrough;
oleDbParameters[9] = new OleDbParameter("@Activationstatus", OleDbType.VarChar);
oleDbParameters[9].Value = obj.Activationstatus;
oleDbParameters[10] = new OleDbParameter("@RemainingAmount", OleDbType.Decimal);
oleDbParameters[10].Value = obj.RemainingAmount;
oleDbParameters[11] = new OleDbParameter("@Interest", OleDbType.VarChar);
oleDbParameters[11].Value = obj.Interest;
return conn.executeInsertQuery(sql, oleDbParameters);
}
//Bol Code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace PayRoll.BOL
{
class bolEmpLoanInstallments
{
DAL.dalEmpLoanInstallments dalObj= new PayRoll.DAL.dalEmpLoanInstallments();
private Int32 m_Srlno;
private string m_AppId;
private string m_EmpId;
private string m_Loanid;
private string m_Loantype,m_Status;
private string m_NoOfInstallments;
private Decimal m_Premium;
private Decimal m_Amountsanctioned;
private DateTime m_date;
private string m_Paymentthrough;
private string m_Activationstatus;
private Decimal m_RemainingAmount;
private string m_Interest;
/// <constructor>
/// Constructor bolEmpLoanInstallments
/// </constructor>
public bolEmpLoanInstallments()
{
//Initialize the variable here
}
/// <summary>
/// ColumnName:Srlno
/// Data Type:int
/// Length:0
/// </summary>
public Int32 Srlno
{
get
{
return m_Srlno;
}
set
{
m_Srlno = value;
}
}
/// <summary>
/// ColumnName:Empid
/// Data Type:VarChar
/// Length:20
/// </summary>
public string AppId
{
get
{
return m_AppId;
}
set
{
m_AppId = value;
}
}
public string EmpId
{
get
{
return m_EmpId;
}
set
{
if (value == "")
{
throw new InvalidData("Please select Employee Id", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
if (value.Length > 20)
{
throw new InvalidData("The Empid is more length", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
m_EmpId = value;
}
}
/// <summary>
/// ColumnName:Loanid
/// Data Type:VarChar
/// Length:50
/// </summary>
public string LoanID
{
get
{
return m_Loanid;
}
set
{
if (value== "")
{
throw new InvalidData("Please Select Loan ID", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
if (value.Length > 50)
{
throw new InvalidData("The Loanid is more length", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
m_Loanid = value;
}
}
/// <summary>
/// ColumnName:Loantype
/// Data Type:VarChar
/// Length:50
/// </summary>
public string LoanType
{
get
{
return m_Loantype;
}
set
{
if (value == "")
{
throw new InvalidData("Please select Loan type", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
if (value.Length > 50)
{
throw new InvalidData("The Loantype is more length", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
m_Loantype = value;
}
}
/// <summary>
/// ColumnName:Installmentamountpermonth
/// Data Type:decimal
/// Length:0
/// </summary>
public string NoOfInstallments
{
get
{
return m_NoOfInstallments;
}
set
{
m_NoOfInstallments = value;
}
}
public string Interest
{
get
{
return m_Interest;
}
set
{
if (value == "")
{
throw new InvalidData("Please Enter Interest", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
m_Interest = value;
}
}
/// <summary>
/// ColumnName:Amountsanctioned
/// Data Type:decimal
/// Length:0
/// </summary>
public Decimal AmountSanctioned
{
get
{
return m_Amountsanctioned;
}
set
{
//if (value == 0)
//{
// throw new InvalidData("Please enter the amount");
//}
m_Amountsanctioned = value;
}
}
public Decimal RemainingAmount
{
get
{
return m_RemainingAmount;
}
set
{
m_RemainingAmount = value;
}
}
/// <summary>
/// ColumnName:Approveddate
/// Data Type:datetime
/// Length:0
/// </summary>
public Decimal Premium
{
get
{
return m_Premium;
}
set
{
m_Premium = value;
}
}
/// <summary>
/// ColumnName:Paiddate
/// Data Type:datetime
/// Length:0
/// </summary>
public DateTime LDate
{
get
{
return m_date;
}
set
{
m_date = value;
}
}
public string Status
{
get
{
return m_Status;
}
set
{
if (value.Length == 0)
{
throw new InvalidData("Please select Loan Status", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
if (value.Length > 50)
{
throw new InvalidData("The LoanStatus is more length", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
m_Status = value;
}
}
public string Paymentthrough
{
get
{
return m_Paymentthrough;
}
set
{
if (value == "")
{
throw new InvalidData("Please enter payment through", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
m_Paymentthrough = value;
}
}
public string Activationstatus
{
get
{
return m_Activationstatus;
}
set
{
m_Activationstatus = value;
}
}
public bool Insert ()
{
dalObj.Insert(this);
return true;
}
public bool Update()
{
dalObj.Update(this);
return true;
}
public bool Update1()
{
dalObj.Update1(this);
return true;
}
}
}
//Presentation layer code
BOL.bolEmpLoanInstallments obj = new PayRoll.BOL.bolEmpLoanInstallments();
String Sql = ""+cmbempid.Text+"";
String[] Empid =Sql.Split('(');
obj.AppId = txtloanappId.Text;
obj.EmpId = Empid[0].ToString();
// obj.LoanType = cmbloanidapplication.Text;
//obj.LoanID = txtLoanID.Text;
obj.LoanID = LnId;
obj.LoanType = LType;
//obj.LoanID = LnId;
obj.AmountSanctioned = Convert.ToDecimal(txtamount.Text);
obj.Premium = Convert.ToDecimal(txtpremiumamount.Text);
obj.NoOfInstallments = Convert.ToString(nudinstallments.Value);
obj.Interest = Convert.ToString(nudinterest.Value);
obj.LDate = Convert.ToDateTime(dtpdate.Value);
obj.Paymentthrough = cmbPaymentthrough.Text;
obj.Activationstatus = "0";
obj.RemainingAmount = Convert.ToDecimal(txtamount.Text);
obj.Insert();
MessageBox.Show("Record Saved sucessfully", "Payroll", MessageBoxButtons.OK, MessageBoxIcon.Information );
clear();
txtloanappId.Text = dbConnection.GetNextNumber("EmpLoanInstallments", "AppId").ToString();
my problem is not insert the data into database because exception occur in date format so please rectify the error