public DataSet dal_APpaymentDetail(bel_APpayment obj_bel_Payment) { DataSet ds = new DataSet(); try { SqlCommand sqlcmd = new SqlCommand("spu_ARPaymentSearch"); sqlcmd.CommandTimeout = 0; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Clear(); sqlcmd.Parameters.AddWithValue("@PaymentID", obj_bel_Payment._PaymentID); sqlcmd.Parameters.AddWithValue("@Payment_DetailID", obj_bel_Payment._Payment_DetailID); sqlcmd.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"])); sqlcmd.Parameters.AddWithValue("@ProductID", obj_bel_Payment._ProductID); sqlcmd.Parameters.AddWithValue("@ProductCode", obj_bel_Payment._ProductCode); sqlcmd.Parameters.AddWithValue("@JOBID", obj_bel_Payment._JOBID); sqlcmd.Parameters.AddWithValue("@ScreenName", obj_bel_Payment._ScreenName); sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"])); sqlcmd.Parameters.AddWithValue("@iMode", obj_bel_Payment._iMode); sqlcmd.Parameters.AddWithValue("@PartyID", obj_bel_Payment._PartyID); sqlcmd.Parameters.AddWithValue("@Period", obj_bel_Payment._BillFromDate); ds = DataFunctions.GetDataSet(sqlcmd); } catch (Exception ex) { } return ds; }
public DataSet dal_AutoGen(bel_APpayment obj_bel_Payment) { DataSet ds = new DataSet(); try { SqlCommand sqlcmd = new SqlCommand("spu_AutoGenTransaction"); sqlcmd.CommandTimeout = 0; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Clear(); sqlcmd.Parameters.AddWithValue("@ScreenName", obj_bel_Payment._ScreenName); sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"])); sqlcmd.Parameters.AddWithValue("@FromDate", obj_bel_Payment._BillFromDate); sqlcmd.Parameters.AddWithValue("@ToDate", obj_bel_Payment._BillToDate); sqlcmd.Parameters.AddWithValue("@Year", Convert.ToInt32(HttpContext.Current.Session["FinancialYear"])); ds = DataFunctions.GetDataSet(sqlcmd); } catch (Exception ex) { } return ds; }