internal DataTable DL_SaveTransMaster(PL_LeaveTrasaction plobj) { try { con = Connection.SetConnection(); cmd = new SqlCommand("SPLeaveTransaction", 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("@LvCd", plobj.LvCd); cmd.Parameters.AddWithValue("@NoOfLv", plobj.NoOfLv); cmd.Parameters.AddWithValue("@DateFrom", plobj.DateFrom); cmd.Parameters.AddWithValue("@DateTo", plobj.DateTo); cmd.Parameters.AddWithValue("@month", plobj.Month); cmd.Parameters.AddWithValue("@Upd_Ind", plobj.Upd_Ind); cmd.Parameters.AddWithValue("@Narr", plobj.Narr); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); } catch { return(dt); } finally { con.Close(); con.Dispose(); } }
public DataTable UpdateData(PL_LeaveTrasaction plobj) { DL_LeaveTrasaction objdl = new DL_LeaveTrasaction(); DataTable dt = new DataTable(); if (plobj.Ind == 0) { return(dt); } else { dt = objdl.DL_SaveTransMaster(plobj); return(dt); } }