public static void SaveGiftCardByAdmin(int giftCardId, GiftCard giftCardDetail, bool isActive, AspxCommonInfo aspxCommonObj)
{
try
{
AspxGiftCardProvider.SaveGiftCardByAdmin(giftCardId, giftCardDetail, isActive, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
public static bool SendEmailForGiftCard(int portalId, int storeId, string cultureName, GiftCard giftCardinfo)
{
bool isemailSent = true;
StoreSettingConfig ssc = new StoreSettingConfig();
// sendEmailFrom = ssc.GetStoreSettingsByKey(StoreSetting.SendEcommerceEmailsFrom, storeID, portalID, "en-US");
string sendOrderNotice = ssc.GetStoreSettingsByKey(StoreSetting.SendOrderNotification, storeId, portalId,
cultureName);
string logosrc = ssc.GetStoreSettingsByKey(StoreSetting.StoreLogoURL, storeId, portalId, cultureName);
string inquiry = ssc.GetStoreSettingsByKey(StoreSetting.SendEcommerceEmailsFrom, storeId, portalId,
cultureName);
string storeName = ssc.GetStoreSettingsByKey(StoreSetting.StoreName, storeId, portalId, cultureName);
if (bool.Parse(sendOrderNotice))
{
// MessageTemplateDataContext dbMessageTemplate = new MessageTemplateDataContext(SystemSetting.SageFrameConnectionString);
// MessageTokenDataContext messageTokenDB = new MessageTokenDataContext(SystemSetting.SageFrameConnectionString);
SageFrameConfig pagebase = new SageFrameConfig();
// var template = dbMessageTemplate.sp_MessageTemplateByMessageTemplateTypeID(SystemSetting.ORDER_PLACED, portalId).SingleOrDefault();
string messageTemplate =
"<table width='650' cellspacing='5' cellpadding='0' border='0' bgcolor='#e0e0e0' align='center' style='font:12px Arial, Helvetica, sans-serif;'> <tbody> <tr> <td valign='top' align='center'> <table width='680' cellspacing='0' cellpadding='0' border='0'> <tbody> <tr> <td><img width='1' height='10' src='http://%ServerPath%/blank.gif' alt=' ' /></td> </tr> <tr> <td> <table width='680' cellspacing='0' cellpadding='0' border='0'> <tbody> <tr> <td width='300'><a href='http://%ServerPath%' target='_blank' style='outline:none; border:none;'><img width='143' height='62' src='%LogoSource%' alt='Logo' title='Logo' /></a></td> <td width='191' valign='middle' align='left'> </td> <td width='189' valign='middle' align='right'><b style='padding:0 20px 0 0; text-shadow:1px 1px 0 #fff;'> Date: %DateTime%</b></td> </tr> </tbody> </table> </td> </tr> <tr> <td><img width='1' height='10' src='http://%ServerPath%/blank.gif' alt=' ' /></td> </tr> <tr> <td bgcolor='#fff'> <div style='border:1px solid #c7c7c7; background:#fff; padding:20px'> <table width='650' cellspacing='0' cellpadding='0' border='0' bgcolor='#FFFFFF'> <tbody> <tr> <td> <p style='font-family:Arial, Helvetica, sans-serif; font-size:17px; line-height:16px; color:#278ee6; margin:0; padding:0 0 10px 0; font-weight:bold; text-align:left;'> Dear %RecipientName% </p> <p style='margin:0; padding:10px 0 0 0; font:bold 11px Arial, Helvetica, sans-serif; color:#666;'>You've got gift card from %SenderName% and it is now ready to be used for purchases at our store <a href='%ServerPath%' >%ServerPath%<a></p> </td> </tr> <tr> <td> <p style='margin:0; padding:10px 0 0 0; font:bold 11px Arial, Helvetica, sans-serif; color:#666;'>Gift Card Details</p> </td> </tr> <tr> <td> <p style='margin:0; padding:10px 0 0 0; font:bold 11px Arial, Helvetica, sans-serif; color:#666;'>Gift Card Code : %GiftCardCode%</p> <p style='margin:0; padding:10px 0 0 0; font:bold 11px Arial, Helvetica, sans-serif; color:#666;'>Gift Card PinCode :****%PinCode%****</p> <p style='margin:0; padding:10px 0 0 0; font:bold 11px Arial, Helvetica, sans-serif; color:#666;'>Balance : %Balance%</p> <p style='margin:0; padding:10px 0 0 0; font:bold 11px Arial, Helvetica, sans-serif; color:#666;'>Expiry Date : %ExpiryDate%</p> <p style='margin:0; padding:10px 0 0 0; font:bold 11px Arial, Helvetica, sans-serif; color:#666;'>Message from Sender : %Message%</p> </td> </tr> <tr> <td> <p style='margin:0; padding:10px 0 0 0; font:bold 11px Arial, Helvetica, sans-serif; color:#666;'>Have a great shopping!</p> </td> </tr> </tbody> </table> <p style='margin:0; padding:10px 0 0 0; font:bold 11px Arial, Helvetica, sans-serif; color:#666;'>Thank You<br /> <span style='font-weight:normal; font-size:12px; font-family:Arial, Helvetica, sans-serif;'>AspxCommerce Team </span></p> </div> </td> </tr> <tr> <td><img width='1' height='20' src='http://%ServerPath%/blank.gif' alt=' ' /></td> </tr> <tr> <td valign='top' align='center'> <p style='font-size:11px; color:#4d4d4d'>© %DateYear% AspxCommerce. All Rights Reserved.</p> </td> </tr> <tr> <td valign='top' align='center'><img width='1' height='10' src='http://%ServerPath%/blank.gif' alt=' ' /></td> </tr> </tbody> </table> </td> </tr> </tbody> </table> ";
// if (template != null)
// {
string[] tokens = GetAllToken(messageTemplate);
foreach (string token in tokens)
{
switch (token)
{
case "%DateYear%":
messageTemplate = messageTemplate.Replace(token, DateTime.Now.Year.ToString());
break;
case "%Balance%":
messageTemplate = messageTemplate.Replace(token, giftCardinfo.Balance.ToString());
break;
case "%PinCode%":
messageTemplate = messageTemplate.Replace(token, giftCardinfo.GiftCardPinCode.ToString());
break;
case "%ExpiryDate%":
messageTemplate = messageTemplate.Replace(token, giftCardinfo.ExpireDate.ToString());
break;
case "%RecipientName%":
messageTemplate = messageTemplate.Replace(token, giftCardinfo.RecipientName);
break;
case "%SenderName%":
messageTemplate = messageTemplate.Replace(token, giftCardinfo.SenderName);
break;
case "%GiftCardCode%":
messageTemplate = messageTemplate.Replace(token, giftCardinfo.GiftCardCode);
break;
case "%Message%":
messageTemplate = messageTemplate.Replace(token, giftCardinfo.Messege);
break;
case "%LogoSource%":
// string src = " http://" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/Templates/" + templateName + "/images/aspxcommerce.png";
string src = " http://" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] + "/" +
logosrc;
messageTemplate = messageTemplate.Replace(token, src);
break;
case "%DateTime%":
messageTemplate = messageTemplate.Replace(token, DateTime.Now.ToString("dd MMMM yyyy "));
break;
case "%InquiryEmail%":
string x =
"<a target=\"_blank\" style=\"text-decoration: none;color: #226ab7;font-style: italic;\" href=\"mailto:" +
inquiry + "\" >" + inquiry + "</a>";
messageTemplate = messageTemplate.Replace(token, x);
break;
case "%StoreName%":
messageTemplate = messageTemplate.Replace(token, storeName);
break;
case "%ServerPath%":
string path = " http://" + HttpContext.Current.Request.ServerVariables["SERVER_NAME"] +
"/";
messageTemplate = messageTemplate.Replace(token, path);
break;
}
}
// return messageTemplate;
string emailSuperAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SuperUserEmail);
string emailSiteAdmin = pagebase.GetSettingsByKey(SageFrameSettingKeys.SiteAdminEmailAddress);
try
{
MailHelper.SendMailNoAttachment(giftCardinfo.SenderEmail, giftCardinfo.RecipientEmail,
"You've got a Gift card", messageTemplate, emailSiteAdmin,
emailSuperAdmin);
isemailSent = true;
}
catch (Exception)
{
isemailSent = false;
}
}
return isemailSent;
}
public static int AddItemstoCartFromDetail(AddItemToCartInfo AddItemToCartObj, AspxCommonInfo aspxCommonObj, GiftCard giftCardDetail, CartKit kitInfo)
{
try
{
int retValue = AspxCommonProvider.AddItemstoCartFromDetail(AddItemToCartObj, aspxCommonObj, giftCardDetail, kitInfo);
return retValue;
}
catch (Exception e)
{
throw e;
}
}
public static void SaveGiftCardByAdmin(int giftCardId, GiftCard giftCardDetail, bool isActive, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@GiftCardId", giftCardId));
parameter.Add(new KeyValuePair<string, object>("@GiftCardGraphicsId", giftCardDetail.GraphicThemeId));
parameter.Add(new KeyValuePair<string, object>("@IsRecipientNotified",
giftCardDetail.IsRecipientNotified));
//add column in table expiry date /add default 1 year after/ paid
parameter.Add(new KeyValuePair<string, object>("@ExpireDate", giftCardDetail.ExpireDate));
parameter.Add(new KeyValuePair<string, object>("@Amount", giftCardDetail.Price));
parameter.Add(new KeyValuePair<string, object>("@IsActive", isActive));
parameter.Add(new KeyValuePair<string, object>("@RecipientEmail", giftCardDetail.RecipientEmail));
parameter.Add(new KeyValuePair<string, object>("@RecipientName", giftCardDetail.RecipientName));
parameter.Add(new KeyValuePair<string, object>("@SenderEmail", giftCardDetail.SenderEmail));
parameter.Add(new KeyValuePair<string, object>("@SenderName", giftCardDetail.SenderName));
parameter.Add(new KeyValuePair<string, object>("@Messege", giftCardDetail.Messege));
if (giftCardId > 0)
{
parameter.Add(new KeyValuePair<string, object>("@GiftCardCode", giftCardDetail.GiftCardCode));
}
else
{
parameter.Add(new KeyValuePair<string, object>("@GiftCardCode", GetGiftCardKey()));
}
parameter.Add(new KeyValuePair<string, object>("@GiftCardTypeId", giftCardDetail.GiftCardTypeId));
SQLHandler sqlH = new SQLHandler();
int i = sqlH.ExecuteAsScalar<int>("usp_Aspx_SaveGiftCardByAdmin", parameter);
var typeId = GetGiftCardType(aspxCommonObj.StoreID, aspxCommonObj.PortalID, i);
if (giftCardId == 0)
{
IssueGiftCard(i,null ,aspxCommonObj);
if (typeId == 1) //both or virtual
NotifyUser(i, aspxCommonObj);
} else
{
if ((bool) (!giftCardDetail.IsRecipientNotified))
{
NotifyUser(i, aspxCommonObj);
}
}
}
catch (Exception e)
{
throw e;
}
}
public static int AddItemstoCartFromDetail(AddItemToCartInfo AddItemToCartObj, AspxCommonInfo aspxCommonObj, GiftCard giftCardDetail, CartKit kitInfo)
{
try
{
StoreSettingConfig ssc = new StoreSettingConfig();
if (AspxCartController.CheckItemCart(AddItemToCartObj.ItemID, aspxCommonObj.StoreID, aspxCommonObj.PortalID, AddItemToCartObj.CostVariantIDs))
{
int cartItemId = 0;
if (AddItemToCartObj.IsKitItem)
{
//if kit type
//logic
// serialize
// kitInfo.Data into string and save it db and also description
//++price and weight will be from kit info it contains total configured price and weight
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
string kitconfigureddata = json_serializer.Serialize(kitInfo.Data);
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@ItemID", AddItemToCartObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@Price", kitInfo.Price));
parameter.Add(new KeyValuePair<string, object>("@Weight", kitInfo.Weight));
parameter.Add(new KeyValuePair<string, object>("@Quantity", AddItemToCartObj.Quantity));
parameter.Add(new KeyValuePair<string, object>("@CostVariantsValueIDs", AddItemToCartObj.CostVariantIDs));
parameter.Add(new KeyValuePair<string, object>("@KitDescription", kitInfo.Description));
parameter.Add(new KeyValuePair<string, object>("@KitData", kitconfigureddata));
SQLHandler sqlH = new SQLHandler();
cartItemId = sqlH.ExecuteAsScalar<int>("dbo.usp_Aspx_AddToCart", parameter);
}
else
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@ItemID", AddItemToCartObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@Price", AddItemToCartObj.Price));
parameter.Add(new KeyValuePair<string, object>("@Weight", AddItemToCartObj.Weight));
parameter.Add(new KeyValuePair<string, object>("@Quantity", AddItemToCartObj.Quantity));
parameter.Add(new KeyValuePair<string, object>("@CostVariantsValueIDs", AddItemToCartObj.CostVariantIDs));
parameter.Add(new KeyValuePair<string, object>("@KitDescription", null));
parameter.Add(new KeyValuePair<string, object>("@KitData", null));
SQLHandler sqlH = new SQLHandler();
cartItemId = sqlH.ExecuteAsScalar<int>("dbo.usp_Aspx_AddToCart", parameter);
}
if (AddItemToCartObj.IsGiftCard == true && giftCardDetail != null)
{
List<KeyValuePair<string, object>> param = new List<KeyValuePair<string, object>>();
param.Add(new KeyValuePair<string, object>("@CartItemId", cartItemId));
param.Add(new KeyValuePair<string, object>("@ItemId", AddItemToCartObj.ItemID));
param.Add(new KeyValuePair<string, object>("@GiftCardTypeId", giftCardDetail.GiftCardTypeId));
param.Add(new KeyValuePair<string, object>("@GiftCardGraphicsId", giftCardDetail.GraphicThemeId));
param.Add(new KeyValuePair<string, object>("@Amount", giftCardDetail.Price));
param.Add(new KeyValuePair<string, object>("@GiftCardCode", giftCardDetail.GiftCardCode));
param.Add(new KeyValuePair<string, object>("@RecipientName", giftCardDetail.RecipientName));
param.Add(new KeyValuePair<string, object>("@RecipientEmail", giftCardDetail.RecipientEmail));
param.Add(new KeyValuePair<string, object>("@SenderName", giftCardDetail.SenderName));
param.Add(new KeyValuePair<string, object>("@SenderEmail", giftCardDetail.SenderEmail));
param.Add(new KeyValuePair<string, object>("@Messege", giftCardDetail.Messege));
param.Add(new KeyValuePair<string, object>("@StoreId", aspxCommonObj.StoreID));
param.Add(new KeyValuePair<string, object>("@PortalId", aspxCommonObj.PortalID));
param.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
param.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddGiftCard", param);
}
return 1;
}
else
{
if (bool.Parse(ssc.GetStoreSettingsByKey(StoreSetting.AllowOutStockPurchase, aspxCommonObj.StoreID, aspxCommonObj.PortalID, aspxCommonObj.CultureName)))
{
int cartItemId = 0;
if (AddItemToCartObj.IsKitItem)
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@ItemID", AddItemToCartObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@Price", AddItemToCartObj.Price));
parameter.Add(new KeyValuePair<string, object>("@Weight", AddItemToCartObj.Weight));
parameter.Add(new KeyValuePair<string, object>("@Quantity", AddItemToCartObj.Quantity));
parameter.Add(new KeyValuePair<string, object>("@CostVariantsValueIDs", AddItemToCartObj.CostVariantIDs));
parameter.Add(new KeyValuePair<string, object>("@KitDescription", null));
parameter.Add(new KeyValuePair<string, object>("@KitData", null));
SQLHandler sqlH = new SQLHandler();
cartItemId = sqlH.ExecuteAsScalar<int>("dbo.usp_Aspx_AddToCart", parameter);
}
else
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUS(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@ItemID", AddItemToCartObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@Price", AddItemToCartObj.Price));
parameter.Add(new KeyValuePair<string, object>("@Weight", AddItemToCartObj.Weight));
parameter.Add(new KeyValuePair<string, object>("@Quantity", AddItemToCartObj.Quantity));
parameter.Add(new KeyValuePair<string, object>("@CostVariantsValueIDs", AddItemToCartObj.CostVariantIDs));
parameter.Add(new KeyValuePair<string, object>("@KitDescription", null));
parameter.Add(new KeyValuePair<string, object>("@KitData", null));
SQLHandler sqlH = new SQLHandler();
cartItemId = sqlH.ExecuteAsScalar<int>("dbo.usp_Aspx_AddToCart", parameter);
}
if (AddItemToCartObj.IsGiftCard == true && giftCardDetail != null)
{
List<KeyValuePair<string, object>> param = new List<KeyValuePair<string, object>>();
param.Add(new KeyValuePair<string, object>("@CartItemId", cartItemId));
param.Add(new KeyValuePair<string, object>("@ItemId", AddItemToCartObj.ItemID));
param.Add(new KeyValuePair<string, object>("@GiftCardTypeId", giftCardDetail.GiftCardTypeId));
param.Add(new KeyValuePair<string, object>("@GiftCardGraphicsId", giftCardDetail.GraphicThemeId));
param.Add(new KeyValuePair<string, object>("@Amount", giftCardDetail.Price));
param.Add(new KeyValuePair<string, object>("@GiftCardCode", giftCardDetail.GiftCardCode));
param.Add(new KeyValuePair<string, object>("@RecipientName", giftCardDetail.RecipientName));
param.Add(new KeyValuePair<string, object>("@RecipientEmail", giftCardDetail.RecipientEmail));
param.Add(new KeyValuePair<string, object>("@SenderName", giftCardDetail.SenderName));
param.Add(new KeyValuePair<string, object>("@SenderEmail", giftCardDetail.SenderEmail));
param.Add(new KeyValuePair<string, object>("@Messege", giftCardDetail.Messege));
param.Add(new KeyValuePair<string, object>("@StoreId", aspxCommonObj.StoreID));
param.Add(new KeyValuePair<string, object>("@PortalId", aspxCommonObj.PortalID));
param.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
param.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_AddGiftCard", param);
}
return 1;
}
else
{
return 2;
}
}
}
catch (Exception e)
{
throw e;
}
}
public static int AddItemstoCartFromDetail(AddItemToCartInfo AddItemToCartObj, AspxCommonInfo aspxCommonObj, GiftCard giftCardDetail, CartKit kitInfo)
{
try
{
int retValue = AspxCommonProvider.AddItemstoCartFromDetail(AddItemToCartObj, aspxCommonObj, giftCardDetail, kitInfo);
return(retValue);
}
catch (Exception e)
{
throw e;
}
}