public void SaveUserData(user_data userParam, int personnalId) { using (UserDataRepository userRepo = new UserDataRepository()) { if (userRepo.Exists(userParam)) { try { userRepo.Update(userParam); userRepo.Save(); } catch (Exception ex) { Debug.WriteLine(ex.Message); } } else { try { userParam.personal_data_id = personnalId; userRepo.Insert(userParam); userRepo.Save(); Debug.WriteLine("userPresenter: insert kész"); } catch (Exception ex) { Debug.WriteLine(ex.Message); } } } }
public bool AddUser(UsersVM userVM) { if (isValidUser(userVM.email, userVM.user_name)) { user_data userToAdd = new user_data(); userToAdd.user_name = userVM.user_name; userToAdd.address = userVM.address; userToAdd.age = userVM.age; userToAdd.email = userVM.email; userToAdd.national_id = userVM.national_id; userToAdd.phone = userVM.phone; userToAdd.role = userVM.role; userToAdd.qualification_id = userVM.qualification_id; userToAdd.loginUserName = userVM.loginUserName; userToAdd.password = userVM.password; userToAdd.qualification_id = userVM.qualification_id; MCDB.user_data.Add(userToAdd); MCDB.SaveChanges(); return(true); } else { return(false); } }
public void Insert(user_data user) { if (db.user_data.Any(x => x.id == user.id)) { throw new Exception("Már létezik ilyen id!"); } db.user_data.Add(user); }
public user_data getUserByID(int id) { using (MCenterDBContext db = new MCenterDBContext()) { user_data user = db.user_data.Where(x => x.user_id == id).SingleOrDefault(); return(user); } }
public void DeleteUser(int id) { using (MCenterDBContext db = new MCenterDBContext()) { user_data deletedIns = getUserByID(id); // db.instructors.Remove(deletedIns); db.Entry(deletedIns).State = EntityState.Deleted; db.SaveChanges(); } }
public static user_data Createuser_data(string username, string email, string password, int type_id, string phone) { user_data user_data = new user_data(); user_data.username = username; user_data.email = email; user_data.password = password; user_data.type_id = type_id; user_data.phone = phone; return(user_data); }
public dataReturnMessage Vip(string vid) { dataReturnMessage result = new dataReturnMessage(); // 用户id不存在 var sUid = from m in dbContext.user_data where m.user_id == vid select m; if (sUid.FirstOrDefault() == null) { result.code = 0; result.message = "用户id不存在"; result.data = null; return(result); } // 用户不是vip var sVipId = from m in dbContext.vip_data where m.vip_id == vid select m; if (sVipId.FirstOrDefault() == null) { result.code = 0; result.message = "用户不是vip"; result.data = null; return(result); } vip_data vip = sVipId.First(); user_data user = sUid.First(); // 用户vip过期 DateTime nowTime = DateTime.Now; if (Convert.ToDateTime(vip.end_time) < nowTime) { result.code = 0; result.message = "vip已过期"; dbContext.vip_data.Remove(vip); dbContext.SaveChanges(); return(result); } // 查询成功 result.code = 1; result.message = "查询成功"; vipReturnData data = new vipReturnData { vip_id = vid, user_name = user.user_name, start_time = vip.begin_time, end_time = vip.end_time, vip_level = vip.vip_level }; result.data = data; return(result); }
public bool isValidUser(string email, string userName) { user_data user = MCDB.user_data.FirstOrDefault(x => x.email == email && x.user_name == userName); if (user != null) { return(true); } else { return(false); } }
public void Save(int id, string at) { BinaryFormatter bf = new BinaryFormatter(); FileStream file = File.Create(Application.persistentDataPath + "/playerData.dat"); user_data saveData = new user_data(); saveData.setAccessToken(at); saveData.setPlayerId(id); bf.Serialize(file, saveData); file.Close(); }
public void Update(user_data param) { var user = db.user_data.Find(param.id); if (user != null) { user.user_name = param.user_name; user.password = param.password; user.first_working_day = param.first_working_day; user.last_working_day = param.last_working_day; user.position_id = param.position_id; db.Entry(user).State = EntityState.Modified; } }
public ReturnMessage UidPut(dynamic _in) { ReturnMessage result = new ReturnMessage(); string inUid = _in.user_id; string inName = _in.user_name; // 用户id不存在 var sUid = from m in dbContext.user_data where m.user_id == inUid select m; if (sUid.FirstOrDefault() == null) { result.code = 0; result.message = "用户id不存在"; return(result); } // 用户昵称重复 var sName = from m in dbContext.user_data where m.user_name == inName select m; if (sName.FirstOrDefault() != null) { if (sName.First().user_id != inUid) { result.code = 0; result.message = "用户昵称重复"; return(result); } } // 修改成功 user_data newData = sUid.First(); newData.password = _in.password; newData.user_name = inName; newData.gender = _in.gender; newData.city = _in.city; dbContext.user_data.Update(newData); dbContext.SaveChanges(); result.code = 1; result.message = "修改成功"; return(result); }
public void UpdateUser(UsersVM userVm) { using (MCenterDBContext db = new MCenterDBContext()) { user_data updataedUser = getUserByID(userVm.user_id); updataedUser.user_name = userVm.user_name; updataedUser.age = userVm.age; updataedUser.email = userVm.email; updataedUser.national_id = userVm.national_id; updataedUser.address = userVm.address; updataedUser.phone = userVm.phone; updataedUser.qualification_id = userVm.qualification_id; updataedUser.loginUserName = userVm.loginUserName; updataedUser.password = userVm.password; db.Entry(updataedUser).State = EntityState.Modified; db.SaveChanges(); } }
public ReturnMessage register(dynamic _in) { ReturnMessage result = new ReturnMessage(); string inUid = _in.user_id; string inName = _in.user_name; var sId = from m in dbContext.user_data where m.user_id == inUid select m; // 有重复id if (sId.FirstOrDefault() != null) { result.code = 0; result.message = "用户id重复"; return(result); } var sName = from m in dbContext.user_data where m.user_name == inName select m; // 有重复name if (sName.FirstOrDefault() != null) { result.code = 0; result.message = "用户名重复"; return(result); } user_data newData = new user_data { user_id = _in.user_id, password = _in.password, user_name = _in.user_name, gender = _in.gender, city = _in.city }; dbContext.user_data.Add(newData); dbContext.SaveChanges(); result.code = 1; result.message = "注册成功"; return(result); }
public bool Exists(user_data user) { return(db.user_data.Any(x => x.id == user.id)); }
public bool ValidateData(personal_data personalParam, user_data user) { view.errorFirstName = null; view.errorLastName = null; view.errorMother = null; view.errorPhone = null; view.errorLocation = null; view.errorUserName = null; view.errorPassword = null; bool valid = true; if (string.IsNullOrEmpty(personalParam.first_name)) { view.errorFirstName = Resources.errorRequired; valid = false; } if (string.IsNullOrEmpty(personalParam.last_name)) { view.errorLastName = Resources.errorRequired; valid = false; } if (string.IsNullOrEmpty(personalParam.mother)) { view.errorMother = Resources.errorRequired; valid = false; } if (string.IsNullOrEmpty(personalParam.phone)) { view.errorPhone = Resources.errorRequired; valid = false; } if (string.IsNullOrEmpty(personalParam.location)) { view.errorLocation = Resources.errorRequired; valid = false; } if (string.IsNullOrEmpty(user.user_name)) { view.errorUserName = Resources.errorRequired; valid = false; } else { using (UserDataRepository userRepo = new UserDataRepository()) { if (user.id > 0)//Már létező user { var oldUser = userRepo.GetUserData(user.id); if (oldUser.user_name != user.user_name)//csak akkor kell ellenőrizni ha történt változás a userName ben { if (userRepo.UserNameExist(user.user_name)) { view.errorUserName = Resources.errorExist; valid = false; } } } else// Új user { if (userRepo.UserNameExist(user.user_name)) { view.errorUserName = Resources.errorExist; valid = false; } } } } if (string.IsNullOrEmpty(user.password)) { view.errorPassword = Resources.errorRequired; valid = false; } return(valid); }
public void AddTouser_data(user_data user_data) { base.AddObject("user_data", user_data); }