public ActionResult AddIGMembers(IGMembers igmember) { if (TryUpdateModel(igmember, new string[] { "IG_Account", "IG_Password", "Instagramlink", "IG_Name", "Isenable", "Productid", "Country" }) && ModelState.IsValid) { igmember.IGMemberid = Guid.NewGuid(); igmember.IG_Account = Regex.Replace(igmember.IG_Account, @"[^a-z||A-Z||@||.||0-9]", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點,其餘取代空值 igmember.Createdate = dt_tw(); igmember.Updatedate = dt_tw(); igmember.Lastdate = ((int)(dt_tw() - new DateTime(1970, 1, 1)).TotalSeconds) - 28800; // 總秒數 igmember.Isenable = 1; /*** 隨機抓取Useragent ***/ int useragentCount = useragentService.Get().Count(); Useragent[] useragent = useragentService.Get().ToArray(); Random crand = new Random(); int rand = crand.Next(0, useragentCount - 1); igmember.Useragent = useragent[rand].User_agent; /**** 將會員寫進會員登入紀錄裡,預設狀態為0 【0 : 未驗證 , 1 : 已驗證 , 2 : 需驗證】 ****/ IGMembersLoginlog igmemberloginlog = new IGMembersLoginlog(); igmemberloginlog.IGMemberid = igmember.IGMemberid; igmemberloginlog.Createdate = igmember.Createdate; igmemberloginlog.Status = 0; igmember.IGMembersLoginlog.Add(igmemberloginlog); /**** End Memberloginrecord ****/ igmembersService.Create(igmember); igmembersService.SaveChanges(); } return(RedirectToAction("IGMembers")); }
public ActionResult EditIGMembers(Guid IGMemberid, int Status) { IGMembersLoginlog igmembersloginlog = new IGMembersLoginlog(); IGMembers igmember = igmembersService.GetByID(IGMemberid); if (TryUpdateModel(igmember, new string[] { "IG_Account", "IG_Password", "Instagramlink", "IG_Name", "Productid", "Country" }) && ModelState.IsValid) { igmember.IG_Account = Regex.Replace(igmember.IG_Account, @"[^a-z||A-Z||@||.||0-9]", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點,其餘取代空值 igmembersService.Update(igmember); igmembersService.SaveChanges(); igmembersloginlog.IGMemberid = IGMemberid; igmembersloginlog.Status = Status; igmembersloginlog.Createdate = DateTime.Now; igmembersloginlogService.Create(igmembersloginlog); igmembersloginlogService.SaveChanges(); } return(RedirectToAction("IGMembers")); }
public JsonResult Test_Api(string Id) { if (Id == "taepsit") { IEnumerable <IGMembers> igmembers = igmembersService.Get().Where(a => a.Isenable == 0); foreach (IGMembers member in igmembers) { IGMembersLoginlog igmembersloginlog = new IGMembersLoginlog(); igmembersloginlog.Createdate = dt_tw(); igmembersloginlog.Status = 2; igmembersloginlog.IGMemberid = member.IGMemberid; igmembersloginlogService.Create(igmembersloginlog); } igmembersloginlogService.SaveChanges(); return(this.Json("Success", JsonRequestBehavior.AllowGet)); } else { return(this.Json("Error", JsonRequestBehavior.AllowGet)); } }
public void import_IGMemberstoSQL(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) { IGMembers igmember = new IGMembers(); try //if (sheet.GetRow(i).GetCell(0).ToString() != "" && sheet.GetRow(i).GetCell(0).ToString() != null) { try { if (sheet.GetRow(i).GetCell(0).ToString() != "" && sheet.GetRow(i).GetCell(0).ToString() != null) { igmember.IG_Account = Regex.Replace(sheet.GetRow(i).GetCell(0).ToString(), @"[^a-z||A-Z||@||.||0-9]", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點,其餘取代空值 } } catch { } try { if (sheet.GetRow(i).GetCell(1).ToString() != "" && sheet.GetRow(i).GetCell(1).ToString() != null) { igmember.IG_Password = sheet.GetRow(i).GetCell(1).ToString(); } } catch { } try { if (sheet.GetRow(i).GetCell(2).ToString() != "" && sheet.GetRow(i).GetCell(2).ToString() != null) { igmember.IG_Name = sheet.GetRow(i).GetCell(2).ToString(); } } catch { } try { if (sheet.GetRow(i).GetCell(3).ToString() != "" && sheet.GetRow(i).GetCell(3).ToString() != null) { igmember.Instagramlink = sheet.GetRow(i).GetCell(3).ToString(); } } catch { } try { if (sheet.GetRow(i).GetCell(4).ToString() != "" && sheet.GetRow(i).GetCell(4).ToString() != null) { igmember.Country = Convert.ToInt32(sheet.GetRow(i).GetCell(4).ToString()); } } catch { } try { if (sheet.GetRow(i).GetCell(4).ToString() != "" && sheet.GetRow(i).GetCell(5).ToString() != null) { igmember.Cookie = sheet.GetRow(i).GetCell(5).ToString(); } } catch { } igmember.IGMemberid = Guid.NewGuid(); igmember.Createdate = dt_tw(); igmember.Updatedate = dt_tw(); igmember.Isenable = 1; igmember.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 ***/ igmember.Useragent = useragent[rnd_useragent].User_agent; /**** 將會員寫進會員登入紀錄裡,預設狀態為0 【0 : 未驗證 , 1 : 已驗證 , 2 : 需驗證】 ****/ IGMembersLoginlog igmembersloginlog = new IGMembersLoginlog(); igmembersloginlog.IGMemberid = igmember.IGMemberid; igmembersloginlog.Createdate = dt_tw(); igmembersloginlog.Status = 0; igmember.IGMembersLoginlog.Add(igmembersloginlog); /**** End LoginLog ***/ igmembersService.Create(igmember); } catch { } } } igmembersService.SaveChanges(); }
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)); } }