public static string getStoreJson(string cityName)
{
SalesDetailBLL eBLL = new SalesDetailBLL();
DataTable dtData = eBLL.GetStoreData(cityName);
return(JsonHelper.DataTableToJson(dtData));
}
public static string GetExcelData()
{
try
{
SalesDetailBLL sdBLL = new SalesDetailBLL();
DataTable dt;
string jsonString = string.Empty;
dt = sdBLL.GetSalesDatailData();
// Convert to json string and Dispose
if (dt != null)
{
//jsonString = JsonHelper.JsonSerializer(dt);
jsonString = JsonHelper.DataTableToJson(dt);
dt.Dispose();
dt = null;
}
// sdBLL = null;
//TextBox1.Text = jsonString;
if (!string.Equals(jsonString, string.Empty))
{
return(jsonString);
}
else
{
return("[]");
}
}
catch (Exception ex)
{
throw ex;
}
}
private DataTable getStoreData(string cityName)
{
SalesDetailBLL eBLL = new SalesDetailBLL();
DataTable dtData = eBLL.GetStoreData(cityName);
return(dtData);
}
private DataTable GetProdGroup()
{
SalesDetailBLL eBLL = new SalesDetailBLL();
DataTable dtData = eBLL.GetProdGroupData();
return(dtData);
}
public static string GetData()
{
//try
//{
SalesDetailBLL sdBLL = new SalesDetailBLL();
DataTable dt;
string jsonString = string.Empty;
dt = sdBLL.GetSalesDatailData();
// Convert to json string and Dispose
//if (dt != null)
//{
jsonString = JsonHelper.DataTableToJson(dt);
// dt.Dispose();
// dt = null;
//}
// sdBLL = null;
//TextBox1.Text = jsonString;
if (!string.Equals(jsonString, string.Empty))
{
return(jsonString);
}
else
{
return("");
}
//}
//catch (Exception)
//{
// throw;
//}
}
public Sale MakeNewSale(Sale data, List <SaleDetail> saleDetails)
{
var salesBLL = new SalesBLL();
var salesDetailBLL = new SalesDetailBLL();
var newSale = salesBLL.MakeSale(data);
foreach (var item in saleDetails)
{
item.Id_sale = newSale.Id_sales;
salesDetailBLL.MakeSale(item);
}
return(newSale);
}
public static string QueryGridDapper(string dateFrom, string dateTo, string prodGroup, string cityName, string storeNo)
{
try
{
SalesDetailBLL sdBLL = new SalesDetailBLL();
string jsonString = JsonHelper.ObjToJson(sdBLL.GetSalesDetailList(dateFrom, dateTo, prodGroup, cityName, storeNo));
return(jsonString);
}
catch (Exception ex)
{
LogHelper.Error(ex.Message, ex);
throw;
}
}
public static string QueryGrid(string dateFrom, string dateTo, string prodGroup, string cityName, string storeNo)
{
try
{
//if (initFlag == "Y")
// return "[]";
SalesDetailBLL sdBLL = new SalesDetailBLL();
DataTable dt;
string jsonString = string.Empty;
dt = sdBLL.GetSalesDatailData(dateFrom, dateTo, prodGroup, cityName, storeNo);
// Convert to json string and Dispose
if (dt != null)
{
//jsonString = JsonHelper.JsonSerializer(dt);
jsonString = JsonHelper.DataTableToJson(dt);
dt.Dispose();
dt = null;
}
// sdBLL = null;
//TextBox1.Text = jsonString;
if (!string.Equals(jsonString, string.Empty))
{
return(jsonString);
}
else
{
return("[]");
}
}
catch (Exception ex)
{
LogHelper.Error(ex.Message, ex);
throw;
}
}
