internal DataTable DL_SaveStopPayment(PL_StopPayment plobj) { try { con = Connection.SetConnection(); cmd = new SqlCommand("SPStopPayment", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ind", plobj.Ind); cmd.Parameters.AddWithValue("@Date", plobj.Date); cmd.Parameters.AddWithValue("@Empno", plobj.Empno); cmd.Parameters.AddWithValue("@Month", plobj.Month); cmd.Parameters.AddWithValue("@StopReason", plobj.StopReason); cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); } catch { return(dt); } finally { con.Close(); con.Dispose(); } }
public DataTable SaveStopPayment(PL_StopPayment plobj) { DL_StopPayment objdl = new DL_StopPayment(); DataTable dt = new DataTable(); if (plobj.Ind == 0) { return(dt); } else { dt = objdl.DL_SaveStopPayment(plobj); return(dt); } }