public static void Create(USERS_DTO user)
{
using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities())
{
USERS_TBL newUser = ctx.USERS_TBL.Where(u => u.userId == user.userId || u.userName == user.userName).FirstOrDefault();
if (newUser == null)
{
ctx.USERS_TBL.Add(new USERS_TBL()
{
firstName = user.firstName,
lastName = user.lastName,
userName = user.userName,
password = user.password,
hmoId = user.hmoId,
mail = user.mail,
telephone = user.telephone,
adress = user.adress,
tz = user.tz,
requestForm = user.requestForm,
isActive = true,
isConfirm = false
});
ctx.SaveChanges();
}
else
{
throw new Exception("is exsist");
}
}
}
//read user by hmo:
public static HMO_TBL ReadUserByHmo(USERS_TBL user)
{
using (HMO_PROGECTEntities ctx = new HMO_PROGECTEntities())
{
HMO_TBL hmo = ctx.HMO_TBL.Where(u => u.hmoId == user.hmoId).FirstOrDefault();
return(hmo);
}
}
public static void DeleteClerk(string password)
{
use = db.USERS_TBL.Where(g => g.password == password).FirstOrDefault();
if (use != null)
{
db.USERS_TBL.Remove(db.USERS_TBL.Find(use));
db.SaveChanges();
}
}
public static void forgetPassword(string mail)
{
// -----------------
Random rand = new Random();
use = db.USERS_TBL.Where(g => g.mail == mail).FirstOrDefault();
if (use != null)
{
db.USERS_TBL.Find(use).password = rand.ToString();
}
//---------------------
}
public static string Login(string name, string password)
{
use = db.USERS_TBL.Where(g => g.userName == name && g.password == password).FirstOrDefault();
if (use != null)
{
if (use.isAdmin == true)
{
return("manager");
}
return("clerk");
}
return(null);
}
public int addClerk(string userName, string tz, string telephone, string mail, string adress)
{
use = db.USERS_TBL.Where(g => g.tz == tz).FirstOrDefault();
if (use == null)
{
db.USERS_TBL.Add(new USERS_TBL()
{
userName = userName, adress = adress, kind = 2, mail = mail, telephone = telephone, tz = tz
});
db.SaveChanges();
return(0);
}
return(1);
}
public string Login(string tz, string name)
{
use = db.USERS_TBL.Where(g => g.tz == tz).FirstOrDefault();
if (use != null && use.kind == 1)
{
//return use.userName;
return("manager");
}
else if (use != null && use.kind == 2)
{
return("clerk");
}
else
{
return(null);
}
}
public static USERS_DTO CastToDTO(USERS_TBL a)
{
return(new USERS_DTO
{
userName = a.userName,
adress = a.adress,
//hmoId = a.hmoId,
isAdmin = a.isAdmin,
mail = a.mail,
password = a.password,
telephone = a.telephone,
tz = a.tz,
lastName = a.lastName,
firstName = a.firstName,
hmoId = (int)a.hmoId,
userId = a.userId,
isConfirm = a.isConfirm,
requestForm = a.requestForm,
isActive = a.isActive
});
}
