public ActionResult AddYTMembers(YTMembers ytmember)
{
if (TryUpdateModel(ytmember, new string[] { "YT_Account", "YT_Password", "Youtubelink", "YT_Name", "Isenable", "Productid" }) && ModelState.IsValid)
{
ytmember.YTMemberid = Guid.NewGuid();
ytmember.YT_Account = Regex.Replace(ytmember.YT_Account, @"[^a-z||A-Z||@||.||0-9]", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點，其餘取代空值
ytmember.Createdate = dt_tw();
ytmember.Updatedate = dt_tw();
ytmember.Lastdate = ((int)(dt_tw() - new DateTime(1970, 1, 1)).TotalSeconds) - 28800; // 總秒數
ytmember.Isenable = 1;
/*** 隨機抓取Useragent ***/
int useragentCount = useragentService.Get().Count();
Useragent[] useragent = useragentService.Get().ToArray();
Random crand = new Random();
int rand = crand.Next(0, useragentCount - 1);
ytmember.Useragent = useragent[rand].User_agent;
/**** 將會員寫進會員登入紀錄裡，預設狀態為0 【0 : 未驗證 , 1 : 已驗證 , 2 : 需驗證】 ****/
YTMembersLoginlog ytmembersloginlog = new YTMembersLoginlog();
ytmembersloginlog.YTMemberid = ytmember.YTMemberid;
ytmembersloginlog.Createdate = dt_tw();
ytmembersloginlog.Status = 0;
ytmember.YTMembersLoginlog.Add(ytmembersloginlog);
/**** End Memberloginrecord ****/
ytmembersService.Create(ytmember);
ytmembersService.SaveChanges();
}
return(RedirectToAction("YTMembers"));
}
public void import_YTMemberstoSQL(string path)
{
IWorkbook workBook;
using (var fs = new FileStream(path, FileMode.Open, FileAccess.ReadWrite))
{
workBook = new XSSFWorkbook(fs);
}
var sheet = workBook.GetSheet("工作表1");
for (var i = 1; i <= sheet.LastRowNum; i++)
{
var j = sheet.LastRowNum;
if (sheet.GetRow(i) != null)
{
YTMembers ytmember = new YTMembers();
if (sheet.GetRow(i).GetCell(0).ToString() != "" && sheet.GetRow(i).GetCell(0).ToString() != null)
{
var test = sheet.GetRow(i).GetCell(3).ToString();
ytmember.YT_Account = Regex.Replace(sheet.GetRow(i).GetCell(0).ToString(), @"[^a-z||A-Z||@||.||0-9]", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點，其餘取代空值
ytmember.YT_Password = sheet.GetRow(i).GetCell(1).ToString();
ytmember.YT_Name = sheet.GetRow(i).GetCell(2).ToString();
ytmember.Youtubelink = sheet.GetRow(i).GetCell(3).ToString();
ytmember.Cookie = sheet.GetRow(i).GetCell(4).ToString();
ytmember.YTMemberid = Guid.NewGuid();
ytmember.Createdate = dt_tw();
ytmember.Updatedate = dt_tw();
ytmember.Isenable = 1;
ytmember.Lastdate = ((int)(dt_tw() - new DateTime(1970, 1, 1)).TotalSeconds) - 28800;
/*** 隨機指派手機版Useragent ***/
int useragent_phone = useragentService.Get().Count();
Useragent[] useragent = useragentService.Get().ToArray();
Random rnd = new Random();
int rnd_useragent = rnd.Next(1, useragent_phone - 1);
/*** End Useragent ***/
ytmember.Useragent = useragent[rnd_useragent].User_agent;
/**** 將會員寫進會員登入紀錄裡，預設狀態為0 【0 : 未驗證 , 1 : 已驗證 , 2 : 需驗證】 ****/
YTMembersLoginlog ytmembersloginlog = new YTMembersLoginlog();
ytmembersloginlog.YTMemberid = ytmember.YTMemberid;
ytmembersloginlog.Createdate = dt_tw();
ytmembersloginlog.Status = 0;
ytmember.YTMembersLoginlog.Add(ytmembersloginlog);
/**** End LoginLog ****/
ytmembersService.Create(ytmember);
}
}
}
ytmembersService.SaveChanges();
}
public ActionResult EditYTMembers(Guid YTMemberid, int Status)
{
YTMembersLoginlog ytmembersloginlog = new YTMembersLoginlog();
YTMembers ytmember = ytmembersService.GetByID(YTMemberid);
if (TryUpdateModel(ytmember, new string[] { "YT_Account", "YT_Password", "Youtubelink", "YT_Name", "Productid" }) && ModelState.IsValid)
{
ytmember.YT_Account = Regex.Replace(ytmember.YT_Account, @"[^a-z||A-Z||@||.||0-9]", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點，其餘取代空值
ytmembersService.Update(ytmember);
ytmembersService.SaveChanges();
ytmembersloginlog.YTMemberid = YTMemberid;
ytmembersloginlog.Status = Status;
ytmembersloginlog.Createdate = DateTime.Now;
ytmembersloginlogService.Create(ytmembersloginlog);
ytmembersloginlogService.SaveChanges();
}
return(RedirectToAction("YTMembers"));
}
public JsonResult Test_Api(string Id)
{
if (Id == "taepsit")
{
IEnumerable <YTMembers> ytmembers = ytmembersService.Get().Where(a => a.Isenable == 0);
foreach (YTMembers member in ytmembers)
{
YTMembersLoginlog ytmembersloginlog = new YTMembersLoginlog();
ytmembersloginlog.Createdate = dt_tw();
ytmembersloginlog.Status = 2;
ytmembersloginlog.YTMemberid = member.YTMemberid;
ytmembersloginlogService.Create(ytmembersloginlog);
}
ytmembersloginlogService.SaveChanges();
return(this.Json("Success", JsonRequestBehavior.AllowGet));
}
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));
}
}
