protected void Button1_Click(object sender, EventArgs e)
{
try
{
DataTable resultsData = new DataTable();
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = GetStoreID;
aspxCommonObj.PortalID = GetPortalID;
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.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@CurrencySymbol", CurrencySymbol));
string filename = "MyReport_ReturnReport" + "_" + 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_GetReturnReportForExport]", parameter, resultsData);
}
else if (showReport == "2")
{
excelLdata.ExportTOExcel(filePath, "[dbo].[usp_Aspx_GetReturnReportByCurrentMonthForExport]", parameter, resultsData);
}
else
{
excelLdata.ExportTOExcel(filePath, "[dbo].[usp_Aspx_GetReturnReportBy24hoursForExport]", parameter, resultsData);
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public List <SearchTermList> GetSearchedTermList(string search, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSP(aspxCommonObj);
paramCol.Add(new KeyValuePair <string, object>("Search", search));
OracleHandler sageSQL = new OracleHandler();
List <SearchTermList> srInfo = sageSQL.ExecuteAsList <SearchTermList>("usp_Aspx_GetListSearched", paramCol);
return(srInfo);
}
public void SaveAndUpdateCompareItemsSetting(AspxCommonInfo aspxCommonObj, CompareItemsSettingKeyPairInfo compareItems)
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@SettingKeys", compareItems.SettingKey));
parameterCollection.Add(new KeyValuePair <string, object>("@SettingValues", compareItems.SettingValue));
SQLHandler sqlhandle = new SQLHandler();
sqlhandle.ExecuteNonQuery("[dbo].[usp_Aspx_CompareItemSettingsUpdate]", parameterCollection);
}
public void ServiceItemSettingUpdate(string SettingValues, string SettingKeys, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSP(aspxCommonObj);
paramCol.Add(new KeyValuePair <string, object>("SettingKeys", SettingKeys));
paramCol.Add(new KeyValuePair <string, object>("SettingValues", SettingValues));
(new OracleHandler()).ExecuteNonQuery("usp_Aspx_ServiceItemSettingsUpdate", paramCol);
}
catch (Exception exception)
{
throw exception;
}
}
public static NotificationGetAllInfo NotificationGetAll(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
NotificationGetAllInfo listInfo = sqlH.ExecuteAsObject <NotificationGetAllInfo>("[dbo].[usp_Aspx_NotificationGetAll]", parameterCollection);
return(listInfo);
}
catch (Exception e)
{
throw e;
}
}
public void ServiceItemSettingUpdate(string SettingValues, string SettingKeys, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSP(aspxCommonObj);
paramCol.Add(new KeyValuePair <string, object>("@SettingKeys", SettingKeys));
paramCol.Add(new KeyValuePair <string, object>("@SettingValues", SettingValues));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("[dbo].[usp_Aspx_ServiceItemSettingsUpdate]", paramCol);
}
catch (Exception ex)
{
throw ex;
}
}
public List <StoreLocatorInfo> GetAllStoresForService(AspxCommonInfo aspxCommonObj, int?serviceCategoryId)
{
List <StoreLocatorInfo> storeLocatorInfos;
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("ServiceID", (object)serviceCategoryId));
try
{
storeLocatorInfos = (new OracleHandler()).ExecuteAsList <StoreLocatorInfo>("usp_Aspx_GetAllStoreForService", parameterCollection);
}
catch (Exception exception)
{
throw exception;
}
return(storeLocatorInfos);
}
public void LatestItemSettingUpdate(string SettingValues, string SettingKeys, AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("SettingKeys", SettingKeys));
parameterCollection.Add(new KeyValuePair <string, object>("SettingValues", SettingValues));
OracleHandler sqLH = new OracleHandler();
sqLH.ExecuteNonQuery("usp_Aspx_LatestItemSettingsUpdate", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}
public List <StoreLocatorInfo> GetAllStoresForService(AspxCommonInfo aspxCommonObj, int?serviceCategoryId)
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameterCollection.Add(new KeyValuePair <string, object>("@ServiceID", serviceCategoryId));
try
{
SQLHandler sqlH = new SQLHandler();
List <StoreLocatorInfo> lstStoreLocator = sqlH.ExecuteAsList <StoreLocatorInfo>("[dbo].[usp_Aspx_GetAllStoreForService]", parameterCollection);
return(lstStoreLocator);
}
catch (Exception e)
{
throw e;
}
}
protected void ButtonCustomerReview_Click(object sender, System.EventArgs e)
{
try
{
AspxCommonInfo aspxCommonObj = new AspxCommonInfo();
aspxCommonObj.StoreID = GetStoreID;
aspxCommonObj.PortalID = GetPortalID;
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
string filename = "MyReport_CustomerReview" + "_" + 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_GetCustomerReviewsForExport]", 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;
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
string filename = "MyReport_ItemsTags" + "_" + 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_GetItemTagsDetailsForExport]", parameter, resultsData);
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public static List <SubscriptionInfo> NotificationUsersGetAll(AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
SQLHandler sqLH = new SQLHandler();
DataSet ds = sqLH.ExecuteAsDataSet("[dbo].[usp_Aspx_NotificationUsersGetAll]", parameterCollection);
List <SubscriptionInfo> SubscriptionDetails = new List <SubscriptionInfo>();
if (ds.Tables.Count > 0)
{
SubscriptionDetails = DataSourceHelper.FillCollection <SubscriptionInfo>(ds.Tables[0]);
}
return(SubscriptionDetails);
}
catch (Exception e)
{
throw e;
}
}