public int UpdateUser(CoreUser user) { User userRecord = db.Users.Where(p => p.Id == user.id).FirstOrDefault(); if (userRecord != null) { userRecord.Name = user.Name; userRecord.Email = user.Email; if (user.Password != null) { userRecord.Password = user.Password; } if (user.UserName != null) { userRecord.UserName = user.UserName; } userRecord.RoleId = user.RoleId; //userRecord.Roles = db.Roles.Where(p => p.Id == user.RoleId).ToList(); db.SaveChanges(); return(user.id); } else { return(0); } }
public CoreUser GetUserById(int id) { var userData = db.Users.Where(p => p.Id == id).FirstOrDefault(); CoreUser coreUserMap = new CoreUser(); coreUserMap.Email = userData.Email; coreUserMap.Name = userData.Name; coreUserMap.UserName = userData.UserName; coreUserMap.RoleId = userData.RoleId; return(coreUserMap); }
public string CreateUser(CoreUser model) { try { var isEmailExist = db.Users.Where(p => p.Email == model.Email).FirstOrDefault(); var result = ""; if (isEmailExist != null) { result = @"{ 'Status': 'exist', 'UserId':'','RoleId':''}"; return(result); } User user = new User(); user.Title = model.Title; user.Name = model.Name; user.Email = model.Email; user.UserName = model.UserName; user.Password = model.Password; user.Telephone = model.Telephone; user.MobileNumber = model.MobileNumber; user.Country = db.Countries.Where(c => c.Id == model.CountryIdQual).FirstOrDefault(); user.Country1 = db.Countries.Where(c => c.Id == model.CountryIdResd).FirstOrDefault(); user.QualfiedDate = model.QualfiedDate; user.JobLocation = db.Countries.Where(c => c.Id == model.JobLocation).Select(c => c.Id).FirstOrDefault(); user.ExperienceIn1 = model.ExperienceIn1; user.ExperienceIn2 = model.ExperienceIn2; user.CreatedByUserId = null; user.CreatedOnDatetime = DateTime.Now; user.UpdatedByUserId = null; user.IsActive = true; user.UpdatedOnDatetime = DateTime.Now; //user.IsActive = false; user.RoleId = 4; List <Speciality> _listSpeciality = new List <Speciality>(); _listSpeciality.Add(db.Specialities.Where(c => c.Id == model.Speciality1).FirstOrDefault()); _listSpeciality.Add(db.Specialities.Where(c => c.Id == model.Speciality2).FirstOrDefault()); _listSpeciality.Add(db.Specialities.Where(c => c.Id == model.Speciality3).FirstOrDefault()); user.Specialities = _listSpeciality; var path = ""; if (model.File != null && model.File.ContentLength > 0) { var filename = Guid.NewGuid() + Path.GetFileName(model.File.FileName); path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory + "UserDocuments\\", filename); var filetype = Path.GetExtension(model.File.FileName); List <UserDocument> listUserDoc = new List <UserDocument>(); UserDocument userDoc = new UserDocument(); userDoc.Name = filename; userDoc.Path = path; userDoc.DocType = filetype; userDoc.CreatedDate = DateTime.Now; userDoc.UpdatedDate = DateTime.Now; listUserDoc.Add(userDoc); user.UserDocuments = listUserDoc; } db.Users.Add(user); db.SaveChanges(); if (model.File != null) { model.File.SaveAs(path); } //generate token and save in database string possibles = "abcdefghijkmnopqrstuvwxyzABCDEFGHJKLMNOPQRSTUVWXYZ0123456789"; char[] code = new char[4]; Random rd = new Random(); for (int i = 0; i < 4; i++) { code[i] = possibles[rd.Next(0, possibles.Length)]; } string codeString = new string(code); VerificationToken token = new VerificationToken(); token.Token = codeString; token.UserId = user.Id; token.GeneratedDateTime = DateTime.Now; //db.VerificationTokens.Add(token); //db.SaveChanges(); HttpContext.Current.Session["UserEmailId"] = user.Email; result = @"{ 'Status': '200', 'UserId':'" + user.Id + "','RoleId':'" + user.RoleId + "'}"; return(result); //send mail for verification //SendNotification notify = new SendNotification(); //string mailSubject = "Account verification"; //bool mailStatus = notify.SendMailAccountVerification(model.Email, model.Name, user.Id, codeString, mailSubject); //if (mailStatus) //{ // return "success"; //} //else //{ // DeleteUser(user.Id); // return "mail failed"; //} } catch (Exception ex) { return(ex.Message.ToString());; } }