public DataTable SaveData(PL_LoanOpening plobj)
{
DL_LoanOpening dl = new DL_LoanOpening();
DataTable dt = new DataTable();
if (plobj.ind == 0)
{
return(dt);
}
else
{
dt = dl.DL_SaveRecord(plobj);
return(dt);
}
}
internal DataTable DL_SaveRecord(PL_LoanOpening plobj)
{
try
{
con = Connection.SetConnection();
cmd = new SqlCommand("SPLoanOpening", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", plobj.ind);
cmd.Parameters.AddWithValue("@CITYCODE", plobj.CityCode);
cmd.Parameters.AddWithValue("@empno", plobj.EmpNo);
cmd.Parameters.AddWithValue("@LoanCd", plobj.LoanCd);
cmd.Parameters.AddWithValue("@LoanSenctionDate", plobj.LoanSenctionDate);
cmd.Parameters.AddWithValue("@ActualLoanAmt", plobj.ActualLoanAmt);
cmd.Parameters.AddWithValue("@IntrestRate", plobj.IntrestRate);
cmd.Parameters.AddWithValue("@InterstAmt", plobj.InterstAmt);
cmd.Parameters.AddWithValue("@MonthlyInstalment", plobj.MonthlyInstalment);
cmd.Parameters.AddWithValue("@NoOfInstalment", plobj.NoOfInstalment);
cmd.Parameters.AddWithValue("@month", plobj.Month);
cmd.Parameters.AddWithValue("@MonthCd", plobj.MonthCd);
cmd.Parameters.AddWithValue("@FinYear", plobj.FinYear);
cmd.Parameters.AddWithValue("@UserId", plobj.UserId);
cmd.Parameters.AddWithValue("@Vno", plobj.Vno);
cmd.Parameters.AddWithValue("@RefNo", plobj.RefNo);
cmd.Parameters.AddWithValue("@Narration", plobj.Narration);
cmd.Parameters.AddWithValue("@DeductionMonth", plobj.DeductionMonth);
cmd.Parameters.AddWithValue("@UT_BulkLoanOpening", plobj.dtEmp);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch
{
return(dt);
}
finally
{
con.Close();
con.Dispose();
}
}
