public DataSet dal_APReceiptDetail(bel_ARReceipt obj_bel_Receipt) { DataSet ds = new DataSet(); try { SqlCommand sqlcmd = new SqlCommand("spu_ARReceiptSearch"); sqlcmd.CommandTimeout = 0; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Clear(); sqlcmd.Parameters.AddWithValue("@ReceiptID", obj_bel_Receipt._ReceiptID); sqlcmd.Parameters.AddWithValue("@Receipt_DetailID", obj_bel_Receipt._Receipt_DetailID); sqlcmd.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"])); sqlcmd.Parameters.AddWithValue("@ProductID", obj_bel_Receipt._ProductID); sqlcmd.Parameters.AddWithValue("@ProductCode", obj_bel_Receipt._ProductCode); sqlcmd.Parameters.AddWithValue("@JOBID", obj_bel_Receipt._JOBID); sqlcmd.Parameters.AddWithValue("@ScreenName", obj_bel_Receipt._ScreenName); sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"])); sqlcmd.Parameters.AddWithValue("@iMode", obj_bel_Receipt._iMode); sqlcmd.Parameters.AddWithValue("@PartyID", obj_bel_Receipt._PartyID); sqlcmd.Parameters.AddWithValue("@Period", obj_bel_Receipt._BillFromDate); ds = DataFunctions.GetDataSet(sqlcmd); } catch (Exception ex) { } return ds; }
public DataSet dal_AutoGen(bel_ARReceipt obj_bel_Receipt) { 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_Receipt._ScreenName); sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"])); sqlcmd.Parameters.AddWithValue("@FromDate", obj_bel_Receipt._BillFromDate); sqlcmd.Parameters.AddWithValue("@ToDate", obj_bel_Receipt._BillToDate); sqlcmd.Parameters.AddWithValue("@Year", Convert.ToInt32(HttpContext.Current.Session["FinancialYear"])); ds = DataFunctions.GetDataSet(sqlcmd); } catch (Exception ex) { } return ds; }