/**** 更新IG文章讚的訂單 ***/
public JsonResult UpdateIGOrder_ArticleLike(string Id, string IGOrdernumber, string status = "failed")
{
var keyValues = new Dictionary <string, string>();
if (Id == "CloudControl_order")
{
IGOrder igorder = igorderService.Get().Where(a => a.IGOrdernumber == IGOrdernumber).FirstOrDefault(); // 抓該訂單
if (status == "success")
{
igorder.IGOrderStatus = 2; //狀態改已成功
igorderService.SpecificUpdate(igorder, new string[] { "IGOrderStatus" });
igorderService.SaveChanges();
}
else
{
igorder.IGOrderStatus = 3; //狀態改失敗
igorderService.SpecificUpdate(igorder, new string[] { "IGOrderStatus" });
igorderService.SaveChanges();
}
keyValues = new Dictionary <string, string>
{
{ "Status", "Success" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
else
{
keyValues = new Dictionary <string, string>
{
{ "Status", "Error" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
}
public ActionResult IGOrderrework(Guid IGOrderid, int p)
{
IGOrder igorder = igorderService.GetByID(IGOrderid);
igorder.IGOrderStatus = 0; // 訂單狀態改為等待中
/**** 更新完成列表裡的帳號的Docker狀態 ****/
IEnumerable <IGMembers> IGMembers = igmembersService.Get();
IEnumerable <IGOrderlist> IGOrderlist = igorderlistService.Get().Where(a => a.IGOrderid == IGOrderid);
foreach (IGOrderlist list in IGOrderlist)
{
foreach (IGMembers IGMember in IGMembers)
{
if (IGMember.IGMemberid == list.IGMemberid)
{
IGMember.Isdocker = 0; // 關閉Docker 【0 : 關閉, 1 : 開啟】
igmembersService.SpecificUpdate(IGMember, new string[] { "Isdocker" });
}
}
}
igmembersService.SaveChanges();
igorderService.SpecificUpdate(igorder, new string[] { "IGOrderStatus" });
igorderService.SaveChanges();
return(RedirectToAction("IGOrder", new { p = p }));
}
public ActionResult EditIGOrder(Guid IGOrderid)
{
IGOrder igorder = igorderService.GetByID(IGOrderid);
if (TryUpdateModel(igorder, new string[] { "Url", "Count", "Productid", "IGOrderStatus", "Categoryid", "Istest" }) && ModelState.IsValid)
{
/*** 訂單不是進行中，將完成名單的會員Docker關閉 ****/
if (igorder.IGOrderStatus != 1)
{
IEnumerable <IGMembers> IGMembers = igmembersService.Get();
IEnumerable <IGOrderlist> IGOrderlist = igorderlistService.Get().Where(a => a.IGOrderid == IGOrderid);
foreach (IGOrderlist list in IGOrderlist)
{
foreach (IGMembers IGMember in IGMembers)
{
if (IGMember.IGMemberid == list.IGMemberid)
{
IGMember.Isdocker = 0; // 關閉Docker 【0 : 關閉, 1 : 開啟】
igmembersService.SpecificUpdate(IGMember, new string[] { "Isdocker" });
}
}
}
igmembersService.SaveChanges();
}
igorderService.Update(igorder);
igorderService.SaveChanges();
}
return(RedirectToAction("IGOrder"));
}
public ActionResult DeleteIGOrder(Guid IGOrderid)
{
IGOrder igorder = igorderService.GetByID(IGOrderid);
igorderService.Delete(igorder);
igorderService.SaveChanges();
return(RedirectToAction("IGOrder"));
}
public ActionResult IGOrderregain(Guid IGOrderid, int p)
{
IGOrder igorder = igorderService.GetByID(IGOrderid);
igorder.IGOrderStatus = 4; //訂單狀態改為收回等待中
igorderService.SpecificUpdate(igorder, new string[] { "IGOrderStatus" });
igorderService.SaveChanges();
return(RedirectToAction("IGOrder", new { p = p }));
}
public ActionResult EditIGOrder(int p, Guid IGOrderid)
{
ViewBag.pageNumber = p;
IGOrder igorder = igorderService.GetByID(IGOrderid);
/***** Instagram產品選單 *****/
IGProductDropDownList(igorder);
/**** 留言類別選單 *****/
CategoryMessageDropDownList(igorder);
return(View(igorder));
}
public JsonResult GetIGOrder_Follow(string Id)
{
var keyValues = new Dictionary <string, string>();
if (Id == "CloudControl_order")
{
Product product = productService.GetByID(Guid.Parse("2422e90a-86c9-4e5c-b119-3623140cdc5c"));
IGOrder igorder = igorderService.Get().OrderBy(a => a.Createdate).Where(x => x.Productid == product.Productid).Where(c => c.IGOrderStatus == 1).FirstOrDefault();
if (igorder == null)
{
igorder = igorderService.Get().OrderBy(a => a.Createdate).Where(x => x.Productid == product.Productid).Where(c => c.IGOrderStatus == 0).FirstOrDefault();
}
if (igorder != null)
{
/*** 將訂單狀態改為進行中 ***/
igorder.IGOrderStatus = 1;
igorderService.SpecificUpdate(igorder, new string[] { "IGOrderStatus" });
igorderService.SaveChanges();
/*** 傳送訂單 ***/
string[] IGOrderArray = new string[4];
IGOrderArray[0] = igorder.IGOrdernumber;
IGOrderArray[1] = igorder.Remains.ToString();
IGOrderArray[2] = igorder.Url;
IGOrderArray[3] = (Now + 3600).ToString();
keyValues = new Dictionary <string, string>
{
{ "IGOrdernumber", IGOrderArray[0] },
{ "Remains", IGOrderArray[1] },
{ "Url", IGOrderArray[2] }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
else
{
keyValues = new Dictionary <string, string>
{
{ "Status", "no_order" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
}
else
{
keyValues = new Dictionary <string, string>
{
{ "Status", "Error" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetIGOrder_RegainArticleLike(string Id)
{
var keyValues = new Dictionary <string, string>();
if (Id == "CloudControl_order")
{
Product product = productService.GetByID(Guid.Parse("5ac21bfd-9aff-483a-8c28-efa9ad74761b"));
IGOrder igorder = igorderService.Get().OrderBy(a => a.Createdate).Where(x => x.Productid == product.Productid).Where(c => c.IGOrderStatus == 5).FirstOrDefault();
if (igorder == null)
{
igorder = igorderService.Get().OrderBy(a => a.Createdate).Where(x => x.Productid == product.Productid).Where(c => c.IGOrderStatus == 4).FirstOrDefault();
}
if (igorder != null)
{
/*** 將訂單狀態改為收回中 ***/
igorder.IGOrderStatus = 5;
igorderService.SpecificUpdate(igorder, new string[] { "IGOrderStatus" });
igorderService.SaveChanges();
/*** 傳送訂單 ***/
string[] IGOrderArray = new string[4];
IGOrderArray[0] = igorder.IGOrdernumber;
IGOrderArray[1] = igorder.Count.ToString();
IGOrderArray[2] = igorder.Url;
keyValues = new Dictionary <string, string>
{
{ "IGOrdernumber", IGOrderArray[0] },
{ "Count", IGOrderArray[1] },
{ "Url", IGOrderArray[2] }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
else
{
keyValues = new Dictionary <string, string>
{
{ "Status", "no_order" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
}
else
{
keyValues = new Dictionary <string, string>
{
{ "Status", "Error" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddIGOrder(IGOrder igorder)
{
if (TryUpdateModel(igorder, new string[] { "Url", "Count", "Productid", "Categoryid", "Istest" }) && ModelState.IsValid)
{
igorder.IGOrderid = Guid.NewGuid();
igorder.Createdate = dt_tw();
igorder.Updatedate = dt_tw();
igorder.Remains = igorder.Count;
igorder.IGOrdernumber = "IGOrder" + dt_tw().ToString("yyyyMMddHHmmssfff");
igorderService.Create(igorder);
igorderService.SaveChanges();
}
return(RedirectToAction("IGOrder"));
}
public JsonResult GetIGRegainMember(string Id, string IGOrdernumber)
{
var keyValues = new Dictionary <string, string>();
if (Id == "CloudControl_order")
{
IGOrder igorder = igorderService.Get().Where(a => a.IGOrdernumber == IGOrdernumber).FirstOrDefault();
IEnumerable <IGOrderlist> igorderlist = igorderlistService.Get().Where(a => a.IGOrderid == igorder.IGOrderid);
List <get_member> AccountList = new List <get_member>();
foreach (IGOrderlist igordertemp in igorderlist)
{
string Cookie = igordertemp.IGMembers.Cookie.Replace("True", "true").Replace("False", "false").Replace("name", "Name").Replace("value", "Value").Replace("path", "Path").Replace("domain", "Domain").Replace("secure", "Secure").Replace("httpOnly", "IsHttpOnly").Replace("expiry", "Expiry");
Cookie = Cookie.Replace(@"""", ""); // 將" 取代成空白
Cookie = Cookie.Replace('\\', '\"'); // 將\\ 取代成\"
AccountList.Add(
new get_member
{
Memberid = Guid.Parse(igordertemp.IGMemberid.ToString()),
Account = igordertemp.IGAccount,
Password = igordertemp.IGMembers.IG_Password,
Useragent_phone = igordertemp.IGMembers.Useragent,
Cookie = Cookie,
Country = Convert.ToInt16(igordertemp.IGMembers.Country)
}
);
keyValues = new Dictionary <string, string>
{
{ "Memberid", igordertemp.IGMemberid.ToString() },
{ "Account", igordertemp.IGAccount },
{ "Password", igordertemp.IGMembers.IG_Password },
{ "Useragent", igordertemp.IGMembers.Useragent },
{ "Cookie", Cookie }
};
}
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
else
{
keyValues = new Dictionary <string, string>
{
{ "Status", "Error" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
}
public JsonResult CheckIGOrderStatus(string Id, string IGOrdernumber)
{
var keyValues = new Dictionary <string, string>();
if (Id == "CloudControl_order")
{
IGOrder igorder = igorderService.Get().Where(a => a.IGOrdernumber == IGOrdernumber).FirstOrDefault();
keyValues = new Dictionary <string, string>
{
{ "IGOrderStatus", igorder.IGOrderStatus.ToString() }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
else
{
keyValues = new Dictionary <string, string>
{
{ "Status", "Error" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdateIGRegainMember(string Id, string IGOrdernumber, string Memberid, string Cookie, int AccountStatus)
{
var keyValues = new Dictionary <string, string>();
if (Id == "CloudControl_order")
{
IGOrder igorder = igorderService.Get().Where(a => a.IGOrdernumber == IGOrdernumber).FirstOrDefault();
IGMembers igmembers = igmembersService.GetByID(Guid.Parse(Memberid));
keyValues = new Dictionary <string, string>
{
{ "Status", "Success" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
else
{
keyValues = new Dictionary <string, string>
{
{ "Status", "Error" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
}
public JsonResult AjaxCalcCheckedCost()
{
double Cost = 0.0; //成本
double Price = 0.0; //售價
double Count = 0.0; //筆數
string[] OrdernumberList = Session["OrderStatistics"].ToString().Split(';');
foreach (string ordernumber in OrdernumberList)
{
if (ordernumber != "")
{
if (ordernumber.IndexOf("FB") != -1)
{
FBOrder fborder = fborderService.Get().Where(a => a.FBOrdernumber == ordernumber).FirstOrDefault();
Product product = productService.GetByID(fborder.Productid);
if (fborder.Istest == true)
{
Cost += 0.0;
Price += 0.0;
}
else
{
Cost += Convert.ToInt32(product.Cost * fborder.Count);
Price += Convert.ToInt32(product.Price * fborder.Count);
}
}
else if (ordernumber.IndexOf("IG") != -1)
{
IGOrder igorder = igorderService.Get().Where(a => a.IGOrdernumber == ordernumber).FirstOrDefault();
Product product = productService.GetByID(igorder.Productid);
if (igorder.Istest == true)
{
Cost += 0.0;
Price += 0.0;
}
else
{
Cost += Convert.ToInt32(product.Cost * igorder.Count);
Price += Convert.ToInt32(product.Price * igorder.Count);
}
}
else if (ordernumber.IndexOf("YT") != -1)
{
YTOrder ytorder = ytorderService.Get().Where(a => a.YTOrdernumber == ordernumber).FirstOrDefault();
Product product = productService.GetByID(ytorder.Productid);
if (ytorder.Istest == true)
{
Cost += 0.0;
Price += 0.0;
}
else
{
Cost += Convert.ToInt32(product.Cost * ytorder.Count);
Price += Convert.ToInt32(product.Price * ytorder.Count);
}
}
Count++;
}
}
Session.Remove("OrderStatistics"); // 清除Session的訂單編號
return(this.Json(Cost + ";" + Price + ";" + (Price - Cost) + ";" + Count));
}
public JsonResult UpdateIGMember(string Id, string IGOrdernumber, string Memberid, string Cookie, int AccountStatus)
{
var keyValues = new Dictionary <string, string>();
if (Id == "CloudControl_order")
{
IGOrder igorder = igorderService.Get().Where(a => a.IGOrdernumber == IGOrdernumber).FirstOrDefault();
IGMembers igmembers = igmembersService.GetByID(Guid.Parse(Memberid));
/*** 0 : 帳號有問題，1 : 成功執行，2 : 找不到執行的位置***/
if (AccountStatus == 0)
{
/*** 將會員寫入登入紀錄裡 ****/
IGMembersLoginlog igmembersloginlog = new IGMembersLoginlog();
igmembersloginlog.Createdate = dt_tw();
igmembersloginlog.IGMemberid = Guid.Parse(Memberid);
igmembersloginlog.Status = 2; // 【 0:未驗證 , 1:已驗證 , 2:需驗證 】
igmembersloginlogService.Create(igmembersloginlog);
igmembersloginlogService.SaveChanges();
/**** 寫入TXT檔 *****/
//using (StreamWriter sw = new StreamWriter(txt_filepath, true))
//{
// sw.Write("CloudControl訂單問題回報 訂單編號:" + igorder.IGOrdernumber + "會員帳號:" + igmembers.IG_Account + "登入有問題");
// sw.Write(Environment.NewLine);
// sw.Write(dt_tw());
// sw.Write(Environment.NewLine);
//}
keyValues = new Dictionary <string, string>
{
{ "Status", "Success" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
else if (AccountStatus == 1)
{
/*** 更新該會員的Cookie *****/
igmembers.Cookie = Cookie;
igmembersService.SpecificUpdate(igmembers, new string[] { "Cookie" });
igmembersService.SaveChanges();
/**** 寫入登入表裡 *****/
IGMembersLoginlog igmembersloginlog = new IGMembersLoginlog();
igmembersloginlog.IGMemberid = Guid.Parse(Memberid);
igmembersloginlog.Status = 1;
igmembersloginlog.Createdate = dt_tw();
igmembersloginlogService.Create(igmembersloginlog);
igmembersloginlogService.SaveChanges();
/*** 改訂單剩餘人數 ***/
igorder.Remains -= 1;
igorderService.SpecificUpdate(igorder, new string[] { "Remains" });
igorderService.SaveChanges();
IGOrderlist igorderlist = new IGOrderlist();
igorderlist.IGOrderlistid = Guid.NewGuid();
igorderlist.IGMemberid = Guid.Parse(Memberid);
igorderlist.IGAccount = igmembers.IG_Account;
igorderlist.IGOrderid = igorder.IGOrderid;
igorderlist.Createdate = dt_tw();
igorderlist.Updatedate = dt_tw();
igorderlistService.Create(igorderlist);
igorderlistService.SaveChanges();
keyValues = new Dictionary <string, string>
{
{ "Status", "Success" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
else
{
/**** 寫入TXT檔 *****/
//using (StreamWriter sw = new StreamWriter(txt_filepath, true))
//{
// sw.Write("CloudControl訂單問題回報 訂單編號:" + igorder.IGOrdernumber + "會員帳號:" + igmembers.IG_Account + "找不到執行的位置");
// sw.Write(Environment.NewLine);
// sw.Write(dt_tw());
// sw.Write(Environment.NewLine);
//}
keyValues = new Dictionary <string, string>
{
{ "Status", "Success" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
}
else
{
keyValues = new Dictionary <string, string>
{
{ "Status", "Error" }
};
return(this.Json(keyValues, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetIGMember(string Id, int number, string IGOrdernumber)
{
get_member_status MemberStatus = new get_member_status();
if (Id == "CloudControl_order")
{
IGOrder igorder = igorderService.Get().Where(a => a.IGOrdernumber == IGOrdernumber).FirstOrDefault(); // 撈該訂單
IEnumerable <IGOrderlist> igorderlist = igorderlistService.Get().Where(a => a.IGOrder.IGOrdernumber == IGOrdernumber); // 撈該訂單的完成列表
IEnumerable <IGOrder> old_igorders = igorderService.Get().Where(c => c.Productid == igorder.Productid).Where(a => a.IGOrdernumber != IGOrdernumber).Where(x => x.Url == igorder.Url); // 撈所有訂單裡網址為此訂單及產品為此訂單的資料
Product product = productService.GetByID(igorder.Productid); // 撈此訂單所需的產品
List <get_old_member> MemberList = new List <get_old_member>();
/**** 先排除這張訂單的完成訂單裡的人 ****/
if (igorderlist != null)
{
foreach (IGOrderlist list in igorderlist)
{
string Account = Regex.Replace(list.IGMembers.IG_Account, @"[^a-z||A-Z||@||.||0-9]", "").Replace(" ", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點，其餘取代空值
MemberList.Add(
new get_old_member
{
Account = Account
});
}
}
/*** 將同網址的訂單的完成訂單裡的人排除掉 ****/
if (old_igorders != null)
{
foreach (IGOrder old_igorder in old_igorders)
{
IEnumerable <IGOrderlist> old_igorderlists = igorderlistService.Get().Where(a => a.IGOrderid == old_igorder.IGOrderid);
foreach (IGOrderlist old_igorderlist in old_igorderlists)
{
string Account = Regex.Replace(old_igorderlist.IGMembers.IG_Account, @"[^a-z||A-Z||@||.||0-9]", "").Replace(" ", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點，其餘取代空值
MemberList.Add(
new get_old_member
{
Account = Account
});
}
}
}
List <get_member> AccountList = new List <get_member>();
//IEnumerable<IGMembers> IGMembers = igmembersService.Get().Where(a => a.Lastdate <= Now).Where(a => a.Country != null).Where(x => x.IGMembersLoginlog.OrderByDescending(c => c.Createdate).FirstOrDefault().Status != 2).OrderBy(o => o.Country); // 撈可用時間小於現在以及驗證狀態不是需驗證的會員
/*** 測試用 ***/
IEnumerable <IGMembers> IGMembers = igmembersService.Get().Where(a => a.Country != null).Where(x => x.IGMembersLoginlog.OrderByDescending(c => c.Createdate).FirstOrDefault().Status != 2).OrderBy(o => o.Country);
if (IGMembers != null)
{
foreach (IGMembers Member in IGMembers)
{
bool used = false;
int loop;
for (loop = 0; loop < MemberList.Count(); loop++)
{
if (Member.IG_Account == MemberList[loop].Account)
{
used = true;
}
}
if (used == false)
{
string Cookie = "";
if (Member.Cookie != null)
{
Cookie = Member.Cookie.Replace("True", "true").Replace("False", "false").Replace("name", "Name").Replace("value", "Value").Replace("path", "Path").Replace("domain", "Domain").Replace("secure", "Secure").Replace("httpOnly", "IsHttpOnly").Replace("expiry", "Expiry");
Cookie = Cookie.Replace(@"""", ""); // 將" 取代成空白
Cookie = Cookie.Replace('\\', '\"'); // 將\\ 取代成\"
}
/**** 判斷這張單是否是留言訂單 ****/
if (product.Productid == Guid.Parse("f5993cef-2a79-4413-bdbc-20a841f0c91e"))
{
/**** 撈取該訂單的留言類別 ****/
Guid CategortMessageid = categorymessageService.GetByID(igorder.Categoryid).Categoryid;
/*** 撈取該留言類別底下的留言 ***/
int messageConunt = messageService.Get().Where(a => a.Categoryid == igorder.Categoryid).Count(); // 該留言類別底下的留言數量
Message[] message = messageService.Get().Where(a => a.Categoryid == igorder.Categoryid).ToArray();
Random crandom = new Random();
int rand = crandom.Next(0, messageConunt - 1);
AccountList.Add(
new get_member
{
Memberid = Member.IGMemberid,
Account = Member.IG_Account,
Password = Member.IG_Password,
Useragent_phone = Member.Useragent,
Cookie = Cookie,
Message = message[rand].MessageName,
Country = Convert.ToInt16(Member.Country)
}
);
used = true;
}
else
{
AccountList.Add(
new get_member
{
Memberid = Member.IGMemberid,
Account = Member.IG_Account,
Password = Member.IG_Password,
Useragent_phone = Member.Useragent,
Cookie = Cookie,
Country = Convert.ToInt16(Member.Country)
}
);
used = true;
}
}
}
/*** 目前沒有可用人數 ****/
if (AccountList.Count() <= 0)
{
MemberStatus.status = false;
return(this.Json(MemberStatus, JsonRequestBehavior.AllowGet));
}
else
{
/*** 將相同國家的個別放群組 ****/
// AccountList -> 目前可使用會員, List->目前可使用會員做Group by分組
var List = AccountList.OrderBy(o => o.Country).GroupBy(a => a.Country).ToArray()[0].Take(number);
foreach (var Value in List)
{
IGMembers Member = igmembersService.GetByID(Value.Memberid);
Member.Lastdate = Now + 120;
igmembersService.SpecificUpdate(Member, new string[] { "Lastdate" });
}
//foreach (get_member entity in AccountList.Take(number))
//{
// /*** 將此會員更新下次互惠時間 ****/
// IGMembers Member = igmembersService.GetByID(entity.Memberid);
// Member.Lastdate = Now + 120;
// igmembersService.SpecificUpdate(Member, new string[] { "Lastdate" });
//}
igmembersService.SaveChanges();
MemberStatus.status = true;
MemberStatus.list = List;
return(this.Json(MemberStatus, JsonRequestBehavior.AllowGet));
}
}
else
{
MemberStatus.status = false;
return(this.Json(MemberStatus, JsonRequestBehavior.AllowGet));
}
}
else
{
MemberStatus.status = false;
return(this.Json(MemberStatus, JsonRequestBehavior.AllowGet));
}
}
