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(); } }