protected void ButtonCustomerTags_Click(object sender, System.EventArgs e)
{
try
{
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = GetStoreID;
aspxCommonObj.PortalID = GetPortalID;
aspxCommonObj.CultureName = GetCurrentCultureName;
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
string filename = "MyReport_CustomerTags" + "_" + DateTime.Now.ToString("M_dd_yyyy_H_M_s") + ".csv";
string filePath = HttpContext.Current.Server.MapPath(ResolveUrl(this.AppRelativeTemplateSourceDirectory)) + filename;
ExportLargeData csvLdata = new ExportLargeData();
csvLdata.ExportToCSV(true, ",", "[dbo].[usp_Aspx_GetCustomerItemTagsForExport]", parameter, filePath);
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public void SaveShareWishListEmailMessage(AspxCommonInfo aspxCommonObj, WishItemsEmailInfo wishlistObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@ItemIDs", wishlistObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("@SenderName", wishlistObj.SenderName));
parameter.Add(new KeyValuePair <string, object>("@SenderEmail", wishlistObj.SenderEmail));
parameter.Add(new KeyValuePair <string, object>("@ReceiverEmailID", wishlistObj.ReceiverEmail));
parameter.Add(new KeyValuePair <string, object>("@Subject", wishlistObj.Subject));
parameter.Add(new KeyValuePair <string, object>("@Message", wishlistObj.Message));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("[usp_Aspx_SaveShareWishListEmail]", parameter);
}
catch (Exception e)
{
throw e;
}
}
public List <ServiceItemInfo> GetServiceItemInfo(AspxCommonInfo aspxCommonObj, int categoryId)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("Option", "serviceInfo"));
parameter.Add(new KeyValuePair <string, object>("CategoryID", (object)categoryId));
OracleHandler sqlH = new OracleHandler();
List <ServiceItemInfo> serviceInfo = sqlH.ExecuteAsList <ServiceItemInfo>("usp_Aspx_GetServiceItemInfo", parameter);
parameter.Remove(new KeyValuePair <string, object>("Option", "serviceInfo"));
foreach (ServiceItemInfo serviceItemInfo in serviceInfo)
{
parameter.Add(new KeyValuePair <string, object>("Option", "serviceEmployeeData"));
parameter.Add(new KeyValuePair <string, object>("ServiceID", (object)serviceItemInfo.ServiceId));
List <ServiceEmployeeInfo> serviceEmployeeDataInfo = sqlH.ExecuteAsList <ServiceEmployeeInfo>("usp_Aspx_GetServiceItemInfo", parameter);
serviceItemInfo.EmployeeData = serviceEmployeeDataInfo;
parameter.Remove(new KeyValuePair <string, object>("Option", "serviceEmployeeData"));
parameter.Remove(new KeyValuePair <string, object>("ServiceID", (object)serviceItemInfo.ServiceId));
foreach (ServiceEmployeeInfo serviceEmployeeInfo in serviceEmployeeDataInfo)
{
parameter.Add(new KeyValuePair <string, object>("Option", "serviceDate"));
parameter.Add(new KeyValuePair <string, object>("ServiceID", (object)serviceItemInfo.ServiceId));
parameter.Add(new KeyValuePair <string, object>("ServiceEmployeeID", (object)serviceEmployeeInfo.ServiceEmployeeId));
List <ServiceDateInfo> serviceDateInfo = sqlH.ExecuteAsList <ServiceDateInfo>("usp_Aspx_GetServiceItemInfo", parameter);
serviceEmployeeInfo.AvailableDate = serviceDateInfo;
parameter.Remove(new KeyValuePair <string, object>("Option", "serviceDate"));
parameter.Remove(new KeyValuePair <string, object>("ServiceID", (object)serviceItemInfo.ServiceId));
parameter.Remove(new KeyValuePair <string, object>("ServiceEmployeeID", (object)serviceEmployeeInfo.ServiceEmployeeId));
foreach (ServiceDateInfo dateInfo in serviceDateInfo)
{
parameter.Add(new KeyValuePair <string, object>("Option", "serviceTime"));
parameter.Add(new KeyValuePair <string, object>("ServiceDateID", (object)dateInfo.ServiceDateId));
parameter.Add(new KeyValuePair <string, object>("ServiceEmployeeID", (object)serviceEmployeeInfo.ServiceEmployeeId));
dateInfo.ServiceTime = sqlH.ExecuteAsList <ServiceTimeInfo>("usp_Aspx_GetServiceItemInfo", parameter);
parameter.Remove(new KeyValuePair <string, object>("Option", "serviceTime"));
parameter.Remove(new KeyValuePair <string, object>("ServiceDateID", (object)dateInfo.ServiceDateId));
parameter.Remove(new KeyValuePair <string, object>("ServiceEmployeeID", (object)serviceEmployeeInfo.ServiceEmployeeId));
}
}
}
return(serviceInfo);
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
DataTable resultsData = new DataTable();
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = GetStoreID;
aspxCommonObj.PortalID = GetPortalID;
aspxCommonObj.CultureName = GetCurrentCultureName;
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
string filename = "MyReport_DownloadableItems" + "_" + DateTime.Now.ToString("M_dd_yyyy_H_M_s") + ".xls";
string filePath = HttpContext.Current.Server.MapPath(ResolveUrl(this.AppRelativeTemplateSourceDirectory)) + filename;
ExportLargeData excelLdata = new ExportLargeData();
excelLdata.ExportTOExcel(filePath, "[dbo].[usp_Aspx_GetDownloadableItemsForExport]", parameter, resultsData);
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public static List <OutOfStockInfo> NotificationitemsGetAll(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
NotificationItemList ih = new NotificationItemList();
SQLHandler sqLH = new SQLHandler();
DataSet ds = sqLH.ExecuteAsDataSet("[dbo].[usp_Aspx_NotificationItemsGetAll]", parameterCollection);
List <OutOfStockInfo> OutOfStockDetails = new List <OutOfStockInfo>();
if (ds.Tables.Count > 0)
{
OutOfStockDetails = DataSourceHelper.FillCollection <OutOfStockInfo>(ds.Tables[0]);
}
return(OutOfStockDetails);
}
catch (Exception e)
{
throw e;
}
}
public List <ServiceAvailableTime> GetServiceAvailableTime(GetServiceAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@CategoryID", getServiceTimeObj.CategoryID));
parameter.Add(new KeyValuePair <string, object>("@BranchID", getServiceTimeObj.BranchID));
parameter.Add(new KeyValuePair <string, object>("@EmployeeID", getServiceTimeObj.EmployeeID));
parameter.Add(new KeyValuePair <string, object>("@ServiceDateID", getServiceTimeObj.ServiceDateID));
parameter.Add(new KeyValuePair <string, object>("@ServiceDate", getServiceTimeObj.ServiceDate));
parameter.Add(new KeyValuePair <string, object>("@ItemID", getServiceTimeObj.ItemID));
SQLHandler sqlh = new SQLHandler();
List <ServiceAvailableTime> lstServTime = sqlh.ExecuteAsList <ServiceAvailableTime>("[dbo].[usp_Aspx_GetServiceTime]", parameter);
return(lstServTime);
}
catch (Exception e)
{
throw e;
}
}
public List <ServiceAvailableTime> GetServiceAvailableTime(GetServiceAvailableTime getServiceTimeObj, AspxCommonInfo aspxCommonObj)
{
List <ServiceAvailableTime> serviceAvailableTimes;
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("CategoryID", (object)getServiceTimeObj.CategoryID));
parameter.Add(new KeyValuePair <string, object>("BranchID", (object)getServiceTimeObj.BranchID));
parameter.Add(new KeyValuePair <string, object>("EmployeeID", (object)getServiceTimeObj.EmployeeID));
parameter.Add(new KeyValuePair <string, object>("ServiceDateID", getServiceTimeObj.ServiceDateID));
parameter.Add(new KeyValuePair <string, object>("ServiceDate", getServiceTimeObj.ServiceDate));
parameter.Add(new KeyValuePair <string, object>("ItemID", (object)getServiceTimeObj.ItemID));
serviceAvailableTimes = (new OracleHandler()).ExecuteAsList <ServiceAvailableTime>("usp_Aspx_GetServiceTime", parameter);
}
catch (Exception exception)
{
throw exception;
}
return(serviceAvailableTimes);
}
protected void ButtonCustomerByOrder_Click(object sender, System.EventArgs e)
{
try
{
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = GetStoreID;
aspxCommonObj.PortalID = GetPortalID;
aspxCommonObj.CultureName = GetCurrentCultureName;
StoreSettingConfig ssc = new StoreSettingConfig();
string CurrencyCode = ssc.GetStoreSettingsByKey(StoreSetting.MainCurrency, GetStoreID, GetPortalID, CultureName);
string CurrencySymbol = StoreSetting.GetSymbolFromCurrencyCode(CurrencyCode, GetStoreID, GetPortalID);
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@CurrencySymbol", CurrencySymbol));
string filename = "MyReport_CustomerByTotalOrder" + "_" + DateTime.Now.ToString("M_dd_yyyy_H_M_s") + ".csv";
string filePath = HttpContext.Current.Server.MapPath(ResolveUrl(this.AppRelativeTemplateSourceDirectory)) + filename;
ExportLargeData csvLdata = new ExportLargeData();
csvLdata.ExportToCSV(true, ",", "[dbo].[usp_Aspx_GetCustomerOrderTotalForExport]", parameter, filePath);
}
catch (Exception ex)
{
ProcessException(ex);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
DataTable resultsData = new DataTable();
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = GetStoreID;
aspxCommonObj.PortalID = GetPortalID;
aspxCommonObj.CultureName = GetCurrentCultureName;
StoreSettingConfig ssc = new StoreSettingConfig();
string CurrencyCode = ssc.GetStoreSettingsByKey(StoreSetting.MainCurrency, GetStoreID, GetPortalID, CultureName);
string CurrencySymbol = StoreSetting.GetSymbolFromCurrencyCode(CurrencyCode, GetStoreID, GetPortalID);
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@CurrencySymbol", CurrencySymbol));
string filename = "MyReport_StoreShipping" + "_" + DateTime.Now.ToString("M_dd_yyyy_H_M_s") + ".xls";
string filePath = HttpContext.Current.Server.MapPath(ResolveUrl(this.AppRelativeTemplateSourceDirectory)) + filename;
ExportLargeData excelLdata = new ExportLargeData();
string showReport = HdnValue.Value;
if (showReport == "1")
{
excelLdata.ExportTOExcel(filePath, "[dbo].[usp_Aspx_ShippingReportDetailsForExport]", parameter, resultsData);
}
else if (showReport == "2")
{
excelLdata.ExportTOExcel(filePath, "[dbo].[usp_Aspx_GetShippingDetailsByCurrentMonthForExport]", parameter, resultsData);
}
else
{
excelLdata.ExportTOExcel(filePath, "[dbo].[usp_Aspx_GetShippingReportDetailsBy24hoursForExport]", parameter, resultsData);
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}