public void insertloan(BOLloan loanBO, string sql)
{
using (con = DBaccess.GetConnection())
{
string mess = string.Empty;
int ress = 0;
SqlCommand cmd = new SqlCommand();
SqlParameter parcompanycode, parplantcode, parloanid, paragentid, parroutid, parloandate, parexpdate, parloanamnt, parbal, parinst, pardest, parmess, parress, parInterestAmount, parNoofinstallment, ParUid;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
parcompanycode = cmd.Parameters.Add("@companycode", SqlDbType.Int);
parplantcode = cmd.Parameters.Add("@plantcode", SqlDbType.Int);
parloandate = cmd.Parameters.Add("@loandate", SqlDbType.DateTime);
parexpdate = cmd.Parameters.Add("@expdate", SqlDbType.DateTime);
parroutid = cmd.Parameters.Add("@route_id", SqlDbType.Int);
paragentid = cmd.Parameters.Add("@agentid", SqlDbType.Int);
parloanid = cmd.Parameters.Add("@loan_id", SqlDbType.Int);
parloanamnt = cmd.Parameters.Add("@loanamnt", SqlDbType.Money);
parbal = cmd.Parameters.Add("@balance", SqlDbType.Money);
parinst = cmd.Parameters.Add("@inst_amount", SqlDbType.Money);
pardest = cmd.Parameters.Add("@description", SqlDbType.NVarChar, 100);
parInterestAmount = cmd.Parameters.Add("@InterestAmount", SqlDbType.Money);
parNoofinstallment = cmd.Parameters.Add("@Noofinstallment", SqlDbType.Int);
ParUid = cmd.Parameters.Add("@UserId", SqlDbType.Int);
parmess = cmd.Parameters.Add("@mess", SqlDbType.Char, 50);
cmd.Parameters["@mess"].Direction = ParameterDirection.Output;
parress = cmd.Parameters.Add("@ress", SqlDbType.Int);
cmd.Parameters["@ress"].Direction = ParameterDirection.Output;
parcompanycode.Value = loanBO.Companycode;
parplantcode.Value = loanBO.Plantcode;
parloandate.Value = loanBO.Loandate;
parexpdate.Value = loanBO.Expiredate;
parroutid.Value = loanBO.Route_id;
paragentid.Value = loanBO.agent_id;
parloanid.Value = loanBO.Loan_id;
parloanamnt.Value = loanBO.Loanamount;
parbal.Value = loanBO.Balance;
parinst.Value = loanBO.Instamnt;
pardest.Value = loanBO.Desc;
parInterestAmount.Value = loanBO.InterestAmount;
pardest.Value = loanBO.Desc;
parNoofinstallment.Value = loanBO.NoofInstallment;
ParUid.Value = loanBO.UserId;
cmd.ExecuteNonQuery();
mess = (string)cmd.Parameters["@mess"].Value;
ress = (int)cmd.Parameters["@ress"].Value;
//if (ress == 1)
//{
// WebMsgBox.Show(mess.ToString());
//}
//else
//{
// WebMsgBox.Show(mess.ToString());
//}
}
}
public void insertloandetails(BOLloan loanBO)
{
string sql = "insert_loandetails";
loanDA.insertloan(loanBO, sql);
}
