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