public DataSet SelectOrderandOrderDetails(string OrderId, string CompanyId, DateTime StartDate, DateTime EndDate, bool All) { DataSet ds = new DataSet(); DataAccessManager dam = new DataAccessManager(); string[,] paramArray = { { "@OrderId", All?null:OrderId }, { "@CompanyId", All?null:CompanyId} , { "@StartDate", All?null:Common.FormateDateForDB(StartDate)} , { "@EndDate", All?null:Common.FormateDateForDB(EndDate)} }; ds = dam.GetDataSet(CommandType.StoredProcedure, "SelectOrderandOrderDetails", paramArray); if (ds != null && ds.Tables.Count == 2) { ds.Tables[0].TableName = "Order"; ds.Tables[1].TableName = "OrderDetail"; DataRelation relation = new DataRelation("Order_OrderDetail" , ds.Tables["Order"].Columns["Id"], ds.Tables["OrderDetail"].Columns["OrderId"]); ds.Relations.Add(relation); } return ds; }
public DataSet DailySalePurchaseReport(DateTime? StartDate, DateTime? EndDate, Int32 InDetail) { DataSet ds = null; try { string[,] paramArray = { {"@StartDate", Common.FormateDateForDB(StartDate)}, {"@EndDate", Common.FormateDateForDB(EndDate)}, {"@InDetail", InDetail.ToString()} }; DataAccessManager dam = new DataAccessManager(); ds = dam.GetDataSet(CommandType.StoredProcedure, "Report_DailySalesPurchaseReport", paramArray); } catch (Exception ex) { throw ex; } return ds; }
public DataSet DailySalePurchaseProductSummaryReport(DateTime? StartDate, DateTime? EndDate, string Id) { DataSet ds = null; try { if (string.IsNullOrEmpty(Id)) Id = "0"; string[,] paramArray = { {"@StartDate", Common.FormateDateForDB(StartDate)}, {"@EndDate", Common.FormateDateForDB(EndDate)}, {"@Id", Id} }; DataAccessManager dam = new DataAccessManager(); ds = dam.GetDataSet(CommandType.StoredProcedure, "Report_ProductTransactionReport", paramArray); } catch (Exception ex) { throw ex; } return ds; }
public DataSet SelectAllCompaniesWithItems() { DataSet ds = new DataSet(); DataAccessManager dam = new DataAccessManager(); ds = dam.GetDataSet(CommandType.StoredProcedure, "SelectCompanyProducts"); if (ds != null && ds.Tables.Count == 2) { ds.Tables[0].TableName = "Company"; ds.Tables[1].TableName = "Item"; DataRelation relation = new DataRelation("Company_Item" , ds.Tables["Company"].Columns["CompanyId"], ds.Tables["Item"].Columns["CompanyId"]); ds.Relations.Add(relation); } return ds; }
public DataSet SelectReceiptandReceiptDetails(string ReceiptId, string CustomerId, DateTime StartDate, DateTime EndDate, bool All) { DataSet ds = new DataSet(); try { DataAccessManager dam = new DataAccessManager(); string[,] paramArray = { { "@ReceiptId", All?null:ReceiptId }, { "@CustomerId", All?null:CustomerId} , { "@StartDate", All?null:Common.FormateDateForDB(StartDate)} , { "@EndDate", All?null:Common.FormateDateForDB(EndDate)} }; ds = dam.GetDataSet(CommandType.StoredProcedure, "SelectReceiptandReceiptDetails", paramArray); if (ds != null && ds.Tables.Count == 2) { ds.Tables[0].TableName = "Receipt"; ds.Tables[1].TableName = "ReceiptDetail"; DataRelation relation = new DataRelation("Receipt_ReceiptDetail" , ds.Tables["Receipt"].Columns["Id"], ds.Tables["ReceiptDetail"].Columns["ReceiptId"]); ds.Relations.Add(relation); } } catch (Exception ex) { throw ex; } return ds; }
public DataSet SelectInvoiceandInvoiceDetails(string InvoiceId, string CompanyId, string StartDate, string EndDate, bool All) { DataSet ds = new DataSet(); try { if (string.IsNullOrEmpty(InvoiceId)) InvoiceId = null; if (string.IsNullOrEmpty(CompanyId)) CompanyId = null; DataAccessManager dam = new DataAccessManager(); string[,] paramArray = { { "@InvoiceId", All?null:InvoiceId }, { "@CompanyId", All?null:CompanyId} , { "@StartDate", StartDate} , { "@EndDate", EndDate} }; ds = dam.GetDataSet(CommandType.StoredProcedure, "SelectInvoiceandInvoiceDetails", paramArray); if (ds != null && ds.Tables.Count == 2) { ds.Tables[0].TableName = "Invoice"; ds.Tables[1].TableName = "InvoiceDetail"; DataRelation relation = new DataRelation("Invoice_InvoiceDetail" , ds.Tables["Invoice"].Columns["Id"], ds.Tables["InvoiceDetail"].Columns["InvoiceId"]); ds.Relations.Add(relation); } } catch (Exception ex) { throw ex; } return ds; }