public int AddMerchant(MERCHANT c)
{
db = new WEBGIAYEntities();
db.MERCHANTS.Add(c);
db.SaveChanges();
return(c.MAMERCHANT);
}
public static IEnumerable <Shop> GetShops(string file, MERCHANT merchant)
{
var doc = JsonConvert.DeserializeObject <JObject>(File.ReadAllText(file));
var deals = doc["deals"];
foreach (var deal in deals)
{
var counter = 0;
foreach (var location in deal.SelectToken("redemptionLocations"))
{
var shop = new Shop
{
Source = "AMAZON",
Longitude = GetProperty(location, "longitude"),
Latitude = GetProperty(location, "latitude"),
PostalCode = GetProperty(location, "addressPostalCode"),
PhoneNumber = GetProperty(location, "phoneNumber"),
Geography = GetProperty(location, "geography.displayName"),
UniqueId = GetProperty(deal, "asin") + "/SHOP/" + counter,
StateOrProvince = GetProperty(location, "addressStateOrProvince"),
Street1 = GetProperty(location, "addressStreet1"),
Street2 = GetProperty(location, "addressStreet2"),
};
counter++;
yield return(shop);
}
}
}
private static void SaveOffers(wp_user user, MERCHANT merchant, Func <string, MERCHANT, IEnumerable <DailyOffer> > callback, string file)
{
log.DebugFormat("Getting deals for <{0}>.", merchant);
var dailyOffers = callback(file, merchant);
log.DebugFormat("Parsing deals for <{0}>.", merchant);
SaveOffers(user, dailyOffers, merchant);
}
private static void SaveShops(wp_user user, IEnumerable <Shop> shops, MERCHANT merchant)
{
log.DebugFormat("Saving shops for <{0}>.", merchant);
ShopCreationService.Save(user, shops.ToArray());
log.DebugFormat("Finished saving shops for <{0}>.", merchant);
}
private static void SaveShops(wp_user user, MERCHANT merchant, Func <string, MERCHANT, IEnumerable <Shop> > callback, string file)
{
log.DebugFormat("Getting shops for <{0}>.", merchant);
var shops = callback(file, merchant);
log.DebugFormat("Parsing shops for <{0}>.", merchant);
SaveShops(user, shops, merchant);
}
private static string Download(MERCHANT merchant, Func <MERCHANT, string> getDataFeed)
{
log.DebugFormat("Downloading feed for <{0}>.", merchant);
var file = getDataFeed(merchant);
log.DebugFormat("Downloaded feed for <{0}> to <{1}>.", merchant, file);
return(file);
}
public MERCHANT FindMerchant(string merchantCode)
{
object[] paremeter =
{
new SqlParameter("@MerchantCode", merchantCode)
};
MERCHANT res = db.Database.SqlQuery <MERCHANT>("sp_GetMerchant @MerchantCode", paremeter).FirstOrDefault();
return(res);
}
public bool active(int idme)
{
bool check = false;
MERCHANT m = db.MERCHANTS.Find(idme);
m.TINHTRANG = 1;
db.SaveChanges();
check = true;
return(check);
}
public ActionResult register(REGISTERViewModel r)
{
if (ModelState.IsValid)
{
MERCHANTDAL dal = new MERCHANTDAL();
var email = dal.kiemtratendangnhap(r.EMAIL);
var tendn = dal.kiemtratendangnhap(r.TENDANGNHAP);
var cmd = dal.kiemtracmnd(r.CMND);
if (email != null)
{
ModelState.AddModelError("", "Email đã đươc sử dụng");
}
if (tendn != null)
{
ModelState.AddModelError("", "Tên dăng nhập đã đươc sử dụng");
}
if (cmd != null)
{
ModelState.AddModelError("", "CMND đã đươc sử dụng");
}
else
{
var m = new MERCHANT();
m.TENDANGNHAP = r.TENDANGNHAP;
m.TENMERCHANT = r.TENMERCHANT;
m.MATKHAU = MD5Encryptor.MD5Hash(r.MATKHAU);
m.DIACHI = r.DIACHI;
m.EMAIL = r.EMAIL;
m.NGAYSINH = r.NGAYSINH;
m.SDT = r.SDT;
m.NGAYDK = DateTime.Today;
m.TINHTRANG = 0;
m.SOTINHIENTAI = 0;
m.SOLANBIKHOA = 0;
m.RATING = 0;
m.CMND = r.CMND;
var ver = dal.newme(m);
if (ver > 0)
{
ViewBag.Success = "Đăng kí thành công. Vui lòng kiểm tra email để kích hoạt tài khoản";
BuildEmailTemplate(ver);
}
else
{
ModelState.AddModelError("", "Đăng kí không thành công");
}
}
}
return(View(r));
}
public async Task <IHttpActionResult> DeleteMERCHANT(string id)
{
MERCHANT mERCHANT = await db.MERCHANT.FindAsync(id);
if (mERCHANT == null)
{
return(NotFound());
}
db.MERCHANT.Remove(mERCHANT);
await db.SaveChangesAsync();
return(Ok(mERCHANT));
}
public static string Download(MERCHANT merchant)
{
var credCache = new CredentialCache
{
{
new Uri(DIGEST_URI), "Digest",
new NetworkCredential(Config.AMAZON_USERNAME, Config.AMAZON_PASSWORD)
}
};
var client = new HttpClient(new HttpClientHandler {
Credentials = credCache
});
var inFile = AbstractDataFeed.DownloadFeed(URL, client);
return(AbstractDataFeed.ExtractContents(inFile));
}
public bool UpdateAgentOfMerchant(string merchantCode, MERCHANT merchant)
{
try
{
object[] paremeter =
{
new SqlParameter("@MerchantCode", merchantCode),
new SqlParameter("@AgentCode", merchant.AgentCode)
};
db.Database.ExecuteSqlCommand("exec sp_UpdateAgentOfMerchant @MerchantCode, @AgentCode", paremeter);
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool UpdateMerchant(string id, MERCHANT merchant)
{
//m nhap merchant name vao
try
{
object[] parameter =
{
new SqlParameter("@MerchantCode", merchant.MerchantCode),
new SqlParameter("@MerchantName", merchant.MerchantName),
new SqlParameter("@BackEndProcessor", merchant.BackEndProcessor),
new SqlParameter("@Status", merchant.Status ?? (object)DBNull.Value),
new SqlParameter("@Owner", merchant.Owner ?? (object)DBNull.Value),
new SqlParameter("@MerchantType", merchant.MerchantType ?? (object)DBNull.Value),
new SqlParameter("@Address1", merchant.Address1 ?? (object)DBNull.Value),
new SqlParameter("@Address2", merchant.Address2 ?? (object)DBNull.Value),
new SqlParameter("@Address3", merchant.Address3 ?? (object)DBNull.Value),
new SqlParameter("@CityCode", merchant.CityCode),
new SqlParameter("@Zip", merchant.Zip ?? System.Data.SqlTypes.SqlInt32.Null),
new SqlParameter("@Phone", string.IsNullOrEmpty(merchant.Phone)?"":merchant.Phone),
new SqlParameter("@Fax", string.IsNullOrEmpty(merchant.Fax)?"":merchant.Fax),
new SqlParameter("@Email", string.IsNullOrEmpty(merchant.Fax)?"":merchant.Fax),
new SqlParameter("@ApprovalDate", merchant.ApprovalDate ?? (object)DBNull.Value),
new SqlParameter("@CloseDate", merchant.CloseDate ?? (object)DBNull.Value),
new SqlParameter("@BankCardDBA", merchant.BankCardDBA ?? (object)DBNull.Value),
new SqlParameter("@FirstActiveDate", merchant.FirstActiveDate ?? (object)DBNull.Value),
new SqlParameter("@LastActiveDate", merchant.LastActiveDate ?? (object)DBNull.Value),
new SqlParameter("@AgentCode", merchant.AgentCode)
};
string sql = "sp_Editmerchant @MerchantCode, @MerchantName,@BackEndProcessor ,@Status, @Owner, @MerchantType"
+ ",@Address1,@Address2,@Address3,@CityCode,@Zip,@Phone,@Fax,@Email, @ApprovalDate,@CloseDate,@BankCardDBA,@FirstActiveDate"
+ ",@LastActiveDate,@AgentCode";
db.Database.ExecuteSqlCommand(sql, parameter);
return(true);
}
catch (Exception ex)
{
System.Console.Write(ex.ToString());
return(false);
}
}
/* Public Methods. */
public static IEnumerable <DailyOffer> GetDeals(string fileContents, MERCHANT merchant)
{
var doc = XDocument.Load(fileContents);
return(from product in doc.Descendants("prod")
where product.Attribute("in_stock").Value == "yes"
select new ShopWindowDailyOffer
{
Language = GetAttribute(product, "lang"),
AWThumb = GetChild(product, "awThumb"),
MerchantThumbnail = GetChild(product, "mThumb"),
MerchantLink = GetChild(product, "mLink"),
MerchantImage = GetChild(product, "mImage"),
WebOffer = GetAttribute(product, "web_offer"),
InStock = GetAttribute(product, "in_stock"),
StockQuantity = GetAttribute(product, "stock_quantity"),
ProductMerchantId = GetChild(product, "pId"),
PreOrder = GetAttribute(product, "pre_order"),
BrandName = GetChild(product, "brandName"),
Description = GetChild(product, "desc"),
Warranty = GetChild(product, "warranty"),
Spec = GetChild(product, "spec"),
Title = GetChild(product, "name"),
ImageUrl = GetChild(product, "awImage"),
Merchant = merchant.ToString(),
Source = "SHOP_WINDOW",
Promo = GetChild(product, "promo"),
UniqueId = product.Attribute("id").Value,
OfferEndTime = GetChild(product, "valTo"),
OfferStartTime = GetChild(product, "valFrom"),
BuyNowPrice = GetChild(product, "buynow"),
StorePrice = GetChild(product, "store"),
RecommendedRetailPrice = GetChild(product, "rrp"),
Delivery = GetChild(product, "delivery"),
PurchaseUrl = GetChild(product, "awTrack"),
Value = GetValue(product),
Products = new List <string> {
GetChild(product, "awCat").Replace("&", "and")
}
});
}
/* Public Methods. */
public static String Execute(
MERCHANT merchant,
wp_user user,
Func <MERCHANT, string> getDataFeed,
Func <string, MERCHANT, IEnumerable <DailyOffer> > getOffers,
Func <string, MERCHANT, IEnumerable <Shop> > getShops = null)
{
var file = Download(merchant, getDataFeed);
if (getShops != null)
{
SaveShops(user, merchant, getShops, file);
}
if (getOffers != null)
{
SaveOffers(user, merchant, getOffers, file);
}
return(file);
}
public static IEnumerable <DailyOffer> GetDeals(string file, MERCHANT merchant)
{
var doc = JsonConvert.DeserializeObject <JObject>(File.ReadAllText(file));
var deals = doc["deals"];
foreach (var deal in deals)
{
var counter = 0;
foreach (var option in deal.SelectToken("options"))
{
var dailyOffer = new AmazonDailyOffer
{
Title = GetProperty(option, "title"),
Description = GetProperty(deal, "description"),
ImageUrl = GetProperty(deal, "imageUrl"),
FinePrint = GetProperty(deal, "finePrint"),
Price = GetProperty(option, "price.amountInBaseUnit"),
Value = GetProperty(option, "value.amountInBaseUnit"),
Source = merchant.ToString(),
UniqueId = GetProperty(deal, "asin") + "/CODE/" + counter,
OfferEndTime = new DateTime(long.Parse(GetProperty(deal, "offerEndTime")) / 1000).ToString(),
Merchant = GetProperty(deal, "merchant.displayName"),
Products = new List <string> {
GetProperty(deal, "category.name")
},
Geographies = deal.SelectToken("geographies").Select(x => x.SelectToken("displayName").Value <String>())
};
counter++;
yield return(dailyOffer);
}
}
}
public int newme(MERCHANT m)
{
db.MERCHANTS.Add(m);
db.SaveChanges();
return(m.MAMERCHANT);
}
public static void GetDeals(MERCHANT merchant, wp_user user)
{
AbstractProvider.Execute(merchant, user, DataFeed.Download, Parser.GetDeals);
}
public ActionResult SendMail(FormCollection form)
{
var model = Session[CommonConstants.USER_SESSION];
var temp = new USER_INFORMATION();
var merchant = new MERCHANT();
if (model != null)
{
temp = (USER_INFORMATION)model;
HttpClient client = new AccessAPI().Access();
HttpResponseMessage response = client.GetAsync(string.Format("api/MERCHANT/FindMerchant?merchantCode={0}", temp.UserName)).Result;
if (response.IsSuccessStatusCode)
{
merchant = response.Content.ReadAsAsync <MERCHANT>().Result;
}
}
else
{
return(View("Index"));
}
var fbMail = new Mail();
fbMail.Subject = form["Subject"];
fbMail.Content = form["Content"];
var Signature = "\n\n-------------\n" + merchant.MerchantName + "\n" + merchant.Owner + "\n" + merchant.Address1
+ "\n" + merchant.Email + "\n" + merchant.Phone;
fbMail.MailMaster = WebConfigurationManager.AppSettings["toAddress"];
fbMail.MailMerchant = WebConfigurationManager.AppSettings["fromAddress"];
fbMail.Password = WebConfigurationManager.AppSettings["Password"];
var fromAddress = new MailAddress(fbMail.MailMerchant);
var toAddress = new MailAddress(fbMail.MailMaster);
var smtp = new SmtpClient
{
Host = WebConfigurationManager.AppSettings["host"],
Port = int.Parse(WebConfigurationManager.AppSettings["port"]),
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = true,
Credentials = new NetworkCredential(fromAddress.Address, fbMail.Password)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = fbMail.Subject,
Body = fbMail.Content + Signature
})
{
try
{
smtp.Send(message);
TempData["Message"] = "true";
return(RedirectToAction("Index"));
}
catch (Exception)
{
TempData["Message"] = "false";
return(RedirectToAction("Index"));
}
}
}
/* Private. */
private static void SaveOffers(wp_user user, IEnumerable <DailyOffer> dailyOffers, MERCHANT merchant)
{
log.DebugFormat("Saving deals for <{0}>.", merchant);
try
{
DailyOfferCreationService.Save(user, dailyOffers.ToArray());
}
catch (Exception e)
{
log.FatalFormat(e.Message);
log.FatalFormat(e.StackTrace);
throw;
}
log.DebugFormat("Finished saving deals for <{0}>.", merchant);
}
