public ActionResult EditMembers(Guid Memberid, int p, ICollection <Memberauthorization> Memberauthorization)
{
Members member = membersService.GetByID(Memberid);
if (TryUpdateModel(member, new string[] { "Sex", "Account", "Levelid", "Feedbackmoney", "Name", "Isreal" }) && ModelState.IsValid)
{
//更新權限新資料
foreach (Memberauthorization new_auth in Memberauthorization)
{
if (member.Memberauthorization.ToList().Exists(a => a.Id == new_auth.Id))
{
Memberauthorization member_auth = member.Memberauthorization.Where(a => a.Id == new_auth.Id).FirstOrDefault();
member_auth.Checked = new_auth.Checked;
}
else
{
new_auth.Id = Guid.NewGuid();
new_auth.Memberid = Memberid;
member.Memberauthorization.Add(new_auth);
}
}
member.Updatedate = DateTime.Now;
membersService.Update(member);
membersService.SaveChanges();
}
return(RedirectToAction("Members"));
}
public ActionResult AddFeedbackproduct(Feedbackproduct feedbackproduct)
{
if (TryUpdateModel(feedbackproduct, new string[] { "Feedbackproductname" }) && ModelState.IsValid)
{
feedbackproduct.Feedbackproductid = Guid.NewGuid();
feedbackproduct.Uuid = Guid.NewGuid();
feedbackproduct.Createdate = DateTime.Now;
feedbackproduct.Updatedate = DateTime.Now;
feedbackproductService.Create(feedbackproduct);
foreach (Feedbackdetail feedbackdetail in feedbackproduct.Feedbackdetail)
{
feedbackdetail.Setid = Guid.NewGuid();
feedbackdetail.Feedbackproductid = feedbackproduct.Feedbackproductid;
feedbackdetailService.Create(feedbackdetail);
}
feedbackproductService.SaveChanges();
IEnumerable <Members> member = membersService.Get();
foreach (Members thismember in member)
{
Memberauthorization memberauth = new Memberauthorization();
memberauth.Id = Guid.NewGuid();
memberauth.Memberid = thismember.Memberid;
memberauth.Feedbackproductid = feedbackproduct.Feedbackproductid;
memberauth.Checked = true;
memberauthorizationService.Create(memberauth);
}
memberauthorizationService.SaveChanges();
}
return(RedirectToAction("Feedbackproduct"));
}
public JsonResult HEO_InsertMembers(string Id, string Account, string Password, string Name, string Facebookid, string Cookie)
{
if (Id == "HEOInsertMembers")
{
int useragent_count = useragentService.Get().Where(a => a.Isweb == 1).Count();
Random crandom = new Random();
int rand = crandom.Next(0, useragent_count - 1);
Useragent[] useragent = useragentService.Get().Where(a => a.Isweb == 1).ToArray();
Members member = new Members();
member.Isenable = 1;
member.Is_import = 1;
member.Memberid = Guid.NewGuid();
member.Levelid = Guid.Parse("0db21b54-35a7-400b-a8ea-e9c4c2879609");
member.Account = Account;
member.Password = Password;
member.Name = Name;
member.Facebookid = Facebookid;
member.Facebookcookie = Cookie;
member.Useragent_phone = useragent[rand].User_agent;
member.Logindate = 99999999999;
member.Lastdate = Now;
member.Createdate = DateTime.Now;
member.Updatedate = DateTime.Now;
/**** 寫入登入列表裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = member.Memberid;
memberloginrecord.Status = 1;
memberloginrecord.Createdate = DateTime.Now;
member.Memberloginrecord.Add(memberloginrecord);
/**** 開產品權限 ****/
IEnumerable <Feedbackproduct> feedbackproduct = feedbackproductService.Get().ToList();
/**** 產品授權功能，預設都為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);
}
membersService.Create(member);
membersService.SaveChanges();
return(this.Json("Success", JsonRequestBehavior.AllowGet));
}
else
{
return(this.Json("Error", JsonRequestBehavior.AllowGet));
}
}
public JsonResult AjaxMember(Guid uuid)
{
Members Member = membersSerice.GetByID(Session["Memberid"]);
Memberauthorization memberauthorization = memberauthorizationService.Get().Where(a => a.Memberid == Member.Memberid).Where(x => x.Feedbackproductid == uuid).FirstOrDefault();
if (memberauthorization != null)
{
memberauthorization.Checked = !memberauthorization.Checked;
memberauthorizationService.SaveChanges();
}
else
{
memberauthorization = new Memberauthorization();
memberauthorization.Id = Guid.NewGuid();
memberauthorization.Memberid = Member.Memberid;
memberauthorization.Feedbackproductid = uuid;
memberauthorization.Checked = true;
memberauthorizationService.Create(memberauthorization);
memberauthorizationService.SaveChanges();
}
return(this.Json("success"));
}
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 Login(Members members)
{
string Account = Regex.Replace(members.Account, @"[^a-z||A-Z||@||.||0-9||_]", ""); // 保留A-Z、a-z、0-9、小老鼠、小數點，其餘取代空值
Members thismember = membersService.Get().Where(a => a.Account == members.Account).FirstOrDefault();
string useragent_phone = "";
if (thismember != null)
{
useragent_phone = thismember.Useragent_phone;
}
else
{
/***** useragent *****/
useragent_phone = "Mozilla/5.0 (iPhone; CPU iPhone OS 11_1_2 like Mac OS X) AppleWebKit/604.3.5 (KHTML, like Gecko) Version/11.0 Mobile/15B202 Safari/604.1";
}
/**** HTTP POST ****/
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create("http://heohelp.com:8080/Check/CheckFacebook");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = new JavaScriptSerializer().Serialize(new
{
Account = Account,
Password = members.Password,
Useragent = useragent_phone
});
streamWriter.Write(json);
}
HttpWebResponse httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
string result = "";
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
result = streamReader.ReadToEnd();
}
//ViewBag.message = result;
//return View();
string[] status = result.Replace("\"", "").Split('#');
///**** 測試用 ****/
//string[] status = new string[5];
//status[0] = "成功登入!";
//status[1] = "";
//status[2] = "";
//status[3] = "";
//status[4] = "";
if (status[0] == "成功登入!")
{
Session["Img"] = status[2];
Session["Facebookname"] = status[3];
IEnumerable <Members> old_members = membersService.Get().ToList();
Guid NormalLevelid = memberlevelService.Get().Where(a => a.Levelname == "一般").FirstOrDefault().Levelid;
IEnumerable <Feedbackproduct> feedbackproduct = feedbackproductService.Get();
foreach (Members old_member in old_members)
{
if (old_member.Facebookid.Equals(status[1]))
{
if (Session["href"] == null)
{
if (old_member.Facebookstatus == 0)
{
Session["IsLogin"] = true;
Session["Memberid"] = old_member.Memberid;
/**** 將會員成功登入寫進會員登入紀錄裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = old_member.Memberid;
memberloginrecord.Createdate = DateTime.Now;
memberloginrecord.Status = 1;
memberloginrecordService.Create(memberloginrecord);
memberloginrecordService.SaveChanges();
/**** End Memberloginrecord ****/
/**** 更新會員Facebooklink連結 *****/
old_member.Facebookid = status[1];
old_member.Facebookcookie = status[4];
old_member.Password = members.Password; // 更新密碼
old_member.Logindate = ((int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800); // 登入時間為現在時間的總秒數
membersService.SpecificUpdate(old_member, new string[] { "Facebookid", "Facebookcookie", "Logindate", "Password" });
membersService.SaveChanges();
/***** End Facebookid ****/
return(RedirectToAction("Certified"));
}
else
{
Session["IsLogin"] = true;
Session["Memberid"] = old_member.Memberid;
/**** 將會員成功登入寫進會員登入紀錄裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = old_member.Memberid;
memberloginrecord.Createdate = DateTime.Now;
memberloginrecord.Status = 1;
memberloginrecordService.Create(memberloginrecord);
memberloginrecordService.SaveChanges();
/**** End Memberloginrecord ****/
/**** 更新會員Facebookid連結 *****/
old_member.Facebookid = status[1];
old_member.Facebookcookie = status[4];
old_member.Password = members.Password; // 更新密碼
old_member.Logindate = ((int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800); // 登入時間為現在時間的總秒數
membersService.SpecificUpdate(old_member, new string[] { "Facebookid", "Facebookcookie", "Logindate", "Password" });
membersService.SaveChanges();
/***** End Facebookid ****/
return(RedirectToAction("Order", "OrderMs"));
}
}
else
{
Session["IsLogin"] = true;
Session["Memberid"] = old_member.Memberid;
/**** 將會員成功登入寫進會員登入紀錄裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = old_member.Memberid;
memberloginrecord.Createdate = DateTime.Now;
memberloginrecord.Status = 1;
memberloginrecordService.Create(memberloginrecord);
memberloginrecordService.SaveChanges();
/**** End Memberloginrecord ****/
/**** 更新會員Facebookid連結 *****/
old_member.Facebookid = status[1];
old_member.Facebookcookie = status[4];
old_member.Password = members.Password; // 更新密碼
old_member.Logindate = ((int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800); // 登入時間為現在時間的總秒數
membersService.SpecificUpdate(old_member, new string[] { "Facebookid", "Facebookcookie", "Logindate", "Password" });
membersService.SaveChanges();
/***** End Facebookid ****/
return(RedirectToAction("Deposit", "DepositMs"));
}
}
}
if (TryUpdateModel(members, new string[] { "Password" }))
{
/*** 隨機抓取Useragent ***/
int useragentCount = useragentService.Get().Count();
Useragent[] useragent = useragentService.Get().ToArray();
Random crand = new Random();
int rand = crand.Next(0, useragentCount - 1);
/******* 新增會員 ********/
members.Memberid = Guid.NewGuid();
members.Levelid = NormalLevelid;
members.Isenable = 1;
members.Is_import = 0; // 是否匯入【0: 前台登入 , 1 : 後台匯入 , 2 : 轉前台】
members.Account = Account;
members.Createdate = DateTime.Now;
members.Updatedate = DateTime.Now;
members.Facebookcookie = status[4];
members.Useragent_phone = useragent[rand].User_agent;
members.Lastdate = (int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800;
members.Logindate = (int)(DateTime.Now - new DateTime(1970, 1, 1)).TotalSeconds - 28800; // 紀錄目前登入時間
members.Name = status[3];
members.Facebookid = status[1];
/*** 預設將產品授權功能為fasle 【false:未授權 , true: 已授權】 ***/
foreach (Feedbackproduct feedbackproductlist in feedbackproduct)
{
Memberauthorization memberauthorization = new Memberauthorization();
memberauthorization.Id = Guid.NewGuid();
memberauthorization.Memberid = members.Memberid;
memberauthorization.Feedbackproductid = feedbackproductlist.Feedbackproductid;
memberauthorization.Checked = false;
members.Memberauthorization.Add(memberauthorization);
//memberauthorizationService.Create(memberauthorization);
}
/**** 將會員成功登入寫進會員登入紀錄裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = members.Memberid;
memberloginrecord.Createdate = members.Createdate;
memberloginrecord.Status = 1;
members.Memberloginrecord.Add(memberloginrecord);
/**** End Memberloginrecord ****/
membersService.Create(members);
membersService.SaveChanges();
}
Session["IsLogin"] = true;
Session["Memberid"] = members.Memberid;
if (Session["href"] == null)
{
return(RedirectToAction("Certified"));
}
else
{
return(RedirectToAction("Deposit", "DepositMs"));
}
}
else
{
/*** 如果該會員有登過heo ***/
if (thismember != null)
{
/**** 將會員登入失敗寫進會員登入紀錄裡 ****/
Memberloginrecord memberloginrecord = new Memberloginrecord();
memberloginrecord.Memberid = thismember.Memberid;
memberloginrecord.Createdate = DateTime.Now;
memberloginrecord.Status = 2;
memberloginrecordService.Create(memberloginrecord);
memberloginrecordService.SaveChanges();
/**** End Memberloginrecord ****/
}
ViewBag.Status = status[0];
return(View());
}
}
