public void UserInfo()
{
Info = dbEntity.tbl_userInfo.ToList().Where(x => x.E_id == Convert.ToInt32(Session["Eid"].ToString())).FirstOrDefault();
txtFname.Text = Info.fname;
txtLname.Text = Info.lname;
txtDeg.Text = Info.designation;
txtUname.Text = Info.username;
txtPWord.Text = Info.password;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Info = dbEntity.tbl_userInfo.ToList().Where(x => x.E_id == Convert.ToInt32(Session["Eid"].ToString())).FirstOrDefault();
Info.fname = txtFname.Text;
Info.lname = txtLname.Text;
Info.designation = txtDeg.Text;
Info.password = txtPWord.Text;
dbEntity.AddTotbl_userInfo(Info);
dbEntity.SaveChanges();
}
protected void btnSubmitProfile_Click(object sender, EventArgs e)
{
DinningManagementEntities2 db = new DinningManagementEntities2();
tbl_userInfo ufoObj = new tbl_userInfo();
ufoObj.fname = txtFname.Text.ToString();
ufoObj.lname = txtLname.Text.ToString();
ufoObj.designation = txtDeg.Text.ToString();
ufoObj.username = txtUname.Text.ToString();
ufoObj.password = txtPWord.Text.ToString();
db.AddTotbl_userInfo(ufoObj);
db.SaveChanges();
clean();
}
public ApiReplyModel InsertNewUser(tbl_user model)
{
ApiReplyModel aj = new ApiReplyModel();
aj.isSuccess = false;
if (model != null && !string.IsNullOrEmpty(model.token))
{
tbl_user modelUser = DHelper.DapperC.SelectSingle <tbl_user>(new { token = model.token }, " token=@token", "");
tbl_userInfo modelUserInfo = DHelper.DapperC.SelectSingle <tbl_userInfo>(new { token = model.token }, " token=@token", "updatetime desc");
if (modelUser != null)
{
modelUser.uptime = DateTime.Now;
DHelper.DapperC.Update(modelUser);
if (modelUserInfo == null)
{
aj.code = 1000;
}
else
{
var addTimes = Convert.ToDateTime(modelUserInfo.addtime);
//创建时间小于去年9月
if (addTimes < Convert.ToDateTime((DateTime.Now.Year - 1) + "-09-01"))
{
aj.code = 1001;
}
else
{
aj.code = 2000;
}
}
}
else
{
model.usertype = 1;
model.status = 1;
model.usertype = 0;
model.addtime = DateTime.Now;
model.uptime = DateTime.Now;
DHelper.DapperC.Insert(model);
aj.code = 1000;
}
aj.isSuccess = true;
}
return(aj);
}
