public HttpResponseMessage login([FromBody] JObject obj)
{
var userobj = new { name = obj["name"].ToString(), pwd = obj["pwd"].ToString() };
using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne())
{
var userinfo = diarydb.User_tb.Select(users => new { users.Accountnumber, users.User_tbID, users.Passwordr }).Where(users => users.Accountnumber == userobj.name && users.Passwordr == userobj.pwd);
return(ObjToJson(userinfo));
}
}
public HttpResponseMessage diarycontent([FromBody] JObject obj)
{
var diarypagenum = new { pagenum = Convert.ToInt32(obj["pagenum"]) };
using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne())
{
var diarycount = diarydb.Diaryinfo_tb.Select(diary => new { diary.Diarycontent, diary.Diarymedia, diary.DiaryinfoID }).Where(diary => diary.DiaryinfoID == diarypagenum.pagenum);
return(ObjToJson(diarycount));
}
}
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 HttpResponseMessage diaryortime([FromBody] JObject obj)
{
var userobj = new { userID = Convert.ToInt32(obj["userID"]), diaryindex = Convert.ToInt32(obj["diaryindex"]), diarysize = Convert.ToInt32(obj["diarysize"]), diarytype = Convert.ToInt32(obj["diarytype"]), diarytime = DateTime.Parse(obj["diarytime"].ToString()) };
using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne())
{
var diaryinfo = diarydb.Diaryinfo_tb.Select(diary => new { diary.DiaryinfoID, diary.Diarycontent, diary.Diarytime, diary.User_tbID, diary.Diarytype }).Where(user => user.User_tbID == userobj.userID && user.Diarytype == userobj.diarytype && user.Diarytime == userobj.diarytime);
int listcount = diaryinfo.Count();
diaryinfo = diaryinfo.OrderByDescending(diary => diary.Diarytime);
return(ObjToJson(new { nzTotal = listcount, rows = diaryinfo.Skip((userobj.diaryindex - 1) * userobj.diarysize).Take(userobj.diarysize) }));
}
}
public HttpResponseMessage loginstate([FromBody] JObject obj)
{
var userobj = new { userid = Convert.ToInt32(obj["userid"]) };
using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne())
{
var userinfo = diarydb.User_tb.Select(users => new { users.Memberstate,
users.User_tbID,
users.Memberover }).Where(users => users.User_tbID == userobj.userid);
return(ObjToJson(new { date = DateTime.Now.ToString("yyyy/MM/dd"), info = userinfo }));
}
}
public HttpResponseMessage diarycount([FromBody] JObject obj)
{
var userinfo = new { userid = Convert.ToInt32(obj["userid"]) };
using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne())
{
int alldiary = diarydb.Diaryinfo_tb.Select(diary => new { diary.DiaryinfoID, diary.Diarytype, diary.User_tbID }).Where(type => type.User_tbID == userinfo.userid).Count();
int text = diarydb.Diaryinfo_tb.Select(diary => new { diary.DiaryinfoID, diary.Diarytype, diary.User_tbID }).Where(type => type.Diarytype == 1 && type.User_tbID == userinfo.userid).Count();
int picyure = diarydb.Diaryinfo_tb.Select(diary => new { diary.DiaryinfoID, diary.Diarytype, diary.User_tbID }).Where(type => type.Diarytype == 2 && type.User_tbID == userinfo.userid).Count();
int audio = diarydb.Diaryinfo_tb.Select(diary => new { diary.DiaryinfoID, diary.Diarytype, diary.User_tbID }).Where(type => type.Diarytype == 3 && type.User_tbID == userinfo.userid).Count();
return(ObjToJson(new { alldiarynum = alldiary, textnum = text, picyurenum = picyure, audionum = audio }));
}
}
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");
}
}
