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;
}
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;
}
