public ActionResult EditUseragent(int p, int Useragentid)
{
ViewBag.pageNumber = p;
Useragent useragent = useragentService.GetByID(Useragentid);
return(View(useragent));
}
public ActionResult DeleteUseragent(int Useragentid)
{
Useragent useragent = useragentService.GetByID(Useragentid);
useragentService.Delete(useragent);
useragentService.SaveChanges();
return(RedirectToAction("Useragent"));
}
public ActionResult AddUseragent(Useragent useragent)
{
if (TryUpdateModel(useragent, new string[] { "Useragent" }) && ModelState.IsValid)
{
useragentService.Create(useragent);
useragentService.SaveChanges();
}
return(RedirectToAction("Useragent"));
}
public ActionResult EditUseragent(int Useragentid)
{
Useragent useragent = useragentService.GetByID(Useragentid);
if (TryUpdateModel(useragent, new string[] { "Useragent" }) && ModelState.IsValid)
{
useragent.Createdate = dt_tw();
useragent.Updatedate = dt_tw();
useragentService.Update(useragent);
useragentService.SaveChanges();
}
return(RedirectToAction("Useragent"));
}
public ActionResult EditUseragent(int Id, Useragent useragent)
{
if (TryUpdateModel(useragent, new string[] { "Useragent", "Isweb" }) && ModelState.IsValid)
{
useragentService.Update(useragent);
useragentService.SaveChanges();
return(RedirectToAction("Useragent"));
}
else
{
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator.");
return(View(useragent));
}
}
public ActionResult AddMembers(Members members)
{
/*** 隨機指派手機版Useragent ***/
int useragent_phone = useragentService.Get().Where(a => a.Isweb == 1).Count();
Random rnd = new Random();
int rnd_useragent = rnd.Next(1, useragent_phone);
Useragent useragent = useragentService.Get().Where(a => a.Id == rnd_useragent).FirstOrDefault();
/*** End Useragent ***/
if (TryUpdateModel(members, new string[] { "Sex", "Account", "Password", "Facebookstauts", "Facebookid", "Feedbackmoney", "Name", "Isenable" }) && ModelState.IsValid)
{
members.Memberid = Guid.NewGuid();
members.Account = Regex.Replace(members.Account, @"[^a-z||A-Z||@||.||0-9]", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點，其餘取代空值
members.Createdate = DateTime.Now;
members.Updatedate = DateTime.Now;
members.Lastdate = ((int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds) - 28800; // 總秒數
members.Isenable = 1;
members.Is_import = 1;
members.Logindate = 99999999999;
members.Isreal = members.Isreal;
members.Levelid = members.Levelid;
members.Useragent_phone = useragent.User_agent;
members.Facebookid = members.Facebookid.Replace("https://www.facebook.com/profile.php?id=", "");
/**** 將會員寫進會員登入紀錄裡，預設狀態為0 【0 : 未驗證 , 1 : 已驗證 , 2 : 需驗證】 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = members.Memberid;
memberloginrecord.Createdate = members.Createdate;
memberloginrecord.Status = 0;
members.Memberloginrecord.Add(memberloginrecord);
/**** End Memberloginrecord ****/
membersService.Create(members);
foreach (Memberauthorization memberauthorization in members.Memberauthorization)
{
memberauthorization.Id = Guid.NewGuid();
memberauthorizationService.Create(memberauthorization);
}
membersService.SaveChanges();
}
return(RedirectToAction("Members"));
}
public void importtoSQL(string path)
{
IEnumerable <Feedbackproduct> feedbackproduct = feedbackproductService.Get().ToList();
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)
{
IEnumerable <Members> old_members = membersService.Get(); // 撈所有會員
Members member = new Members();
if (sheet.GetRow(i).GetCell(0).ToString() != "" && sheet.GetRow(i).GetCell(0).ToString() != null)
{
var test = sheet.GetRow(i).GetCell(3).ToString();
member.Account = Regex.Replace(sheet.GetRow(i).GetCell(0).ToString(), @"[^a-z||A-Z||@||.||0-9]", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點，其餘取代空值
member.Password = sheet.GetRow(i).GetCell(1).ToString();
member.Name = sheet.GetRow(i).GetCell(2).ToString();
member.Facebookid = sheet.GetRow(i).GetCell(3).ToString().Replace("https://www.facebook.com/profile.php?id=", "");
member.Levelid = Guid.Parse("0db21b54-35a7-400b-a8ea-e9c4c2879609");
member.Memberid = Guid.NewGuid();
member.Createdate = DateTime.Now;
member.Updatedate = DateTime.Now;
member.Isenable = 1;
member.Logindate = 99999999999;
member.Is_import = 1; // 是否匯入 【0 : 前台登入 , 1 : 後台匯入 , 2 : 轉前台】
member.Lastdate = ((int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds) - 28800;
/*** 隨機指派手機版Useragent ***/
int useragent_phone = useragentService.Get().Where(a => a.Isweb == 1).Count();
Random rnd = new Random();
int rnd_useragent = rnd.Next(1, useragent_phone);
Useragent useragent = useragentService.Get().Where(a => a.Id == rnd_useragent).FirstOrDefault();
/*** End Useragent ***/
member.Useragent_phone = useragent.User_agent;
/**** 產品授權功能，預設都為true 【false : 未授權 , true: 已授權】 ****/
foreach (Feedbackproduct productList in feedbackproduct)
{
Memberauthorization memberauthorization = new Memberauthorization();
memberauthorization.Id = Guid.NewGuid();
memberauthorization.Memberid = member.Memberid;
memberauthorization.Feedbackproductid = productList.Feedbackproductid;
memberauthorization.Checked = true;
member.Memberauthorization.Add(memberauthorization);
}
/**** 將會員寫進會員登入紀錄裡，預設狀態為0 【0 : 未驗證 , 1 : 已驗證 , 2 : 需驗證】 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = member.Memberid;
memberloginrecord.Createdate = member.Createdate;
memberloginrecord.Status = 0;
member.Memberloginrecord.Add(memberloginrecord);
/**** End Memberloginrecord ****/
membersService.Create(member);
}
}
}
membersService.SaveChanges();
}
public ActionResult AddUseragent(Useragent useragent)
{
useragentService.Create(useragent);
useragentService.SaveChanges();
return(RedirectToAction("Useragent"));
}
