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_CustomerTags" + "_" + 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_GetCustomerItemTagsForExport]", 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;
}
}
protected void ButtonCustomerTagsDetail_Click(object sender, System.EventArgs e)
{
try
{
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = GetStoreID;
aspxCommonObj.PortalID = GetPortalID;
aspxCommonObj.UserName = HdnGridData.Value;
aspxCommonObj.CultureName = GetCurrentCultureName;
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
string filename = "MyReport_StoreOrder" + "_" + 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_ShowCustomerTagListForExport]", parameter, filePath);
}
catch (Exception ex)
{
ProcessException(ex);
}
}
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 <RssFeedItemInfo> GetItemRssContent(AspxCommonInfo aspxCommonObj, string rssOption, int count)
{
try
{
var rssFeedContent = new List <RssFeedItemInfo>();
List <KeyValuePair <string, object> > Parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
Parameter.Add(new KeyValuePair <string, object>("@Count", count));
SQLHandler SQLH = new SQLHandler();
switch (rssOption)
{
case "specialitems":
rssFeedContent = SQLH.ExecuteAsList <RssFeedItemInfo>("[dbo].[usp_Aspx_GetRssFeedSpecialItem]", Parameter);
break;
}
return(rssFeedContent);
}
catch (Exception ex)
{
throw ex;
}
}
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);
}
}
public static void NotificationSaveUpdateSettings(NotificationSettingsInfo saveUpdateInfo, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@AllActive", saveUpdateInfo.AllActive));
parameterCollection.Add(new KeyValuePair <string, object>("@UserNotificationActive", saveUpdateInfo.UserNotificationActive));
parameterCollection.Add(new KeyValuePair <string, object>("@UserNotificationCount", saveUpdateInfo.UserNotificationCount));
parameterCollection.Add(new KeyValuePair <string, object>("@SubscriptionNotificationActive ", saveUpdateInfo.SubscriptionNotificationActive));
parameterCollection.Add(new KeyValuePair <string, object>("@SubscriptionNotificationCount", saveUpdateInfo.SubscriptionNotificationCount));
parameterCollection.Add(new KeyValuePair <string, object>("@OutofStockNotificationActive", saveUpdateInfo.OutofStockNotificationActive));
parameterCollection.Add(new KeyValuePair <string, object>("@OutofStockNotificationCount", saveUpdateInfo.OutofStockNotificationCount));
parameterCollection.Add(new KeyValuePair <string, object>("@ItemsLowStockNotificationActive", saveUpdateInfo.ItemsLowStockNotificationActive));
parameterCollection.Add(new KeyValuePair <string, object>("@ItemsLowStockCount", saveUpdateInfo.ItemsLowStockCount));
parameterCollection.Add(new KeyValuePair <string, object>("@OrdersNotificationAtive", saveUpdateInfo.OrdersNotificationAtive));
parameterCollection.Add(new KeyValuePair <string, object>("@OrdersNotificationCount", saveUpdateInfo.OrdersNotificationCount));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_NotificationSaveUpdateSettings]", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
//------------------get items by dyanamic Advance serach-----------------------
public List <AdvanceSearchDetailsInfo> GetItemsByDyanamicAdvanceSearch(int offset, int limit, AspxCommonInfo aspxCommonObj, ItemsByDynamicAdvanceSearchInfo searchObj)
{
string spName = string.Empty;
try
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("offset", offset));
parameter.Add(new KeyValuePair <string, object>("limit", limit));
parameter.Add(new KeyValuePair <string, object>("CategoryID", searchObj.CategoryID));
parameter.Add(new KeyValuePair <string, object>("IsGiftCard", searchObj.IsGiftCard));
parameter.Add(new KeyValuePair <string, object>("SearchText", searchObj.SearchText));
parameter.Add(new KeyValuePair <string, object>("BrandID", searchObj.BrandID));
parameter.Add(new KeyValuePair <string, object>("PriceFrom", searchObj.PriceFrom));
parameter.Add(new KeyValuePair <string, object>("PriceTo", searchObj.PriceTo));
parameter.Add(new KeyValuePair <string, object>("Attributes", searchObj.AttributeIDs));
parameter.Add(new KeyValuePair <string, object>("RowTotal", searchObj.RowTotal));
OracleHandler sqlH = new OracleHandler();
if (searchObj.SortBy == 1)
{
spName = "[dbo].[usp_Aspx_AdvanceSearchSortByItemIDDesc]";
}
else if (searchObj.SortBy == 2)
{
spName = "[dbo].[usp_Aspx_AdvanceSearchSortByItemID]";
}
else if (searchObj.SortBy == 3)
{
spName = "[dbo].[usp_Aspx_AdvanceSearchSortByPriceDesc]";
}
else if (searchObj.SortBy == 4)
{
spName = "[dbo].[usp_Aspx_AdvanceSearchSortByPrice]";
}
else if (searchObj.SortBy == 5)
{
spName = "[dbo].[usp_Aspx_AdvanceSearchSortByName]";
}
else if (searchObj.SortBy == 6)
{
spName = "[dbo].[usp_Aspx_AdvanceSearchSortByViewCount]";
}
else if (searchObj.SortBy == 7)
{
spName = "[dbo].[usp_Aspx_AdvanceSearchSortByIsFeatured]";
}
else if (searchObj.SortBy == 8)
{
spName = "[dbo].[usp_Aspx_AdvanceSearchSortByIsSpecial]";
}
else if (searchObj.SortBy == 9)
{
spName = "[dbo].[usp_Aspx_AdvanceSearchSortBySoldItem]";
}
else if (searchObj.SortBy == 10)
{
spName = "[dbo].[usp_Aspx_AdvanceSearchSortByDiscount]";
}
else if (searchObj.SortBy == 11)
{
spName = "usp_Aspx_AdvanceSearchSortByRatedValue";
}
List <AdvanceSearchDetailsInfo> lstAdvanceSearch = sqlH.ExecuteAsList <AdvanceSearchDetailsInfo>(spName, parameter);
return(lstAdvanceSearch);
}
catch (Exception e)
{
throw e;
}
}
public List <SpecialItemsInfo> GetAllSpecialItems(int offset, int limit, AspxCommonInfo aspxCommonObj, int sortBy, int rowTotal)
{
string spName = string.Empty;
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset));
parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit));
parameterCollection.Add(new KeyValuePair <string, object>("@RowTotal", rowTotal));
SQLHandler sqlH = new SQLHandler();
if (sortBy == 1)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortByItemIDDesc]";
}
else if (sortBy == 2)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortByItemIDAsc]";
}
else if (sortBy == 3)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortByPriceDesc]";
}
else if (sortBy == 4)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortByPriceAsc]";
}
else if (sortBy == 5)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortByName]";
}
else if (sortBy == 6)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortByViewCount]";
}
else if (sortBy == 7)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortByIsFeatured]";
}
else if (sortBy == 8)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortByIsSpecial]";
}
else if (sortBy == 9)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortBySoldItem]";
}
else if (sortBy == 10)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortByDiscount]";
}
else if (sortBy == 11)
{
spName = "[dbo].[usp_Aspx_GetSpecialItemDetailsSortByRatedValue]";
}
List <SpecialItemsInfo> lstCatDetail = sqlH.ExecuteAsList <SpecialItemsInfo>(spName, parameterCollection);
return(lstCatDetail);
}
catch (Exception e)
{
throw e;
}
}
public static List <ItemBasicDetailsInfo> GetUserTaggedItems(int offset, int limit, string tagIDs, int SortBy, int rowTotal, AspxCommonInfo aspxCommonObj)
{
string spName = string.Empty;
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset));
parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit));
parameterCollection.Add(new KeyValuePair <string, object>("@TagIDs", tagIDs));
parameterCollection.Add(new KeyValuePair <string, object>("@RowTotal", rowTotal));
SQLHandler sqlH = new SQLHandler();
if (SortBy == 1)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortByItemIDDesc]";
}
else if (SortBy == 2)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortByItemIDAsc]";
}
else if (SortBy == 3)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortByPriceDesc]";
}
else if (SortBy == 4)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortByPriceAsc]";
}
else if (SortBy == 5)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortByName]";
}
else if (SortBy == 6)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortByViewCount]";
}
else if (SortBy == 7)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortByIsFeatured]";
}
else if (SortBy == 8)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortByIsSpecial]";
}
else if (SortBy == 9)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortBySoldItem]";
}
else if (SortBy == 10)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortByDiscount]";
}
else if (SortBy == 11)
{
spName = "[dbo].[usp_Aspx_GetItemsByTagIDSortByRatedValue]";
}
List <ItemBasicDetailsInfo> lstItemBasic = sqlH.ExecuteAsList <ItemBasicDetailsInfo>(spName, parameterCollection);
return(lstItemBasic);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ItemBasicDetailsInfo> GetUserTaggedItems(int offset, int limit, string tagIDs, int SortBy, int rowTotal, AspxCommonInfo aspxCommonObj)
{
List <ItemBasicDetailsInfo> itemBasicDetailsInfos;
string empty = string.Empty;
try
{
List <KeyValuePair <string, object> > paramSPUC = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
paramSPUC.Add(new KeyValuePair <string, object>("@offset", (object)offset));
paramSPUC.Add(new KeyValuePair <string, object>("@limit", (object)limit));
paramSPUC.Add(new KeyValuePair <string, object>("@TagIDs", tagIDs));
paramSPUC.Add(new KeyValuePair <string, object>("@RowTotal", (object)rowTotal));
OracleHandler sQLHandler = new OracleHandler();
if (SortBy == 1)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortByItemIDDesc]";
}
else if (SortBy == 2)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortByItemIDAsc]";
}
else if (SortBy == 3)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortByPriceDesc]";
}
else if (SortBy == 4)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortByPriceAsc]";
}
else if (SortBy == 5)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortByName]";
}
else if (SortBy == 6)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortByViewCount]";
}
else if (SortBy == 7)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortByIsFeatured]";
}
else if (SortBy == 8)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortByIsSpecial]";
}
else if (SortBy == 9)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortBySoldItem]";
}
else if (SortBy == 10)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortByDiscount]";
}
else if (SortBy == 11)
{
empty = "[dbo].[usp_Aspx_GetItemsByTagIDSortByRatedValue]";
}
itemBasicDetailsInfos = sQLHandler.ExecuteAsList <ItemBasicDetailsInfo>(empty, paramSPUC);
}
catch (Exception exception)
{
throw exception;
}
return(itemBasicDetailsInfos);
}
