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));
}
}
