public bool UpdateUserAccount(Users_Model users_Model)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = _dbContext.Users.Where(act => act.UserID == users_Model.UserID).FirstOrDefault();
data.UserProfileID = users_Model.UserProfileID;
data.DistrubitorID = users_Model.DistrubitorID;
data.FullName = users_Model.FullName;
data.MobileNo = users_Model.MobileNo;
if (users_Model.ImageString != null)
{
data.ImageString = users_Model.ImageString;
}
data.UsersStatus = users_Model.UsersStatus;
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public ActionResult UserDelete(Users_Model user_)
{
var User_Name = user_.FullName;
var UserData = new Users_Model();
Verification_Interface verification_ = new Verification_service();
var Message = "";
try
{
if (Users_Interface_.UserExists(user_.UserID))
{
UserData = Users_Interface_.GetModelOnlyById(user_.UserID);
if (UserData.DistrubitorID != null)
{
if (Users_Interface_.MakeDistrubitorNull(user_.UserID))
{
Message = ", distributor account unlinked";
}
//make distributor null first
}
if (verification_.VerificationExists(user_.UserID))
{
if (verification_.DeleteVerification(user_.UserID))
{
Message += ", verification details removed";
}
//delete verification first
}
/*delede user folder*/
string Root = "~/UserInformation";
string Email = UserData.Email;
string RootDir = Server.MapPath(Root + "/" + Email);
if (Directory.Exists(RootDir))
{
Directory.Delete(RootDir, true);
Message += ", user directory deleted";
}
if (Users_Interface_.DeleteUser(user_.UserID))
{
/*delete user*/
Message += " and user deleted finally.";
return(Json(User_Name + "'s " + Message));
}
else
{
return(Json("Error"));
}
}
else
{
Session["Error"] = User_Name + " not found!!";
return(View("Users"));
}
}
catch (Exception e)
{
return(Json("Error" + e.ToString()));
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
Users_Model usermodel = new Users_Model();
usermodel.LoginPwd = context.Request.Form["txtpwd"];
usermodel.NickName = context.Request.Form["txtnick"];
usermodel.Sex = context.Request.Form["txtsex"];
usermodel.Age = Convert.ToInt32(context.Request.Form["txtage"]);
usermodel.FaceId = Convert.ToInt32(context.Request.Form["txtface"]);
usermodel.Friend = Convert.ToInt32(context.Request.Form["txtfriend"]);
usermodel.Name = context.Request.Form["txtname"];
usermodel.StarId = Convert.ToInt32(context.Request.Form["txtstar"]);
usermodel.BloodId = Convert.ToInt32(context.Request.Form["txtblood"]);
Users_Service userservice = new Users_Service();
if (userservice.AddUser(usermodel))
{
context.Response.Redirect("Index.ashx");
}
else
{
context.Response.Redirect("Error.ashx");
}
}
public List <Users_Model> GetPageList(int start, int end)
{
string sql = "select * from(select *,row_number() over(order by id) as num from users)as t where num>=@start and num<=@end";
SqlParameter[] pars =
{
new SqlParameter("@start", start),
new SqlParameter("@end", end)
};
DataTable da = DbHelperSql.GetTable(sql, CommandType.Text, pars);
List <Users_Model> list = null;
if (da.Rows.Count > 0)
{
list = new List <Users_Model>();
Users_Model userm = null;
foreach (DataRow row in da.Rows)
{
userm = new Users_Model();
loadEnitity(row, userm);
list.Add(userm);
}
}
return(list);
}
private void btn_Save_Click(object sender, EventArgs e)
{
usr = new Users_Model();
if (PerformValidation(gb_Main))
{
FRM2BL();
bool DialogDel = MessageBox.Show("Are you sure to EDIT this Data", "EDIT", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes;
if (DialogDel)
{
crud = new User_CRUD();
if (crud.Update(usr))
{
MessageBox.Show("Data UPDATED !!");
this.Close();
}
else
{
MessageBox.Show("Data FAILED UPDATED !!");
this.Close();
}
}
else
{
MessageBox.Show("Wrong Password !!");
}
((frm_user_employee)f).displayTable();
((frm_user_employee)f).Clear();
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//Reguster
//string name = context.Request["name"];
//User_Service userSer = new User_Service();
//if (userSer.FindUser(name)!=null)
//{
// context.Response.Write("此用户存在");
//}
//else
//{
// context.Response.Write("可用");
//}
//Login
string userName = context.Request["name"];
string userPwd = context.Request["pwd"];
User_Service userSer = new User_Service();
string msg = string.Empty;
Users_Model usermodel = null;
if (userSer.CheckLoginUser(userName, userPwd, out msg, out usermodel))
{
context.Session["usermodel"] = usermodel;
//ajax必须返回消息
context.Response.Write("yes:" + msg);
}
else
{
context.Response.Write("no:" + msg);
}
}
public int AddUser(Users_Model usermodel)
{
string sql = "insert into users values(@pwd,@nick,@sex,@age,@face,@friend,@name,@star,@blood)";
SqlParameter[] pars =
{
new SqlParameter("@pwd", SqlDbType.VarChar, 20),
new SqlParameter("@nick", SqlDbType.VarChar, 20),
new SqlParameter("@sex", SqlDbType.Char, 2),
new SqlParameter("@age", SqlDbType.Int),
new SqlParameter("@face", SqlDbType.Int),
new SqlParameter("@friend", SqlDbType.Int),
new SqlParameter("@name", SqlDbType.VarChar, 20),
new SqlParameter("@star", SqlDbType.Int),
new SqlParameter("@blood", SqlDbType.Int)
};
pars[0].Value = usermodel.LoginPwd;
pars[1].Value = usermodel.NickName;
pars[2].Value = usermodel.Sex;
pars[3].Value = usermodel.Age;
pars[4].Value = usermodel.FaceId;
pars[5].Value = usermodel.Friend;
pars[6].Value = usermodel.Name;
pars[7].Value = usermodel.StarId;
pars[8].Value = usermodel.BloodId;
return(DbHelperSql.ExecuteNonQuery(sql, CommandType.Text, pars));
}
protected void btnSaveUser_Click(object sender, EventArgs e)
{
if (txtPassword1.Text == txtPassword2.Text)
{
Users_Model mdlUsers = new Users_Model();
mdlUsers.User_Name = txtUserName.Text.Trim();
mdlUsers.User_Email = txtUserEmail.Text.Trim();
mdlUsers.User_Domain = txtUserDomain.Text.Trim();
mdlUsers.User_Password = WSICryptography.Encrypt(txtPassword1.Text.Trim());
mdlUsers.User_Access = ddUserAccess.SelectedValue;
if (Session["userMode"].ToString() == "Save")
{
Users.Save(oCon, mdlUsers);
}
else if (Session["userMode"].ToString() == "Update")
{
mdlUsers.idUser = Convert.ToInt32(Session["idUser"].ToString());
Users.Update(oCon, mdlUsers);
}
clearUser();
getUserView();
}
}
/// <summary>
/// 对cookie进行校检
/// </summary>
private void CheckCookie()
{
if (Request.Cookies["ck1"] != null && Request.Cookies["ck2"] != null)
{
string userName = Request.Cookies["ck1"].Value;
string userPwd = Request.Cookies["ck2"].Value;
BLL.User_Service userService = new BLL.User_Service();
Users_Model usermodel = userService.FindUser(userName);
if (usermodel != null)
{
//判断用户数据库中存储的密码是否与cookie中存储的密码一致
if (userPwd == usermodel.LoginPwd)
{
//先赋值 才能跳转
Session["usermodel"] = usermodel;
//Response.Redirect("SessionSuc.aspx");
UserPwd = userPwd;
UserName = userName;
Checked = "checked";
//Request.Cookies["ck1"].Expires = DateTime.Now.AddDays(-1);
//Request.Cookies["ck2"].Expires = DateTime.Now.AddDays(-1);
}
}
//如果Cookie中是有值的，但是Cookie存储的用户名或密码不正确，表示用户名和密码被篡改了，那么只能继续出现登录页面。那么该 cOOKIE也没有必要存在了。
Response.Cookies["ck1"].Expires = DateTime.Now.AddDays(-1);
Response.Cookies["ck2"].Expires = DateTime.Now.AddDays(-1);
}
}
public int UpdateUser(Users_Model usermodel)
{
string sql = "update users set loginpwd=@pwd,NickName=@nick,sex=@sex,age=@age,faceid=@face,FriendShipPolicyId=@friend,Name=@name,StarId=@star,BloodTypeId=@blood where id=@id";
SqlParameter[] pars =
{
new SqlParameter("@pwd", SqlDbType.VarChar, 20),
new SqlParameter("@nick", SqlDbType.VarChar, 20),
new SqlParameter("@sex", SqlDbType.Char, 2),
new SqlParameter("@age", SqlDbType.Int),
new SqlParameter("@face", SqlDbType.Int),
new SqlParameter("@friend", SqlDbType.Int),
new SqlParameter("@name", SqlDbType.VarChar, 20),
new SqlParameter("@star", SqlDbType.Int),
new SqlParameter("@blood", SqlDbType.Int),
new SqlParameter("@id", SqlDbType.Int)
};
pars[0].Value = usermodel.LoginPwd;
pars[1].Value = usermodel.NickName;
pars[2].Value = usermodel.Sex;
pars[3].Value = usermodel.Age;
pars[4].Value = usermodel.FaceId;
pars[5].Value = usermodel.Friend;
pars[6].Value = usermodel.Name;
pars[7].Value = usermodel.StarId;
pars[8].Value = usermodel.BloodId;
pars[9].Value = usermodel.Id;
return(DbHelperSql.ExecuteNonQuery(sql, CommandType.Text, pars));
}
/// <summary>
/// 1、用户登陆
/// </summary>
/// <param name="UName"></param>
/// <returns></returns>
public Users_Model Users_Login(string UName)
{
Users_Model obj = null;
//采用数组存储参数
SqlParameter[] ter = new SqlParameter[]
{
new SqlParameter("@UName", UName)
};
using (SqlDataReader dr = SqlHelper.ExecuteReader("Users_Login", ter))
{
if (dr.Read())//如果没有从数据库中读取数据那么说明该用户不存在
{
obj = new Users_Model()
{
UserID = (int)dr["UserID"], //用户ID
UName = dr["UName"].ToString(), //用户唯一标识
Pwd = dr["Pwd"].ToString(), //密 码
RegisTime = dr["RegisTime"].ToString(), //注册时间
LastTime = dr["LastTime"].ToString(), //最后一次登陆时间
IsVaild = (bool)dr["IsVaild"], //是否有效
};
}
}
return(obj);
}
/// <summary>
///展示要修改的数据
/// </summary>
private void ShowEdit()
{
int id;
if (int.TryParse(Request.QueryString["id"], out id))
{
Users_Model usermodel = userservice.FindUser(id);
UserModel = usermodel;
}
}
private void BL2FRM()
{
usr = new Users_Model();
txt_Nama.Text = usr._Name;
txt_Password.Text = usr._Password;
txt_Status.Text = usr._Status;
txt_Sex.Text = usr._Sex;
dtp_BirthDate.Value = usr._BirthDate;
rtb_Address.Text = usr._Address;
}
private void FRM2BL()
{
usr = new Users_Model();
usr._Name = txt_Nama.Text;
usr._Password = txt_Password.Text;
usr._Status = txt_Status.Text;
usr._Sex = txt_Sex.Text;
usr._BirthDate = dtp_BirthDate.Value;
usr._Address = rtb_Address.Text;
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
int id = Convert.ToInt32(context.Request["id"]);
BLL.User_Service userSer = new BLL.User_Service();
Users_Model usermodel = userSer.FindUser(id);
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
context.Response.Write(js.Serialize(usermodel));
}
public void LoadForm()
{
usr = new Users_Model();
txt_Nama.Text = ((frm_user_employee)f).txt_Nama.Text;
txt_Password.Text = ((frm_user_employee)f).txt_Password.Text;
txt_Status.Text = ((frm_user_employee)f).txt_Status.Text;
txt_Sex.Text = ((frm_user_employee)f).txt_Sex.Text;
dtp_BirthDate.Text = ((frm_user_employee)f).dtp_BirthDate.Text;
rtb_Address.Text = ((frm_user_employee)f).rtb_Address.Text;
cb_IsEmployee.Checked = ((frm_user_employee)f).cb_IsEmployee.Checked;
cb_IsEmployee.Text = "ISEmployee";
}
public Users_Model FindUser(int id)
{
string sql = "select * from users where id=@id";
Users_Model usermodel = null;
DataTable da = DbHelperSql.GetTable(sql, CommandType.Text, new SqlParameter("@id", id));
if (da.Rows.Count > 0)
{
usermodel = new Users_Model();
loadEnitity(da.Rows[0], usermodel);
}
return(usermodel);
}
private void loadEnitity(DataRow row, Users_Model userModel)
{
userModel.Id = Convert.ToInt32(row["Id"]);
userModel.LoginPwd = row["LoginPwd"] != DBNull.Value ? row["LoginPwd"].ToString() : string.Empty;
userModel.NickName = row["NickName"] != DBNull.Value ? row["NickName"].ToString() : string.Empty;
userModel.Sex = row["Sex"] != DBNull.Value ? row["Sex"].ToString() : string.Empty;
userModel.Age = Convert.ToInt32(row["Age"]);
userModel.FaceId = Convert.ToInt32(row["FaceId"]);
userModel.Friend = Convert.ToInt32(row["FriendShipPolicyId"]);
userModel.Name = row["Name"] != DBNull.Value ? row["Name"].ToString() : string.Empty;
userModel.StarId = Convert.ToInt32(row["StarId"]);
userModel.BloodId = Convert.ToInt32(row["BloodTypeId"]);
}
/// <summary>
/// 2、用户注册
/// </summary>
/// <param name="us"></param>
/// <returns></returns>
public bool Users_Register(Users_Model us)
{
if (Users_Login2(us.UName) != null)
{
return(false);//用户已经存在
}
//采用数组存储参数
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@UserName", us.UName),
new SqlParameter("@Pwd", us.Pwd)
};
return(SqlHelper.ExecuteNonQuery("Users_Register", param));
}
/// <summary>
/// 检验用户是否存在
/// </summary>
/// <param name="UName"></param>
/// <returns></returns>
public Users_Model Users_Login2(string UName)
{
Users_Model obj = null;
//采用数组存储参数
SqlParameter[] ter = new SqlParameter[]
{
new SqlParameter("@UName", UName)
};
using (SqlDataReader dr = SqlHelper.ExecuteReader("Users_Login", ter))
{
if (dr.Read())//如果没有从数据库中读取数据那么说明该用户不存在
{
obj = new Users_Model();
}
}
return(obj);
}
public bool SaveUserAccount(Users_Model users_Model)
{
using (var db_Context = new SalesTrackingSystemEntities())
{
using (DbContextTransaction db = db_Context.Database.BeginTransaction())
{
try
{
var UserData = new User()
{
UserID = GetNewUserId(),
UserProfileID = users_Model.UserProfileID,
FullName = users_Model.FullName,
PasswordHash = users_Model.PasswordHash,
Email = users_Model.Email,
MobileNo = users_Model.MobileNo,
ImageString = users_Model.ImageString,
UsersStatus = users_Model.UsersStatus,
DateCreated = DateTime.Now
};
db_Context.Users.Add(UserData);
db_Context.SaveChanges();
var userId = UserData.UserID;
Verification_Interface verification_ = new Verification_service();
var DataVarification = new Verification()
{
VerificationID = verification_.GetNewVerificationId(),
UserID = userId,
IsVerified = false,
DateCreated = DateTime.Now
};
db_Context.Verifications.Add(DataVarification);
db_Context.SaveChanges();
db.Commit();
return(true);
}
catch (DbEntityValidationException)
{
db.Rollback();
return(false);
}
}
}
}
private void FRM2BL()
{
usr = new Users_Model();
usr._Name = txt_Nama.Text;
usr._Password = txt_Password.Text;
usr._Status = txt_Status.Text;
usr._Sex = txt_Sex.Text;
usr._BirthDate = dtp_BirthDate.Value;
usr._Address = rtb_Address.Text;
if (cb_IsEmployee.Checked)
{
usr.IsEmployee = "1";
}
else
{
usr.IsEmployee = "0";
}
usr.UserId = ((frm_user_employee)f).id_user;
}
public List <Users_Model> GetUsers()
{
string sql = "select * from users";
DataTable da = DbHelperSql.GetTable(sql, CommandType.Text);
List <Users_Model> list = null;
if (da.Rows.Count > 0)
{
list = new List <Users_Model>();
Users_Model usermodel = new Users_Model();
foreach (DataRow row in da.Rows)
{
usermodel = new Users_Model();
loadEnitity(row, usermodel);
list.Add(usermodel);
}
}
return(list);
}
private void FRM2BL()
{
usr = new Users_Model();
usr._Name = txt_Nama.Text;
usr._Password = txt_Password.Text;
usr._Status = txt_Status.Text;
usr._Sex = txt_Sex.Text;
usr._BirthDate = dtp_BirthDate.Value;
usr._Address = rtb_Address.Text;
if (cb_IsEmployee.Checked)
{
usr.IsEmployee = "1";
}
else
{
usr.IsEmployee = "0";
}
id_user = dgv.SelectedRows[0].Cells["user_id"].Value.ToString();
usr.UserId = id_user;
}
/// <summary>
/// 判断用户的用户名密码是否正确
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="userPwd">密码</param>
/// <param name="msg">返回的信息</param>
/// <param name="usermodel">返回的登录用户的信息</param>
/// <returns></returns>
public bool CheckLoginUser(string userName, string userPwd, out string msg, out Users_Model usermodel)
{
usermodel = dao.FindUser(userName);
if (usermodel != null)
{
if (usermodel.LoginPwd == userPwd)
{
msg = "登陆成功";
return(true);
}
else
{
msg = "用户名或密码错误";
return(false);
}
}
else
{
msg = "此用户不存在";
return(false);
}
}
private void PostEditUser()
{
Users_Model usermodel = new Users_Model();
usermodel.LoginPwd = Request.Form["txtpwd"];
usermodel.NickName = Request.Form["txtnick"];
usermodel.Sex = Request.Form["txtsex"];
usermodel.Age = Convert.ToInt32(Request.Form["txtage"]);
usermodel.FaceId = Convert.ToInt32(Request.Form["txtface"]);
usermodel.Friend = Convert.ToInt32(Request.Form["txtfriend"]);
usermodel.Name = Request.Form["txtname"];
usermodel.StarId = Convert.ToInt32(Request.Form["txtstar"]);
usermodel.BloodId = Convert.ToInt32(Request.Form["txtblood"]);
usermodel.Id = Convert.ToInt32(Request.Form["id"]);
if (userservice.UpdateUser(usermodel))
{
Response.Redirect("Index.aspx");
}
else
{
Response.Redirect("Error.html");
}
}
private void CheckUser()
{
string userName = Request.Form["txtClientID"];
string userPwd = Request.Form["txtPassword"];
BLL.User_Service userService = new BLL.User_Service()
;
//提示信息
string msg = string.Empty;
Users_Model usermodel = null;
if (userService.CheckLoginUser(userName, userPwd, out msg, out usermodel))
{
//判断用户是否选择了自动登录
if (!string.IsNullOrEmpty(Request.Form["autoLogin"]))
{
HttpCookie cookie1 = new HttpCookie("ck1", userName);
HttpCookie cookie2 = new HttpCookie("ck2", userPwd);
//HttpCookie cookie = new HttpCookie("ck", Common.MD5Com.GetMd5String(userPwd));
cookie1.Expires = DateTime.Now.AddDays(3);
cookie2.Expires = DateTime.Now.AddDays(3);
Response.Cookies.Add(cookie1);
Response.Cookies.Add(cookie2);
}
Session["usermodel"] = usermodel;
Session.Timeout = 3;
Response.Redirect("SessionSuc.aspx");
}
else
{
ErrorMsg = msg;
}
}
public bool Insert(Users_Model usr)
{
bool result = false;
try
{
DBCon = new DBConnection();
sql = string.Format(@"INSERT INTO `cinema_simd`.`user`
(`Name`,
`Password`,
`Status`,
`Sex`,
`BirthDate`,
`Address`,
`IsEmployee`)
VALUES ('{0}',
'{1}',
'{2}',
'{3}',
'{4}',
'{5}',
'{6}');",
usr._Name,
usr._Password,
usr._Status,
usr._Sex,
usr._BirthDate.ToString("yyyy-MM-dd"),
usr._Address,
usr._IsEmployee);
DBCon.ConnectionOpen();
cmd = new MySqlCommand(sql, DBCon.Connection);
result = cmd.ExecuteNonQuery() == 1;
DBCon.ConnectionClose();
}
catch (Exception ex) { Console.WriteLine(ex); }
return(result);
}
public bool Update(Users_Model usr)
{
bool result = false;
try
{
DBCon = new DBConnection();
sql = string.Format(@"UPDATE `user`
SET
`name`='{0}',
`password` = '{1}',
`status` = '{2}',
`sex` = '{3}',
`birthDate` = '{4}',
`Address` = '{5}',
`IsEmployee` = '{6}'
WHERE `user_Id` = '{7}';",
usr._Name,
usr._Password,
usr._Status,
usr._Sex,
usr._BirthDate.ToString("yyyy-MM-dd"),
usr.Address,
usr.IsEmployee,
usr.UserId);
DBCon.ConnectionOpen();
cmd = new MySqlCommand(sql, DBCon.Connection);
result = cmd.ExecuteNonQuery() == 1;
DBCon.ConnectionClose();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(result);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
Users_Model usermodel = new Users_Model();
usermodel.LoginPwd = context.Request["txtpwd"];
usermodel.NickName = context.Request["txtnick"];
usermodel.Sex = context.Request["txtsex"];
usermodel.Age = Convert.ToInt32(context.Request["txtage"]);
usermodel.FaceId = Convert.ToInt32(context.Request["txtface"]);
usermodel.Friend = Convert.ToInt32(context.Request["txtfriend"]);
usermodel.Name = context.Request["txtname"];
usermodel.StarId = Convert.ToInt32(context.Request["txtstar"]);
usermodel.BloodId = Convert.ToInt32(context.Request["txtblood"]);
BLL.User_Service userSer = new BLL.User_Service();
if (userSer.AddUser(usermodel))
{
context.Response.Write("yes");
}
else
{
context.Response.Write("no");
}
}
