public JsonResult GetYTRegainMember(string Id, string YTOrdernumber)
{
if (Id == "CloudControl_order")
{
YTOrder ytorder = ytorderService.Get().Where(a => a.YTOrdernumber == YTOrdernumber).FirstOrDefault();
IEnumerable <YTOrderlist> ytorderlist = ytorderlistService.Get().Where(a => a.YTOrderid == ytorder.YTOrderid);
List <get_member> AccountList = new List <get_member>();
foreach (YTOrderlist ytordertemp in ytorderlist)
{
string Cookie = ytordertemp.YTMembers.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("'", @""""); // 將' 取代成 "
AccountList.Add(
new get_member
{
Memberid = Guid.Parse(ytordertemp.YTMemberid.ToString()),
Account = ytordertemp.YTAccount,
Password = ytordertemp.YTMembers.YT_Password,
Useragent_phone = ytordertemp.YTMembers.Useragent,
Cookie = Cookie
}
);
}
return(this.Json(AccountList, JsonRequestBehavior.AllowGet));
}
else
{
return(this.Json("Error", JsonRequestBehavior.AllowGet));
}
}
public ActionResult YTOrderrework(Guid YTOrderid, int p)
{
YTOrder ytorder = ytorderService.GetByID(YTOrderid);
ytorder.YTOrderStatus = 0; // 訂單狀態改為等待中
/**** 更新完成列表裡的帳號的Docker狀態 ****/
IEnumerable <YTMembers> YTMembers = ytmembersService.Get();
IEnumerable <YTOrderlist> YTOrderlist = ytorderlistService.Get().Where(a => a.YTOrderid == YTOrderid);
foreach (YTOrderlist list in YTOrderlist)
{
foreach (YTMembers YTMember in YTMembers)
{
if (YTMember.YTMemberid == list.YTMemberid)
{
YTMember.Isdocker = 0; // 關閉Docker 【0 : 關閉, 1 : 開啟】
ytmembersService.SpecificUpdate(YTMember, new string[] { "Isdocker" });
}
}
}
ytmembersService.SaveChanges();
ytorderService.SpecificUpdate(ytorder, new string[] { "YTOrderStatus" });
ytorderService.SaveChanges();
return(RedirectToAction("YTOrder", new { p = p }));
}
public JsonResult GetYTOrder_VideoLike(string Id)
{
if (Id == "CloudControl_order")
{
Product product = productService.GetByID(Guid.Parse("e06a7760-f8e8-4d45-8457-5734ae3c034b"));
YTOrder ytorder = ytorderService.Get().OrderBy(a => a.Createdate).Where(x => x.Productid == product.Productid).Where(c => c.YTOrderStatus == 1).FirstOrDefault();
if (ytorder == null)
{
ytorder = ytorderService.Get().OrderBy(a => a.Createdate).Where(x => x.Productid == product.Productid).Where(c => c.YTOrderStatus == 0).FirstOrDefault();
}
if (ytorder != null)
{
/*** 將訂單狀態改為進行中 ***/
ytorder.YTOrderStatus = 1;
ytorderService.SpecificUpdate(ytorder, new string[] { "YTOrderStatus" });
ytorderService.SaveChanges();
/*** 傳送訂單 ***/
string[] YTOrderArray = new string[4];
YTOrderArray[0] = ytorder.YTOrdernumber;
YTOrderArray[1] = ytorder.Remains.ToString();
YTOrderArray[2] = ytorder.Url;
YTOrderArray[3] = (Now + 3600).ToString();
return(this.Json(YTOrderArray, JsonRequestBehavior.AllowGet));
}
else
{
return(this.Json("目前沒有訂單", JsonRequestBehavior.AllowGet));
}
}
else
{
return(this.Json("Error", JsonRequestBehavior.AllowGet));
}
}
/*** 要YT影片收回不喜歡的訂單 ***/
public JsonResult GetYTOrder_VideoRegainDisLike(string Id)
{
if (Id == "CloudControl_order")
{
Product product = productService.GetByID(Guid.Parse("6698e003-de20-40d6-a47c-12ff4d0c2edf"));
YTOrder ytorder = ytorderService.Get().OrderBy(a => a.Createdate).Where(x => x.Productid == product.Productid).Where(c => c.YTOrderStatus == 5).FirstOrDefault();
if (ytorder == null)
{
ytorder = ytorderService.Get().OrderBy(a => a.Createdate).Where(x => x.Productid == product.Productid).Where(c => c.YTOrderStatus == 4).FirstOrDefault();
}
if (ytorder != null)
{
/*** 將訂單狀態改為收回中 ***/
ytorder.YTOrderStatus = 5;
ytorderService.SpecificUpdate(ytorder, new string[] { "YTOrderStatus" });
ytorderService.SaveChanges();
/*** 傳送訂單 ***/
string[] YTOrderArray = new string[4];
YTOrderArray[0] = ytorder.YTOrdernumber;
YTOrderArray[1] = ytorder.Remains.ToString();
YTOrderArray[2] = ytorder.Url;
return(this.Json(YTOrderArray, JsonRequestBehavior.AllowGet));
}
else
{
return(this.Json("目前沒有訂單", JsonRequestBehavior.AllowGet));
}
}
else
{
return(this.Json("Error", JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditYTOrder(Guid YTOrderid)
{
YTOrder ytorder = ytorderService.GetByID(YTOrderid);
if (TryUpdateModel(ytorder, new string[] { "Url", "Count", "Productid", "YTOrderStatus", "Categoryid", "Istest" }) && ModelState.IsValid)
{
/*** 訂單不是進行中，將完成名單的會員Docker關閉 ****/
if (ytorder.YTOrderStatus != 1)
{
IEnumerable <YTMembers> YTMembers = ytmembersService.Get();
IEnumerable <YTOrderlist> YTOrderlist = ytorderlistService.Get().Where(a => a.YTOrderid == YTOrderid);
foreach (YTOrderlist list in YTOrderlist)
{
foreach (YTMembers YTMember in YTMembers)
{
if (YTMember.YTMemberid == list.YTMemberid)
{
YTMember.Isdocker = 0; // 關閉Docker 【0 : 關閉, 1 : 開啟】
ytmembersService.SpecificUpdate(YTMember, new string[] { "Isdocker" });
}
}
}
ytmembersService.SaveChanges();
}
ytorderService.Update(ytorder);
ytorderService.SaveChanges();
}
return(RedirectToAction("YTOrder"));
}
public ActionResult DeleteYTOrder(Guid YTOrderid)
{
YTOrder ytorder = ytorderService.GetByID(YTOrderid);
ytorderService.Delete(ytorder);
ytorderService.SaveChanges();
return(RedirectToAction("YTOrder"));
}
public ActionResult YTOrderregain(Guid YTOrderid, int p)
{
YTOrder ytorder = ytorderService.GetByID(YTOrderid);
ytorder.YTOrderStatus = 4; // 訂單狀態改為等待收回中
ytorderService.SpecificUpdate(ytorder, new string[] { "YTOrderStatus" });
ytorderService.SaveChanges();
return(RedirectToAction("YTOrder", new { p = p }));
}
public ActionResult EditYTOrder(int p, Guid YTOrderid)
{
ViewBag.pageNumber = p;
YTOrder ytorder = ytorderService.GetByID(YTOrderid);
/**** Youtube產品選單 ****/
YTProductDropDownList(ytorder);
/**** 留言類別選單 ****/
CategoryMessageDropDownList(ytorder);
return(View(ytorder));
}
public JsonResult CheckYTOrderStatus(string Id, string YTOrdernumber)
{
if (Id == "CloudControl_order")
{
YTOrder ytorder = ytorderService.Get().Where(a => a.YTOrdernumber == YTOrdernumber).FirstOrDefault();
return(this.Json(ytorder.YTOrderStatus, JsonRequestBehavior.AllowGet));
}
else
{
return(this.Json("Error", JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddYTOrder(YTOrder ytorder)
{
if (TryUpdateModel(ytorder, new string[] { "Url", "Count", "Productid", "Categoryid", "Istest" }) && ModelState.IsValid)
{
ytorder.YTOrderid = Guid.NewGuid();
ytorder.Createdate = dt_tw();
ytorder.Updatedate = dt_tw();
ytorder.Remains = ytorder.Count;
ytorder.YTOrdernumber = "YTOrder" + dt_tw().ToString("yyyyMMddHHmmssfff");
ytorderService.Create(ytorder);
ytorderService.SaveChanges();
}
return(RedirectToAction("YTOrder"));
}
/**** 更新YT影片不喜歡的訂單 ***/
public JsonResult UpdateYTOrder_VideoRegainDisLike(string Id, string YTOrdernumber, string status)
{
if (Id == "CloudControl_order")
{
YTOrder ytorder = ytorderService.Get().Where(a => a.YTOrdernumber == YTOrdernumber).FirstOrDefault(); // 抓該訂單
if (status == "success")
{
ytorder.YTOrderStatus = 6; //狀態改已收回
ytorderService.SpecificUpdate(ytorder, new string[] { "YTOrderStatus" });
ytorderService.SaveChanges();
}
return(this.Json("Success", JsonRequestBehavior.AllowGet));
}
else
{
return(this.Json("Error", 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 UpdateYTRegainMember(string Id, string YTOrdernumber, string Memberid, string Cookie, int AccountStatus)
{
if (Id == "CloudControl_order")
{
YTOrder ytorder = ytorderService.Get().Where(a => a.YTOrdernumber == YTOrdernumber).FirstOrDefault();
YTMembers ytmembers = ytmembersService.GetByID(Guid.Parse(Memberid));
/*** 0 : 帳號需驗證，1 : 帳密輸入錯誤 or 密碼更改，2 : 成功執行，3 : 找不到讚的位置***/
if (AccountStatus == 0)
{
/**** 寫入TXT檔 *****/
using (StreamWriter sw = new StreamWriter(txt_filepath, true))
{
sw.Write("CloudControl訂單問題回報 訂單編號:" + ytorder.YTOrdernumber + "會員帳號:" + ytmembers.YT_Account + "登入有問題(帳號需驗證)");
sw.Write(Environment.NewLine);
sw.Write(dt_tw());
sw.Write(Environment.NewLine);
}
return(this.Json("Success"));
}
else if (AccountStatus == 1)
{
/**** 寫入TXT檔 *****/
using (StreamWriter sw = new StreamWriter(txt_filepath, true))
{
sw.Write("CloudControl訂單問題回報 訂單編號:" + ytorder.YTOrdernumber + "會員帳號:" + ytmembers.YT_Account + "登入有問題(密碼更改or帳密錯誤)");
sw.Write(Environment.NewLine);
sw.Write(dt_tw());
sw.Write(Environment.NewLine);
}
return(this.Json("Success"));
}
else if (AccountStatus == 2)
{
/**** 寫入TXT檔 *****/
using (StreamWriter sw = new StreamWriter(txt_filepath, true))
{
sw.Write("CloudControl訂單問題回報 訂單編號:" + ytorder.YTOrdernumber + "會員帳號:" + ytmembers.YT_Account + "執行成功");
sw.Write(Environment.NewLine);
sw.Write(dt_tw());
sw.Write(Environment.NewLine);
}
return(this.Json("Success"));
}
else
{
/**** 寫入TXT檔 *****/
using (StreamWriter sw = new StreamWriter(txt_filepath, true))
{
sw.Write("CloudControl訂單問題回報 訂單編號:" + ytorder.YTOrdernumber + " 會員帳號:" + ytmembers.YT_Account + "找不到執行的位置");
sw.Write(Environment.NewLine);
sw.Write(dt_tw());
sw.Write(Environment.NewLine);
}
return(this.Json("Success"));
}
}
else
{
return(this.Json("Error", JsonRequestBehavior.AllowGet));
}
}
public JsonResult UpdateYTMember(string Id, string YTOrdernumber, string Memberid, string Cookie, int AccountStatus)
{
if (Id == "CloudControl_order")
{
YTOrder ytorder = ytorderService.Get().Where(a => a.YTOrdernumber == YTOrdernumber).FirstOrDefault();
YTMembers ytmembers = ytmembersService.GetByID(Guid.Parse(Memberid));
/*** 0 : 帳號需驗證，1 : 帳密輸入錯誤 or 密碼更改，2 : 成功執行，3 : 找不到讚的位置***/
if (AccountStatus == 0)
{
/*** 將會員寫入會員紀錄裡 ***/
YTMembersLoginlog ytmembersloginlog = new YTMembersLoginlog();
ytmembersloginlog.Createdate = dt_tw();
ytmembersloginlog.YTMemberid = Guid.Parse(Memberid);
ytmembersloginlog.Status = 2; // 【 0:未驗證 , 1:已驗證 , 2:需驗證 】
ytmembersloginlogService.Create(ytmembersloginlog);
ytmembersloginlogService.SaveChanges();
/**** 寫入TXT檔 *****/
using (StreamWriter sw = new StreamWriter(txt_filepath, true))
{
sw.Write("CloudControl訂單問題回報 訂單編號:" + ytorder.YTOrdernumber + "會員帳號:" + ytmembers.YT_Account + "登入有問題(帳號需驗證)");
sw.Write(Environment.NewLine);
sw.Write(dt_tw());
sw.Write(Environment.NewLine);
}
return(this.Json("Success"));
}
else if (AccountStatus == 1)
{
/**** 寫入TXT檔 *****/
using (StreamWriter sw = new StreamWriter(txt_filepath, true))
{
sw.Write("CloudControl訂單問題回報 訂單編號:" + ytorder.YTOrdernumber + "會員帳號:" + ytmembers.YT_Account + "登入有問題(密碼更改or帳密錯誤)");
sw.Write(Environment.NewLine);
sw.Write(dt_tw());
sw.Write(Environment.NewLine);
}
return(this.Json("Success"));
}
else if (AccountStatus == 2)
{
/*** 更新該會員的Cookie *****/
ytmembers.Cookie = Cookie;
ytmembersService.SpecificUpdate(ytmembers, new string[] { "Cookie" });
ytmembersService.SaveChanges();
/**** 寫入登入表裡 ***/
YTMembersLoginlog ytmembersloginlog = new YTMembersLoginlog();
ytmembersloginlog.YTMemberid = Guid.Parse(Memberid);
ytmembersloginlog.Createdate = dt_tw();
ytmembersloginlog.Status = 1;
ytmembersloginlogService.Create(ytmembersloginlog);
ytmembersloginlogService.SaveChanges();
/*** 改訂單剩餘人數 ***/
ytorder.Remains -= 1;
ytorderService.SpecificUpdate(ytorder, new string[] { "Remains", "Cookie" });
ytorderService.SaveChanges();
YTOrderlist ytorderlist = new YTOrderlist();
ytorderlist.YTOrderlistid = Guid.NewGuid();
ytorderlist.YTMemberid = Guid.Parse(Memberid);
ytorderlist.YTAccount = ytmembers.YT_Account;
ytorderlist.YTOrderid = ytorder.YTOrderid;
ytorderlist.Createdate = dt_tw();
ytorderlist.Updatedate = dt_tw();
ytorderlistService.Create(ytorderlist);
ytorderlistService.SaveChanges();
return(this.Json("Success"));
}
else
{
/**** 寫入TXT檔 *****/
using (StreamWriter sw = new StreamWriter(txt_filepath, true))
{
sw.Write("CloudControl訂單問題回報 訂單編號:" + ytorder.YTOrdernumber + " 會員帳號:" + ytmembers.YT_Account + "找不到執行的位置");
sw.Write(Environment.NewLine);
sw.Write(dt_tw());
sw.Write(Environment.NewLine);
}
return(this.Json("Success"));
}
}
else
{
return(this.Json("Error", JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetYTMember(string Id, int number, string YTOrdernumber)
{
if (Id == "CloudControl_order")
{
YTOrder ytorder = ytorderService.Get().Where(a => a.YTOrdernumber == YTOrdernumber).FirstOrDefault(); // 撈該訂單
IEnumerable <YTOrderlist> ytorderlist = ytorderlistService.Get().Where(a => a.YTOrder.YTOrdernumber == YTOrdernumber); // 撈該訂單的完成列表
IEnumerable <YTOrder> old_ytorders = ytorderService.Get().Where(c => c.Productid == ytorder.Productid).Where(a => a.YTOrdernumber != YTOrdernumber).Where(x => x.Url == ytorder.Url); // 撈所有訂單裡網址為此訂單及產品為此訂單的資料
Product product = productService.GetByID(ytorder.Productid); // 撈此訂單所需的產品
List <get_old_member> MemberList = new List <get_old_member>();
/**** 先排除這張訂單的完成訂單裡的人 ****/
if (ytorderlist != null)
{
foreach (YTOrderlist list in ytorderlist)
{
string Account = Regex.Replace(list.YTMembers.YT_Account, @"[^a-z||A-Z||@||.||0-9]", "").Replace(" ", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點，其餘取代空值
MemberList.Add(
new get_old_member
{
Account = Account
});
}
}
/*** 將同網址的訂單的完成訂單裡的人排除掉 ****/
if (old_ytorders != null)
{
foreach (YTOrder old_ytorder in old_ytorders)
{
IEnumerable <YTOrderlist> old_ytorderlists = ytorderlistService.Get().Where(a => a.YTOrderid == old_ytorder.YTOrderid);
foreach (YTOrderlist old_ytorderlist in old_ytorderlists)
{
string Account = Regex.Replace(old_ytorderlist.YTMembers.YT_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 <YTMembers> YTMembers = ytmembersService.Get().Where(a => a.Lastdate <= Now).Where(x => x.YTMembersLoginlog.OrderByDescending(c => c.Createdate).FirstOrDefault().Status != 2).OrderBy(o => o.Lastdate); // 撈可用時間小於現在以及驗證狀態不是需驗證的會員
if (YTMembers != null)
{
foreach (YTMembers Member in YTMembers)
{
bool used = false;
int loop;
for (loop = 0; loop < MemberList.Count(); loop++)
{
if (Member.YT_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("'", @""""); // 將' 取代成 "
}
/**** 判斷這張單是否是留言訂單 ****/
if (product.Productid == Guid.Parse("205548ac-b02c-42a1-8e43-1ce78f451dd8"))
{
/**** 撈取該訂單的留言類別 ****/
Guid CategortMessageid = categorymessageService.GetByID(ytorder.Categoryid).Categoryid;
/*** 撈取該留言類別底下的留言 ***/
int messageConunt = messageService.Get().Where(a => a.Categoryid == ytorder.Categoryid).Count(); // 該留言類別底下的留言數量
Message[] message = messageService.Get().Where(a => a.Categoryid == ytorder.Categoryid).ToArray();
Random crandom = new Random();
int rand = crandom.Next(0, messageConunt - 1);
AccountList.Add(
new get_member
{
Memberid = Member.YTMemberid,
Account = Member.YT_Account,
Password = Member.YT_Password,
Useragent_phone = Member.Useragent,
Cookie = Cookie,
Message = message[rand].MessageName
}
);
used = true;
}
else
{
AccountList.Add(
new get_member
{
Memberid = Member.YTMemberid,
Account = Member.YT_Account,
Password = Member.YT_Password,
Useragent_phone = Member.Useragent,
Cookie = Cookie,
}
);
used = true;
}
}
}
/*** 可用人數小於該訂單所需人數 ****/
if (AccountList.Count() < number)
{
return(this.Json("數量不足", JsonRequestBehavior.AllowGet));
}
else
{
foreach (get_member entity in AccountList.Take(number))
{
/*** 將此會員更新下次互惠時間 ****/
YTMembers Member = ytmembersService.GetByID(entity.Memberid);
Member.Lastdate = Now + 120;
ytmembersService.SpecificUpdate(Member, new string[] { "Lastdate" });
}
ytmembersService.SaveChanges();
return(this.Json(AccountList.Take(number), JsonRequestBehavior.AllowGet));
}
}
else
{
return(this.Json("數量不足", JsonRequestBehavior.AllowGet));
}
}
else
{
return(this.Json("Error", JsonRequestBehavior.AllowGet));
}
}
