public string diarydelete([FromBody] JObject obj) { var diarypagenum = new { pagenum = Convert.ToInt32(obj["pagenum"]) }; using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne()) { Diaryinfo_tb diarycount = diarydb.Diaryinfo_tb.Where(diary => diary.DiaryinfoID == diarypagenum.pagenum).FirstOrDefault(); diarydb.Diaryinfo_tb.Remove(diarycount); return(diarydb.SaveChanges() > 0?"Yes": "No"); } }
public string vipover([FromBody] JObject obj) { var vipinfo = new { userid = Convert.ToInt32(obj["userid"]) }; using (DiaryDBEntitiesOne ohlifedb = new DiaryDBEntitiesOne()) { User_tb userinfo = ohlifedb.User_tb.Where(info => info.User_tbID == vipinfo.userid).FirstOrDefault(); userinfo.Memberstate = false; return(ohlifedb.SaveChanges() > 0 ? "Yes" : "No"); } }
public string newpwd([FromBody] JObject obj) { var userobj = new { userid = Convert.ToInt32(obj["userid"]), pwd = obj["pwd"].ToString() }; using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne()) { User_tb userinfo = diarydb.User_tb.Where(a => a.User_tbID == userobj.userid).FirstOrDefault(); userinfo.Passwordr = userobj.pwd; return(diarydb.SaveChanges() > 0 ? "Yes" : "No"); } }
public string tovip([FromBody] JObject obj) { var vipinfo = new { begintime = obj["begintime"], overtime = obj["overtimes"], userid = Convert.ToInt32(obj["userid"]) }; using (DiaryDBEntitiesOne ohlifedb = new DiaryDBEntitiesOne()) { User_tb userinfo = ohlifedb.User_tb.Where(info => info.User_tbID == vipinfo.userid).FirstOrDefault(); userinfo.Memberstate = true; // var ss = Convert.ToDateTime(vipinfo.begintime); // var dd= Convert.ToDateTime(vipinfo.overtime); userinfo.Memberopen = Convert.ToDateTime(vipinfo.begintime); userinfo.Memberover = Convert.ToDateTime(vipinfo.overtime); return(ohlifedb.SaveChanges() > 0 ? "Yes" : "No"); } }
public string diaryinsert([FromBody] JObject obj) { var diaryinfo = new { userid = obj["userid"], diarytype = obj["diarytype"], diarycontent = obj["diarycontent"], diarymedia = obj["diarymedia"] }; using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne()) { var Diaryinfo = new Diaryinfo_tb(); Diaryinfo.User_tbID = (int)diaryinfo.userid; Diaryinfo.Diarytype = (int)diaryinfo.diarytype; Diaryinfo.Diarycontent = (string)diaryinfo.diarycontent; Diaryinfo.Diarymedia = (string)diaryinfo.diarymedia; Diaryinfo.Diarytime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); diarydb.Diaryinfo_tb.Add(Diaryinfo); return(diarydb.SaveChanges() > 0 ? "Yes" : "No"); } }
public string newuser([FromBody] JObject obj) { var userobj = new { Accountnumber = obj["Accountnumber"], pwd = obj["pwd"].ToString() }; using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne()) { User_tb userinfo = new User_tb(); userinfo.Accountnumber = userobj.Accountnumber.ToString(); userinfo.Passwordr = userobj.pwd; userinfo.Registertime = DateTime.Now; userinfo.Memberover = DateTime.Now; userinfo.Memberstate = false; userinfo.Accountstate = true; diarydb.User_tb.Add(userinfo); return(diarydb.SaveChanges() > 0 ? "Yes" : "No"); } }