public bool InsertNewEmployeeWithDetail(Models.Employee e, string email, string password, string name, string gender, string dob, string phonenumber, string address, string image)
{
try
{
Employee employee = new Employee();
employee.hire_date = e.hire_date; //Convert.ToDateTime(hire_date);
employee.base_salary = e.base_salary; // Convert.ToDecimal(base_salary);
employee.role = e.role; //role;
Store_User user = new Store_User();
user.address = address;
user.dob = Convert.ToDateTime(dob);
user.email = email;
user.name = name;
user.password = password;
user.gender = 2;//Convert.ToInt32(gender);
user.image = image;
user.phonenumber = phonenumber;
EM.ThemEmployeeWithDeitailUser(employee, user);
return(true);
}
catch
{
return(false);
}
}
//mục đích củaThemStore_UserKoTang là ko tự động tăng,
//nhằm khi id đã dc xử lý trước r, vd như ThemEmployeeWithD bên EmployeeManager
public bool ThemStore_UserKoTang(Store_User Store_User)
{
db.Store_Users.InsertOnSubmit(Store_User);
db.SubmitChanges();
return(true);
}
public bool XoaStore_User(int maStore_User)
{
Store_User Store_User = db.Store_Users.Single(x => x.id == maStore_User);
db.Store_Users.DeleteOnSubmit(Store_User);
db.SubmitChanges();
return(true);
}
public string Update_UserNotParaments(Store_User user)
{
try
{
return(JsonConvert.SerializeObject(sm.CapNhatStore_UserModel(user)));
}
catch (Exception e)
{
return(e.ToString());
}
}
public bool ThemStore_User(Store_User store_User)
{
store_User.id = ListStore_Users().Count;
while (KiemTraTrungTonTaiUser(store_User.id))
{
store_User.id++;
}
db.Store_Users.InsertOnSubmit(store_User);
db.SubmitChanges();
return(true);
}
public Models.Store_User ThemStore_UserModel(Store_User store_User)
{
store_User.id = ListStore_Users().Count;
while (KiemTraTrungTonTaiUser(store_User.id))
{
store_User.id++;
}
db.Store_Users.InsertOnSubmit(store_User);
db.SubmitChanges();
return(new Models.Store_User(store_User.id, store_User.email, store_User.password, store_User.name,
store_User.gender, store_User.dob, store_User.phonenumber, store_User.address, store_User.image));
}
public bool ThemEmployeeWithDeitailUser(Employee nv, Store_User user)
{
nv.id = suMana.ListStore_Users().Count;
while (KiemTraTrungTonTaiUser(nv.id))
{
nv.id++;
}
db.Employees.InsertOnSubmit(nv);
db.SubmitChanges();
user.id = nv.id;
suMana.ThemStore_UserKoTang(user);
return(true);
}
public bool CapNhatStore_User(Store_User nv)
{
try
{
Store_User a = db.Store_Users.SingleOrDefault(x => x.id == nv.id);
a = nv;
db.SubmitChanges();
}
catch (Exception)
{
return(false);
}
return(true);
}
public bool InsertNewUserInfo(string email, string password, string name, int gender, DateTime dob, string phonenumber, string address, string image, DateTime created_at, DateTime updated_at)
{
Store_User Store_User = new Store_User();
Store_User.email = email;
Store_User.password = password;
Store_User.created_at = created_at;
Store_User.updated_at = updated_at;
Store_User.name = name;
Store_User.gender = gender;
Store_User.dob = dob;
Store_User.phonenumber = phonenumber;
Store_User.address = address;
return(SU.ThemStore_User(Store_User));
}
public Models.Store_User CapNhatStore_UserModel(Store_User item)
{
try
{
Store_User a = db.Store_Users.SingleOrDefault(x => x.id == item.id);
a = item;
db.SubmitChanges();
}
catch (Exception e)
{
return(null);
}
return(new Models.Store_User(item.id, item.email, item.password, item.name,
item.gender, item.dob, item.phonenumber, item.address, item.image));
}
public bool ThemEmployee(Employee nv)
{
nv.id = suMana.ListStore_Users().Count;
while (KiemTraTrungTonTaiUser(nv.id))
{
nv.id++;
}
db.Employees.InsertOnSubmit(nv);
db.SubmitChanges();
Store_User su = new Store_User();
su.id = nv.id;
suMana.ThemStore_UserKoTang(su);
return(true);
}
public bool AddUser(string email, string password, string name, int gender, DateTime dob, string phonenumber, string address, string image)
{
try
{
Store_User user = new Store_User();
user.email = email;
user.password = password;
user.name = name;
user.gender = gender;
user.dob = dob;
user.phonenumber = phonenumber;
user.address = address;
user.image = image;
return(sm.ThemStore_User(user));
}
catch
{
return(false);
}
}
