public ActionResult AddFeedbackproduct(Feedbackproduct feedbackproduct)
{
if (TryUpdateModel(feedbackproduct, new string[] { "Feedbackproductname" }) && ModelState.IsValid)
{
feedbackproduct.Feedbackproductid = Guid.NewGuid();
feedbackproduct.Uuid = Guid.NewGuid();
feedbackproduct.Createdate = DateTime.Now;
feedbackproduct.Updatedate = DateTime.Now;
feedbackproductService.Create(feedbackproduct);
foreach (Feedbackdetail feedbackdetail in feedbackproduct.Feedbackdetail)
{
feedbackdetail.Setid = Guid.NewGuid();
feedbackdetail.Feedbackproductid = feedbackproduct.Feedbackproductid;
feedbackdetailService.Create(feedbackdetail);
}
feedbackproductService.SaveChanges();
IEnumerable <Members> member = membersService.Get();
foreach (Members thismember in member)
{
Memberauthorization memberauth = new Memberauthorization();
memberauth.Id = Guid.NewGuid();
memberauth.Memberid = thismember.Memberid;
memberauth.Feedbackproductid = feedbackproduct.Feedbackproductid;
memberauth.Checked = true;
memberauthorizationService.Create(memberauth);
}
memberauthorizationService.SaveChanges();
}
return(RedirectToAction("Feedbackproduct"));
}
public ActionResult EditFeedbackproduct(Guid Feedbackproductid, ICollection <Feedbackdetail> Feedbackdetail)
{
Feedbackproduct feedbackproduct = feedbackproductService.GetByID(Feedbackproductid);
if (TryUpdateModel(feedbackproduct, new string[] { "Feedbackproductname" }) && ModelState.IsValid)
{
//更新產品價格
foreach (Feedbackdetail new_feedbackdetail in Feedbackdetail)
{
if (feedbackproduct.Feedbackdetail.ToList().Exists(a => a.Setid == new_feedbackdetail.Setid))
{
Feedbackdetail feedbackdetail = feedbackproduct.Feedbackdetail.Where(a => a.Setid == new_feedbackdetail.Setid).FirstOrDefault();
feedbackdetail.Money = new_feedbackdetail.Money;
}
else
{
new_feedbackdetail.Setid = Guid.NewGuid();
new_feedbackdetail.Feedbackproductid = Feedbackproductid;
feedbackproduct.Feedbackdetail.Add(new_feedbackdetail);
}
}
feedbackproductService.Update(feedbackproduct);
feedbackproductService.SaveChanges();
}
return(RedirectToAction("Feedbackproduct"));
}
public ActionResult DeleteFeedbackproduct(Guid productid, int p)
{
Feedbackproduct feedbackproduct = feedbackproductService.GetByID(productid);
feedbackproductService.Delete(feedbackproduct);
feedbackproductService.SaveChanges();
return(RedirectToAction("Feedbackproduct", new { p = p }));
}
public ActionResult EditFeedbackproduct(Guid productid, int p)
{
ViewBag.pageNumber = p;
Feedbackproduct feedbackproduct = feedbackproductService.GetByID(productid);
IEnumerable <Memberlevel> Levelname = memberlevelService.Get();
ViewBag.Levelname = Levelname;
return(View(feedbackproduct));
}
/*** 更新會員互惠列表 ***/
public JsonResult UpdateAccount(string Id, string Ordernumber, string Memberid, string FacebookCookie, int AccountStatus, string Facebookid)
{
if (Id == "heo_order")
{
IEnumerable <Memberlevel> memberlevel = memberlevelService.Get().Where(a => a.Isenable == 1); // 撈除了真人以外的層級
Order order = orderService.Get().Where(a => a.Ordernumber == Ordernumber).FirstOrDefault(); // 該訂單的詳細資料
Members member = membersService.GetByID(Guid.Parse(Memberid)); // 該會員的詳細資料
Feedbackproduct feedbackproduct = feedbackproductService.Get().Where(a => a.Feedbackproductname.Contains(order.Service)).FirstOrDefault(); // 該訂單之產品資料
if (AccountStatus == 0 || AccountStatus == 1) // 帳號需驗證、帳密錯誤、更改密碼
{
/**** 將登入失敗寫入資料庫 ****/
Memberloginrecord Memberloginrecord = new Memberloginrecord();
Memberloginrecord.Memberid = Guid.Parse(Memberid);
Memberloginrecord.Status = 2;
Memberloginrecord.Createdate = DateTime.Now;
memberloginrecordService.Create(Memberloginrecord);
memberloginrecordService.SaveChanges();
/**** 寫入TXT檔 *****/
using (StreamWriter sw = new StreamWriter(@"C:\Users\wadmin\Desktop\HEO_order.txt", true))
{
sw.Write("HEO訂單問題回報 會員帳號:" + member.Account + "登入有問題(密碼更改or帳密錯誤)");
sw.Write(Environment.NewLine);
sw.Write(DateTime.Now);
sw.Write(Environment.NewLine);
}
}
else if (AccountStatus == 2) // 按讚成功
{
/*** 改訂單剩餘人數 ***/
order.Remains -= 1;
orderService.SpecificUpdate(order, new string[] { "Remains" });
orderService.SaveChanges();
/**** 將登入成功寫入資料庫 ****/
Memberloginrecord Memberloginrecord = new Memberloginrecord();
Memberloginrecord.Memberid = Guid.Parse(Memberid);
Memberloginrecord.Status = 1;
Memberloginrecord.Createdate = DateTime.Now;
memberloginrecordService.Create(Memberloginrecord);
memberloginrecordService.SaveChanges();
}
else if (AccountStatus == 3) // 找不到讚的位置
{
/***** 寄信給我 ****/
order.OrderStatus = 3; //訂單改為失敗
orderService.SpecificUpdate(order, new string[] { "OrderStatus" });
orderService.SaveChanges();
/**** 寫入TXT檔 *****/
using (StreamWriter sw = new StreamWriter(@"C:\Users\wadmin\Desktop\HEO_order.txt", true))
{
sw.Write("HEO訂單問題回報 訂單編號:" + order.Ordernumber + "有問題，" + member.Account + "(找不到讚的位置)");
sw.Write(Environment.NewLine);
sw.Write(DateTime.Now);
sw.Write(Environment.NewLine);
}
}
else // 已按過讚
{
/**** 寫入TXT檔 *****/
using (StreamWriter sw = new StreamWriter(@"C:\Users\wadmin\Desktop\HEO_order.txt", true))
{
sw.Write("HEO訂單問題回報 訂單編號:" + order.Ordernumber + "有問題，" + member.Account + "(已按過讚)");
sw.Write(Environment.NewLine);
sw.Write(DateTime.Now);
sw.Write(Environment.NewLine);
}
}
if (order.Ordernumber.Contains("heo"))
{
/*** HEO內部下單 ***/
/*** 更新會員的FacebookId ***/
member.Facebookid = Facebookid;
/*** 更新會員的Cookie *****/
member.Facebookcookie = FacebookCookie;
membersService.SpecificUpdate(member, new string[] { "Facebookcookie", "Facebookid" });
/*** 將會員寫到該訂單的互惠會員列表 ***/
Orderfaceooklist orderfacebooklist = new Orderfaceooklist();
orderfacebooklist.Memberid = member.Memberid;
orderfacebooklist.Feedbackproductid = feedbackproduct.Feedbackproductid;
orderfacebooklist.Facebookaccount = member.Account;
orderfacebooklist.Orderid = order.Orderid;
orderfacebooklist.Createdate = DateTime.Now;
orderfacebooklist.Updatedate = DateTime.Now;
//orderfacebooklistService.Create(orderfacebooklist);
member.Orderfaceooklist.Add(orderfacebooklist);
membersService.SaveChanges();
return(this.Json("Success"));
}
else
{
/**** HDZ餵來的訂單 ****/
/*** 更新訂單成本及判斷該會員的層級，並且撥對應的回饋金給該會員 ****/
if (member.Is_import == 0) // 判斷該會員非後台匯入的會員
{
if (member.Isreal == true) // 判斷該會員是否為真人
{
order.Cost += 1.0 * Convert.ToDouble(feedbackproduct.Feedbackdetail.FirstOrDefault(a => a.Memberlevel.Levelname == "真人").Money);
member.Feedbackmoney += order.Cost;
}
else
{
foreach (Memberlevel level in memberlevel)
{
if (member.Memberlevel.Levelname == level.Levelname)
{
order.Cost += 1.0 * Convert.ToDouble(feedbackproduct.Feedbackdetail.FirstOrDefault(a => a.Memberlevel.Levelname == level.Levelname).Money);
}
}
}
}
orderService.SpecificUpdate(order, new string[] { "Cost" });
/*** 將會員寫到該訂單的互惠會員列表 ***/
Orderfaceooklist orderfacebooklist = new Orderfaceooklist();
orderfacebooklist.Memberid = member.Memberid;
orderfacebooklist.Feedbackproductid = feedbackproduct.Feedbackproductid;
orderfacebooklist.Facebookaccount = member.Account;
orderfacebooklist.Orderid = order.Orderid;
orderfacebooklist.Createdate = DateTime.Now;
orderfacebooklist.Updatedate = DateTime.Now;
order.Orderfaceooklist.Add(orderfacebooklist);
orderService.SaveChanges();
// orderfacebooklistService.Create(orderfacebooklist);
/*** 判斷該會員的層級，並且撥對應的回饋金給該會員 ***/
if (member.Is_import == 0) // 判斷該會員非後台匯入的會員
{
if (member.Isreal == true) // 判斷該會員是否為真人
{
member.Feedbackmoney += Convert.ToInt32(feedbackproduct.Feedbackdetail.FirstOrDefault(a => a.Memberlevel.Levelname == "真人").Money);
}
else
{
member.Feedbackmoney += Convert.ToInt32(feedbackproduct.Feedbackdetail.FirstOrDefault(a => a.Levelid == member.Levelid).Money);
}
}
/*** 更新該會員的FacebookId ***/
member.Facebookid = Facebookid;
/*** 更新該會員的Cookie *****/
member.Facebookcookie = FacebookCookie;
membersService.SpecificUpdate(member, new string[] { "Facebookcookie", "Feedbackmoney", "Facebookid" });
membersService.SaveChanges();
return(this.Json("Success"));
}
}
else
{
string status = "Error";
return(this.Json(status));
}
}
/*** Service要帳密 ***/
public JsonResult GetAccount(string Id, int number, string Ordernumber)
{
if (Id == "heo_order")
{
Setting setting = settingService.Get().FirstOrDefault();
Order order = orderService.Get().Where(a => a.Ordernumber == Ordernumber).FirstOrDefault(); // 撈訂單的詳細資料
Feedbackproduct feedbackproduct = feedbackproductService.Get().Where(a => a.Feedbackproductname.Contains(order.Service)).FirstOrDefault(); // 撈訂單產品的詳細資料
IEnumerable <Orderfaceooklist> orderfacebookList = orderfacebooklistService.Get().Where(a => a.Order.Ordernumber == Ordernumber); // 撈訂單之前的按讚名單紀錄
IEnumerable <Order> old_order = orderService.Get().Where(x => x.Ordernumber != order.Ordernumber).Where(c => c.Service == feedbackproduct.Feedbackproductname).Where(a => a.Url == order.Url); // 撈所有訂單裡網址為訂單的資料
List <get_old_member> MemberList = new List <get_old_member>();
/**** 判斷訂單是不是HEO內部的單 ***/
if (order.Ordernumber.Contains("heo"))
{
/*** 先將自己給排除掉 ****/
MemberList.Add(
new get_old_member
{
Memberid = order.Members.Memberid
});
}
/**** 將這張單的按讚列表的人排除掉 *****/
if (orderfacebookList.Count() > 0)
{
foreach (Orderfaceooklist thisorderfacebookList in orderfacebookList)
{
MemberList.Add(
new get_old_member
{
Memberid = Guid.Parse(thisorderfacebookList.Memberid.ToString())
}
);
}
}
/*** 將同網址的訂單的按站讚列表的人排除掉 ****/
if (old_order.Count() > 0)
{
foreach (Order thisold_order in old_order)
{
IEnumerable <Orderfaceooklist> oldorderfacebooklist = orderfacebooklistService.Get().Where(a => a.Orderid == thisold_order.Orderid);
foreach (Orderfaceooklist thisoldorderfaceooklist in oldorderfacebooklist)
{
MemberList.Add(
new get_old_member
{
Memberid = Guid.Parse(thisoldorderfaceooklist.Memberid.ToString())
}
);
}
}
}
Guid VipLevelid = memberlevelService.Get().Where(a => a.Levelname == "VIP").FirstOrDefault().Levelid; // VIP層級的ID
if (order.Ordernumber.Contains("heo"))
{
/*** HEO內部下的訂單 ***/
List <get_member> AccountList = new List <get_member>();
/*** 先撈前台登入、仿前台登入的使用者 ***/
IEnumerable <Members> members = membersService.Get().Where(s => s.Is_import == 0 || s.Is_import == 2).Where(c => c.Levelid != VipLevelid).Where(x => x.Lastdate <= Now).Where(a => a.Logindate >= Now).Where(c => c.Memberloginrecord.OrderByDescending(a => a.Createdate).FirstOrDefault().Status == 1).OrderBy(x => x.Lastdate); // 撈層級非VIP的帳號詳細資料
if (members != null)
{
foreach (Members thismembers in members)
{
bool used = false;
int loop;
for (loop = 0; loop < MemberList.Count(); loop++)
{
if (thismembers.Memberid.Equals(MemberList[loop].Memberid))
{
used = true;
}
}
if (used == false)
{
AccountList.Add(
new get_member
{
memberid = thismembers.Memberid,
account = thismembers.Account,
password = thismembers.Password,
useragent_phone = thismembers.Useragent_phone,
facebookcookie = thismembers.Facebookcookie,
}
);
used = false;
}
}
foreach (get_member entity in AccountList.Take(number))
{
/*** 將此會員更新下次互惠時間 ****/
Members member = membersService.GetByID(entity.memberid);
member.Lastdate = Now + (int)setting.Time;
membersService.SpecificUpdate(member, new string[] { "Lastdate" });
}
membersService.SaveChanges();
return(this.Json(AccountList.Take(number), JsonRequestBehavior.AllowGet));
}
else
{
/*** 前台沒人可以抓了，改抓機器人 ***/
IEnumerable <Members> Botmembers = membersService.Get().Where(s => s.Is_import == 1).Where(x => x.Lastdate <= Now).Where(c => c.Memberloginrecord.OrderByDescending(a => a.Createdate).FirstOrDefault().Status != 2).OrderBy(x => x.Lastdate);
if (members != null)
{
bool used = false;
foreach (Members thismembers in Botmembers)
{
int loop;
for (loop = 0; loop < MemberList.Count(); loop++)
{
if (thismembers.Memberid.Equals(MemberList[loop].Memberid))
{
used = true;
}
}
if (used == false)
{
AccountList.Add(
new get_member
{
memberid = thismembers.Memberid,
account = thismembers.Account,
password = thismembers.Password,
useragent_phone = thismembers.Useragent_phone,
facebookcookie = thismembers.Facebookcookie,
}
);
used = false;
}
}
if (AccountList.Count() < number)
{
return(this.Json("數量不足", JsonRequestBehavior.AllowGet));
}
else
{
foreach (get_member entity in AccountList.Take(number))
{
/*** 將此會員更新下次互惠時間 ****/
Members member = membersService.GetByID(entity.memberid);
member.Lastdate = Now + (int)setting.Time;
membersService.SpecificUpdate(member, new string[] { "Lastdate" });
}
membersService.SaveChanges();
return(this.Json(AccountList.Take(number), JsonRequestBehavior.AllowGet));
}
}
else
{
return(this.Json("數量不足", JsonRequestBehavior.AllowGet));
}
}
}
else
{
/*** HDZ餵來的訂單 ***/
IEnumerable <Members> members = membersService.Get().Where(x => x.Lastdate <= Now).Where(b => b.Memberloginrecord.OrderByDescending(x => x.Createdate).FirstOrDefault().Status != 2).Where(s => s.Memberauthorization.Where(q => q.Feedbackproductid == feedbackproduct.Feedbackproductid).FirstOrDefault().Checked == true).OrderBy(x => x.Lastdate);
if (members != null)
{
List <get_member> AccountList = new List <get_member>();
bool used_accoount = false;
foreach (Members thismembers in members)
{
int loop;
if (MemberList.Count() > 0)
{
for (loop = 0; loop < MemberList.Count(); loop++)
{
if ((thismembers.Memberid.Equals(MemberList[loop].Memberid)) == true)
{
used_accoount = true;
}
}
}
if (!used_accoount)
{
AccountList.Add(
new get_member
{
memberid = thismembers.Memberid,
account = thismembers.Account,
password = thismembers.Password,
useragent_phone = thismembers.Useragent_phone,
facebookcookie = thismembers.Facebookcookie,
}
);
}
used_accoount = false;
}
/*** 可用人數小於該訂單所需人數 ***/
if (AccountList.Count < number)
{
return(this.Json("數量不足", JsonRequestBehavior.AllowGet));
}
else
{
foreach (get_member entity in AccountList.Take(number))
{
/*** 將此會員更新下次互惠時間 ****/
Members member = membersService.GetByID(entity.memberid);
member.Lastdate = Now + (int)setting.Time;
membersService.SpecificUpdate(member, new string[] { "Lastdate" });
}
}
membersService.SaveChanges();
return(this.Json(AccountList.Take(number), JsonRequestBehavior.AllowGet));
}
else
{
return(this.Json("數量不足", JsonRequestBehavior.AllowGet));
}
}
}
else
{
string status = "Error";
return(this.Json(status, JsonRequestBehavior.AllowGet));
}
}
