public ContentResult UserChangePassWordSave(User userModel)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
string userName = User.Identity.Name.Split(',')[1];
int userId = Convert.ToInt32(User.Identity.Name.Split(',')[0]);
User user = UserService.GetModel(userId);
if (SqlHelper.Fun_Secret(userModel.user_Password_Model) == user.user_Password)
{
user.user_Password = SqlHelper.Fun_Secret(userModel.user_Password);
user.user_Update_Time = DateTime.Now;
UserService.Update(user);
jsonResult.result = true;
jsonResult.message = "";
}
else
{
jsonResult.result = false;
jsonResult.message = "The Old Password is not match!";
}
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public static void Delete(User model)
{
string sql = "select * from PSS_User where user_Id='" + model.user_Id + "'";
DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_User");
DataRow dr = ds.Tables["PSS_User"].Rows[0];
dr.Delete();
SqlHelper.UpdateDataSet(ds, sql, "PSS_User");
if (ds != null)
ds.Dispose();
}
public static List<User> GetList()
{
List<User> list = new List<User>();
User model = null;
string sql = "select * from PSS_User";
DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_User");
foreach(DataRow dr in ds.Tables["PSS_User"].Rows)
{
model = new User();
if (!string.IsNullOrEmpty(dr["user_Id"].ToString()))
{
model.user_Id = int.Parse(dr["user_Id"].ToString());
}
if (!string.IsNullOrEmpty(dr["user_Trimester_Id"].ToString()))
{
model.user_Trimester_Id = int.Parse(dr["user_Trimester_Id"].ToString());
}
model.user_Name = dr["user_Name"].ToString();
model.user_Password = dr["user_Password"].ToString();
model.user_Email = dr["user_Email"].ToString();
model.user_Telephone = dr["user_Telephone"].ToString();
model.user_StudentId = dr["user_StudentId"].ToString();
model.user_Introduction = dr["user_Introduction"].ToString();
model.user_Statue = (bool)dr["user_Statue"];
model.User_Email_Visiable = (bool)dr["User_Email_Visiable"];
model.User_Telephone_Visiable = (bool)dr["User_Telephone_Visiable"];
if (!string.IsNullOrEmpty(dr["user_Register_Time"].ToString()))
{
model.user_Register_Time = DateTime.Parse(dr["user_Register_Time"].ToString());
model.Register_Time = model.user_Register_Time.ToString("dd/MM/yyyy HH:mm:ss");
}
if (!string.IsNullOrEmpty(dr["user_Log_Time"].ToString()))
{
model.user_Log_Time = DateTime.Parse(dr["user_Log_Time"].ToString());
model.Log_Time = model.user_Log_Time.ToString("dd/MM/yyyy HH:mm:ss");
}
if (!string.IsNullOrEmpty(dr["user_Update_Time"].ToString()))
{
model.user_Update_Time = DateTime.Parse(dr["user_Update_Time"].ToString());
model.Update_Time = model.user_Update_Time.ToString("dd/MM/yyyy HH:mm:ss");
}
list.Add(model);
};
return list;
}
public ContentResult UserSave(User userModel, int?id)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
User user = null;
if (id.HasValue)
{
user = UserService.GetModel(id.Value);
}
else if(UserService.IsExistName(userModel.user_Name,userModel.user_Trimester_Id))
{
jsonResult.result = false;
jsonResult.message = "There is already exist the name, please change a userName!";
return Content(JsonConvert.SerializeObject(jsonResult));
}
else
{
user = new User();
user.user_Register_Time = DateTime.Now;
user.user_Log_Time = DateTime.Now;
}
user.user_Name = userModel.user_Name;
user.user_Password =SqlHelper.Fun_Secret(userModel.user_Password);
user.user_Email = userModel.user_Email;
user.user_Telephone = userModel.user_Telephone;
//user.user_Is_Teacher = userModel.user_Is_Teacher;
user.user_Skill = userModel.user_Skill;
user.user_Introduction = userModel.user_Introduction;
user.user_Update_Time = DateTime.Now;
user.user_Trimester_Id = userModel.user_Trimester_Id;
user.user_Statue = true;
if (id.HasValue)
{
UserService.Update(user);
}
else
{
UserService.Save(user);
}
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public ContentResult UserPersonalProfileSave(User userModel)
{
JsonDataGridResult jsonResult = new JsonDataGridResult();
try
{
string userName = User.Identity.Name.Split(',')[1];
int userId = Convert.ToInt32(User.Identity.Name.Split(',')[0]);
User user = UserService.GetModel(userId);
user.user_Email = userModel.user_Email;
user.user_Telephone = userModel.user_Telephone;
user.user_Skill = userModel.user_Skill;
user.user_Introduction = base.Server.UrlDecode(userModel.user_Introduction);
user.user_Update_Time = DateTime.Now;
user.user_Trimester_Id = userModel.user_Trimester_Id;
user.User_Email_Visiable = userModel.User_Email_Visiable;
user.User_Telephone_Visiable = userModel.User_Telephone_Visiable;
user.user_Update_Time = DateTime.Now;
UserService.Update(user);
jsonResult.result = true;
jsonResult.message = "";
}
catch (Exception ex)
{
jsonResult.result = false;
jsonResult.message = ex.Message;
}
string result = JsonConvert.SerializeObject(jsonResult);
return Content(result);
}
public static void Update(User model)
{
string sql = "select * from PSS_User where user_Id='" + model.user_Id + "'";
DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_User");
DataRow dr = ds.Tables["PSS_User"].Rows[0];
dr["user_Name"] = model.user_Name;
dr["user_Password"] = model.user_Password;
dr["user_Email"] = model.user_Email;
dr["user_Telephone"] = model.user_Telephone;
dr["user_Is_Teacher"] = model.user_Is_Teacher;
dr["user_StudentId"] = model.user_StudentId;
dr["user_Skill"] = model.user_Skill;
dr["user_Introduction"] = model.user_Introduction;
dr["user_Register_Time"] = model.user_Register_Time;
dr["user_Log_Time"] = model.user_Log_Time;
dr["user_Trimester_Id"] = model.user_Trimester_Id;
dr["user_Statue"] = model.user_Statue;
dr["User_Email_Visiable"] = model.User_Email_Visiable;
dr["User_Telephone_Visiable"] = model.User_Telephone_Visiable;
SqlHelper.UpdateDataSet(ds, sql, "PSS_User");
if (ds != null)
ds.Dispose();
}
public static void Save(User model)
{
string sql = "select * from PSS_User where 1<>1";
DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_User");
DataRow dr = ds.Tables["PSS_User"].NewRow();
int maxId = SqlHelper.GetMaxId("select max(user_Id) from PSS_User");
dr["user_Id"] = ++maxId;
dr["user_Name"] = model.user_Name;
dr["user_Password"] = model.user_Password;
dr["user_Email"] = model.user_Email;
dr["user_Telephone"] = model.user_Telephone;
dr["user_Is_Teacher"] = model.user_Is_Teacher;
dr["user_StudentId"] = model.user_StudentId;
dr["user_Skill"] = model.user_Skill;
dr["user_Introduction"] = model.user_Introduction;
dr["user_Register_Time"] = model.user_Register_Time;
dr["user_Log_Time"] = model.user_Log_Time;
dr["user_Update_Time"] = model.user_Update_Time;
dr["user_Trimester_Id"] = model.user_Trimester_Id;
dr["user_Statue"] = model.user_Statue;
dr["User_Email_Visiable"] = model.User_Email_Visiable;
dr["User_Telephone_Visiable"] = model.User_Telephone_Visiable;
ds.Tables["PSS_User"].Rows.Add(dr);
SqlHelper.UpdateDataSet(ds, sql, "PSS_User");
if (ds != null)
ds.Dispose();
}
public static User GetModel(int id)
{
string sql = "select * from PSS_User where user_Id='" + id + "'";
DataSet ds = SqlHelper.GetDataSetBySql(sql, "PSS_User");
User model = null;
if (ds.Tables[0].Rows.Count > 0)
{
model = new User();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["user_Id"].ToString()))
{
model.user_Id = int.Parse(ds.Tables[0].Rows[0]["user_Id"].ToString());
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["user_Trimester_Id"].ToString()))
{
model.user_Trimester_Id = int.Parse(ds.Tables[0].Rows[0]["user_Trimester_Id"].ToString());
}
model.user_Name = ds.Tables[0].Rows[0]["user_Name"].ToString();
model.user_Password = ds.Tables[0].Rows[0]["user_Password"].ToString();
model.user_Email = ds.Tables[0].Rows[0]["user_Email"].ToString();
model.user_Telephone = ds.Tables[0].Rows[0]["user_Telephone"].ToString();
model.user_StudentId = ds.Tables[0].Rows[0]["user_StudentId"].ToString();
model.user_Skill = ds.Tables[0].Rows[0]["user_Skill"].ToString();
model.user_Introduction = ds.Tables[0].Rows[0]["user_Introduction"].ToString();
model.user_Statue = (bool)ds.Tables[0].Rows[0]["user_Statue"];
model.User_Email_Visiable = (bool)ds.Tables[0].Rows[0]["User_Email_Visiable"];
model.User_Telephone_Visiable = (bool)ds.Tables[0].Rows[0]["User_Telephone_Visiable"];
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["user_Register_Time"].ToString()))
{
model.user_Register_Time = DateTime.Parse(ds.Tables[0].Rows[0]["user_Register_Time"].ToString());
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["user_Log_Time"].ToString()))
{
model.user_Log_Time = DateTime.Parse(ds.Tables[0].Rows[0]["user_Log_Time"].ToString());
}
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["user_Update_Time"].ToString()))
{
model.user_Update_Time = DateTime.Parse(ds.Tables[0].Rows[0]["user_Update_Time"].ToString());
}
}
if (ds != null)
ds.Dispose();
return model;
}
public static List<User> GetList(Paging paging, string order, string sort, int trimesterId,string status, string queryWord)
{
List<User> list = new List<User>();
User model = null;
DataSet ds = SqlHelper.GetListByPage("PSS_User","user_Trimester_Id", trimesterId,status,paging, order, sort);
foreach (DataRow dr in ds.Tables["PSS_User"].Rows)
{
model = new User();
if (!string.IsNullOrEmpty(dr["user_Id"].ToString()))
{
model.user_Id = int.Parse(dr["user_Id"].ToString());
}
model.user_Name = dr["user_Name"].ToString();
model.user_Password = dr["user_Password"].ToString();
model.user_Email = dr["user_Email"].ToString();
model.user_Telephone = dr["user_Telephone"].ToString();
model.user_StudentId = dr["user_StudentId"].ToString();
model.user_Skill = dr["user_Skill"].ToString();
model.user_Introduction = dr["user_Introduction"].ToString();
model.user_Statue = (bool)dr["user_Statue"];
model.User_Email_Visiable = (bool)dr["User_Email_Visiable"];
model.User_Telephone_Visiable = (bool)dr["User_Telephone_Visiable"];
if (!string.IsNullOrEmpty(dr["user_Register_Time"].ToString()))
{
model.user_Register_Time = DateTime.Parse(dr["user_Register_Time"].ToString());
model.Register_Time = model.user_Register_Time.ToString("dd/MM/yyyy HH:mm:ss");
}
if (!string.IsNullOrEmpty(dr["user_Log_Time"].ToString()))
{
model.user_Log_Time = DateTime.Parse(dr["user_Log_Time"].ToString());
model.Log_Time = model.user_Log_Time.ToString("dd/MM/yyyy HH:mm:ss");
}
if (!string.IsNullOrEmpty(dr["user_Update_Time"].ToString()))
{
model.user_Update_Time = DateTime.Parse(dr["user_Update_Time"].ToString());
model.Update_Time = model.user_Update_Time.ToString("dd/MM/yyyy HH:mm:ss");
}
list.Add(model);
};
return list;
}
public ActionResult RegisterIndex(User model)
{
string sError = "";
if (ModelState.IsValid)
{
try
{
SqlHelper.Initialization();
List<SelectListItem> listTrimester = new List<SelectListItem>();
foreach (Trimester tri in TrimesterService.GetList().Where(item => item.tri_IsOpen == true))
{
listTrimester.Add(new SelectListItem { Text = tri.tri_Name, Value = tri.tri_Id.ToString() });
}
ViewData["listTrimester"] = listTrimester;
if (!UserService.IsExistName(model.user_Name_Model,model.user_Trimester_Id))
{
if (model.user_Password_Model == model.user_confire_Password_Model)
{
model.user_Name = model.user_Name_Model;
model.user_Password = SqlHelper.Fun_Secret(model.user_Password_Model);
model.user_Is_Teacher = false;
model.user_Register_Time = DateTime.Now;
model.user_Log_Time = DateTime.Now;
model.user_Update_Time = DateTime.Now;
UserService.Save(model);
//Object _n = new Object { Title = "注册成功", Details = "您已经成功注册，用户为：" + _user.UserName + " ，请牢记您的密码！", DwellTime = 5, Navigation = Url.Action("FrameIndex", "Frame") };
return Content("<script>alert('添加成功！');window.location=''</script>");
//return RedirectToAction(("FrameIndex", "Frame");
//return RedirectToAction("FrameIndex", "Frame");
}
else
{
sError = "The PassWord and Comfirm Password is not same!";
}
}
else
{
sError = "There is already exist the name, please change a userName!";
}
}
catch (Exception ex)
{
sError = ex.Message;
}
if (!string.IsNullOrEmpty(sError))
ModelState.AddModelError("", sError);
}
SqlHelper.Dispose();
return View(model);
}