internal DataTable DL_SaveRecord(PL_LeaveOpening plobj) { try { con = Connection.SetConnection(); cmd = new SqlCommand("SPLeaveOpening", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", plobj.ind); cmd.Parameters.AddWithValue("@CITYCODE", plobj.CityCode); cmd.Parameters.AddWithValue("@month", plobj.Month); cmd.Parameters.AddWithValue("@empno", plobj.EmpNo); cmd.Parameters.AddWithValue("@LvCd", plobj.LvCd); cmd.Parameters.AddWithValue("@NoOfLv", plobj.NoOfLeave); cmd.Parameters.AddWithValue("@Narr", plobj.Narration); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); } catch { return(dt); } finally { con.Close(); con.Dispose(); } }
public DataTable SaveData(PL_LeaveOpening plobj) { DL_LeaveOpening dl = new DL_LeaveOpening(); DataTable dt = new DataTable(); if (plobj.ind == 0) { return(dt); } else { dt = dl.DL_SaveRecord(plobj); return(dt); } }