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);
}
