public static void SetParameters(tblUser U, string account) { UserName = U.FirstName+" "+U.Surname; UserID = U.ID; Roles_GroupID = U.RoleGroupID; Email = U.Email; Account = account; AccountID = U.AccountID; }
protected void btnRegister_Click(object sender, EventArgs e) { tblUser user = new tblUser(); user.fldUsername = txtUser.Text.Trim(); user.fldPassword = txtPassword.Text.Trim(); user.fldRole = txtRole.Text.Trim().ToLower(); if (!DBAccess.DoesUsernameAlreadyExists(user.fldUsername)) { DBAccess.CreateUser(user); lblInfo.Text = "User Created Successfully!"; } }
public void TestMethod1() { try { var test = new SampleArchitecture.NativeDAL.RNDEntities(); ////var value = test.User.Add(new tblUser { Id = 5, Name = "hello", Password = "******" }); var tlbuser = new tblUser { ID = 24, Name = "hello24", Password = "******" }; var value = test.User.Add(tlbuser); } catch (Exception) { } }
protected void btnSignUp_Click(object sender, EventArgs e) { dbDataContext db = new dbDataContext(); tblUser user = new tblUser(); user.password = txtpass1.Text; user.pkeid = txteid.Text; user.status = "unBlock"; user.uname = txtuname.Text; db.tblUsers.InsertOnSubmit(user); db.SubmitChanges(); Response.Redirect("SignIn.aspx"); }
internal bool SaveStripeDetails(StripeModel objReq) { using (var db = new WizzDataContext()) { tblUser userData = new tblUser(); userData = db.tblUsers.Where(x => x.pkUserId == Convert.ToInt64(objReq.userId)).FirstOrDefault(); userData.stripeId = objReq.stripeAcKey; db.SubmitChanges(); return true; } }
internal string adminLogin(AdminModel objReq) { string i = "0"; try { using (var db = new WizzDataContext()) { tblUser admin = new tblUser(); if (objReq != null) { admin = db.tblUsers.Where(e => e.userEmail == objReq.email && e.registerType == 1).FirstOrDefault(); if (admin != null) { if (objReq.password.ToLower() == admin.password) { i = "loggedIn"; CurrentUser user = new CurrentUser() { PkUserId = Convert.ToString(admin.pkUserId), Email = admin.userEmail, isActive = Convert.ToString(admin.isActive), usertype = Convert.ToString(admin.registerType), }; string json = JsonConvert.SerializeObject(user); FormsAuthentication.SetAuthCookie(json, true); } else { i = "Invalid password !"; } } else { i = "The Email Id is not registered with us !"; } } return i; } } catch (Exception ex) { i = ex.ToString(); return i; } }
internal RespIsTeacherRequest isTeacher(IsTeacherRequest objReq) { var isTutor = Convert.ToBoolean(objReq.isTutor); RespIsTeacherRequest response = new RespIsTeacherRequest(); response.isAlreadySignup = "False"; using (var db = new WizzDataContext()) { tblUser tUser = new tblUser(); int fkuserid = Convert.ToInt32(objReq.userId); tUser = db.tblUsers.Where(x => x.pkUserId == fkuserid).FirstOrDefault(); if (tUser == null) response.isTutor="False"; // return false; else { var tutor = db.tblTutorProfiles.Where(t => t.fkUserId == fkuserid).FirstOrDefault(); //check already signup or not if (tutor==null) { response.isAlreadySignup = "False"; } else { response.isAlreadySignup = "True"; } if (tutor == null && objReq.isTutor=="True") { response.isAlreadySignup = "False"; } else { response.isTutor = isTutor.ToString(); tUser.isTeacher = isTutor; db.SubmitChanges(); } // return true; } } return response; }
internal int ChangePassword(AdminChangePassword objReq) { using (var db = new WizzDataContext()) { tblUser tUser = new tblUser(); CurrentUser cu = new CurrentUser(); tUser = db.tblUsers.Where(x => x.pkUserId == Convert.ToInt32(cu.PkUserId)).FirstOrDefault(); if (tUser.password != objReq.oldPassword) return 0; else { tUser.password = objReq.newPassword.Trim(); db.SubmitChanges(); return 1; } } }
public int AddNew(LoginUser loginUser) { if (null != loginUser) { using (var entities = new atmEntities()) { // check existing var exist = (from a in entities.tblUsers where a.LoginId == loginUser.LoginId select a).SingleOrDefault(); if (null != exist) { loginUser.UserId = exist.UserId; return Update(loginUser); } var u = new tblUser { UserName = loginUser.UserName, AlternativeEmail = loginUser.AlternativeEmail, ApplicantId = loginUser.ApplicantId, Email = loginUser.Email, FullName = loginUser.FullName.ToUpper(), Password = loginUser.Password, Salt = loginUser.Salt, LoginId = loginUser.LoginId, FirstTime = loginUser.FirstTime, IsLocked = loginUser.IsLocked, LastLoginDt = loginUser.LastLoginDt, LastLoginDt2 = loginUser.LastLoginDt2, ServiceCd = loginUser.ServiceCd, CreatedBy = loginUser.CreatedBy, CreatedDt = DateTime.Now, ModifiedBy = loginUser.ModifiedBy, ModifiedDt = loginUser.ModifiedDt }; entities.tblUsers.Add(u); if (entities.SaveChanges() != 0) return u.UserId; } } return 0; }
private void deleteUserBtn_Click(object sender, EventArgs e) { var newConnection = new dbContextDataContext(); var currentUser = newConnection.tblUsers.Where(od => od.UniqueID == myUser.UniqueID).SingleOrDefault(); if (currentUser != null) { newConnection.tblUsers.DeleteOnSubmit(currentUser); newConnection.SubmitChanges(); userLookUp.Properties.DataSource = newConnection.tblUsers; myUser = new tblUser(); updateForm(); userLookUp.EditValue = null; } else { myUser = new tblUser(); updateForm(); userLookUp.EditValue = null; } }
public static int CreateUser(tblUser employee) { int result = 0; using (SqlConnection con =DBConfig.GetConnection()) { //con.Open(); string SQL = "sp_insert_User"; SqlCommand CMD = new SqlCommand(SQL, con); string password = Encryption(employee.fldPassword); CMD.CommandType = CommandType.StoredProcedure; CMD.Parameters.AddWithValue("@fldUsername", employee.fldUsername); CMD.Parameters.AddWithValue("@fldPassword", password); CMD.Parameters.AddWithValue("@fldRole", employee.fldRole); result = CMD.ExecuteNonQuery(); CMD.Connection.Close(); CMD = null; return result; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Bindoffice(); BindRoles(); } if (!string.IsNullOrEmpty(Request["id"])) { string aan = Request["id"].ToString(); _user = Users.getUserByAAN(aan); if (_user == null) { Response.Redirect("~/admin/users.aspx"); Response.End(); } if (!Page.IsPostBack) { getData(); } } //userinformation.aspx }
/// <summary> /// Get all data about users posts from the database /// </summary> /// <returns>The list of all users posts</returns> public List <tblPost> GetAllUserPosts(tblUser user) { try { List <tblPost> list = new List <tblPost>(); List <tblPost> allPosts = GetAllPosts().ToList(); for (int i = 0; i < allPosts.Count; i++) { if (allPosts[i].UserID == user.UserID) { list.Add(allPosts[i]); } } return(list.OrderByDescending(x => x.DateOfPost).ToList()); } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public void Insert() { try { using (MusicEntities dc = new MusicEntities()) { tblUser newuser = new tblUser(); Id = dc.tblUsers.Any() ? dc.tblUsers.Max(p => p.Id) + 1 : 1; UserPass = GetHash(); //Set the class details to the datarow Map(newuser); dc.tblUsers.Add(newuser); dc.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static int Update(User user) { using (BoBEntities bob = new BoBEntities()) { tblUser row = bob.tblUsers.FirstOrDefault(c => c.Id == user.Id); int results = 0; if (row != null) { row.FirstName = user.FirstName; row.LastName = user.LastName; row.Password = GetHash(user.Password); row.Username = user.Username; row.ImageSource = user.ImageSource; results = bob.SaveChanges(); } else { throw new Exception("Row was not found"); } return(results); } }
public void StudentDelete() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblStudent student = dc.tblStudents.Where(s => s.Id == this.StudentID).FirstOrDefault(); tblUser user = dc.tblUsers.Where(u => u.Id == student.UserId).FirstOrDefault(); if (student != null) { dc.tblStudents.Remove(student); dc.tblUsers.Remove(user); dc.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
protected void btnRegister_Click(object sender, EventArgs e) { using (var obj = new OntologyDataContext()) { if (OntologyHelper.Context.tblUsers.Count(a => a.UserName == txtUsername.Text) > 0) { lblError.Text = "User Name already exists"; } else { var user = new tblUser(); user.Date = DateTime.Now; user.MailId = txtMailId.Text; user.MobileNumber = Convert.ToInt64(txtMobileNumber.Text); user.Password = txtPassword.Text; user.UserName = txtUsername.Text; obj.tblUsers.InsertOnSubmit(user); obj.SubmitChanges(); Session["UserName"] = txtUsername.Text; Response.Redirect("Home.aspx"); } } }
// GET: Admin/tblRegistrations/Edit/5 public ActionResult Acept(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblRegistration tblRegistration = db.tblRegistrations.Find(id + ".com"); if (tblRegistration == null) { return(HttpNotFound()); } db.tblRegistrations.Remove(tblRegistration); db.SaveChanges(); tblUser user = new tblUser(); user.email = tblRegistration.email; user.password = tblRegistration.password; user.role = "User"; db.tblUsers.Add(user); db.SaveChanges(); return(RedirectToAction("Index")); }
public tblUser GetUsernamePassword(string username, string password) { try { using (CakeRecipesDBEntities context = new CakeRecipesDBEntities()) { string usernameFromDB = (from e in context.tblUsers where e.Username == username select e.Username).FirstOrDefault(); if (username == usernameFromDB) { tblUser user = (from e in context.tblUsers where e.Username.Equals(username) where e.UserPassword.Equals(password) select e).First(); return(user); } return(null); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public static bool IsUserDeferred(long userId, out DateTime?deferUntil) { deferUntil = DateTime.Now; DataClassesDataContext dataContext = new DataClassesDataContext(); var varUser = from userinfo in dataContext.tblUsers where userinfo.Id == userId select userinfo; tblUser oUser = varUser.FirstOrDefault(); if (oUser != null) { if (oUser.IsDefferred) { deferUntil = oUser.DebarUntil; return(true); } else { deferUntil = null; return(false); } } return(false); }
public static void ReactivateUser(long userId, bool removeBar, bool removeDefer) { DataClassesDataContext dataContext = new DataClassesDataContext(); var varUser = from userinfo in dataContext.tblUsers where userinfo.Id == userId select userinfo; tblUser oUser = varUser.FirstOrDefault(); if (oUser != null) { if (removeBar) { oUser.IsDebarred = false; oUser.DebarUntil = null; } if (removeDefer) { oUser.IsDefferred = false; oUser.DeferUntil = null; } //dataContext.tblUsers.DeleteOnSubmit(oUser); } dataContext.SubmitChanges(); }
// GET: ProductCategories/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblUser objSource = (tblUser)Session["UserDetails"]; tblProductCategory tblProductCategory = db.tblProductCategories.Find(id); if (tblProductCategory == null) { return(HttpNotFound()); } else { tblProductCategory.IsActive = false; tblProductCategory.UpdatedBy = objSource.Id; tblProductCategory.UpdatedOn = DateTime.Now; db.Entry(tblProductCategory).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Vote(int?id, int star) { HttpCookie member_cookie = Request.Cookies["member_id"]; tblUser user = db.tblUsers.Find(int.Parse(member_cookie.Value.ToString())); if (db.tblRates.FirstOrDefault(t => t.Rate_Post == id && t.Rate_User == user.User_ID) != null) { db.tblRates.FirstOrDefault(t => t.Rate_Post == id && t.Rate_User == user.User_ID).Rate_Star = star; } else { tblRate addItem = new tblRate() { Rate_User = user.User_ID, Rate_Star = star, Rate_Post = id, Rate_DateVote = DateTime.Now }; db.tblRates.Add(addItem); } db.SaveChanges(); return(RedirectToAction("Details", new { id })); }
public ActionResult Create([Bind(Include = "Username,Firstname,Lastname,Password,Administrator,Gesperrt")] tblUser tblUser) { if (Verify.IsUserAdmin(User.Identity.Name)) { try { if (ModelState.IsValid) { db.tblUser.Add(tblUser); db.SaveChanges(); return(RedirectToAction("Start")); } } catch { } return(View(tblUser)); } else { return(RedirectToAction("Index", "Home")); } }
/// <summary> /// Executes the Accept Frient Request /// </summary> private void AcceptExecute() { try { tblUser clickedUser = new tblUser() { FirstName = userData.GetUser(PandingUser.User1ID).FirstName, LastName = userData.GetUser(PandingUser.User1ID).LastName }; userData.AcceptFriendRequest(PandingUser); FriendList = userData.GetAllFriends(LoggedInUser.CurrentUser).ToList(); PendingList = userData.GetAllPandingUsers(LoggedInUser.CurrentUser).ToList(); InfoLabel = $"Accepted {clickedUser.FirstName} {clickedUser.LastName} user friend request."; InfoLabelBG = "#FF8BC34A"; SnackPendingInfo(); } catch (Exception ex) { Xceed.Wpf.Toolkit.MessageBox.Show("Cannot accept friend request right now." + ex); } }
public List <tblUser> GetFriends(tblUser user) { try { using (SocialNetworkDbEntities context = new SocialNetworkDbEntities()) { tblUser userInDb = (from x in context.tblUsers where x.UserID == user.UserID select x).First(); List <tblUser> list = new List <tblUser>(); list = userInDb.tblUsers1.ToList(); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
internal int ChangePassword(ChangePasswordModel objReq) { using (var db = new WizzDataContext()) { tblUser tUser = new tblUser(); int fkuserid = Convert.ToInt32(objReq.userId); tUser = db.tblUsers.Where(x => x.pkUserId == fkuserid).FirstOrDefault(); if (tUser == null) return 0; else if (tUser.isActive == false || tUser.isDelete == true) return 2; else if (tUser.password != objReq.oldPassword) return 3; else { tUser.password = objReq.Password.Trim(); db.SubmitChanges(); return 1; } } }
public bool AddSong(tblUser user, vwSong song) { try { using (DAN_LEntities context = new DAN_LEntities()) { tblSong newSong = new tblSong(); newSong.SongName = song.SongName; newSong.Author = song.Author; newSong.Duration = song.Duration; newSong.UserID = user.UserID; context.tblSongs.Add(newSong); context.SaveChanges(); song.SongID = newSong.SongID; return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }
public ActionResult Registration(RegistrationViewModel uv) { using (OnlineVotingSystemEntities db = new OnlineVotingSystemEntities()) { tblUser tbl = db.tblUsers.Where(u => u.UserName == uv.UserName || u.Email == uv.Email).FirstOrDefault(); if (tbl != null) { return(Json(new { success = false, message = "User Already Register" }, JsonRequestBehavior.AllowGet)); } else { tblUser tb = new tblUser(); tb.UserName = uv.UserName; tb.Password = OnlineVotingSystemForCollege.Models.EncryptPassword.textToEncrypt(uv.Password); tb.Fullname = uv.FullName; tb.Email = uv.Email; tb.EmailVerification = false; tb.ActivationCode = Guid.NewGuid(); db.tblUsers.Add(tb); db.SaveChanges(); tblUserRole ud = new tblUserRole(); ud.UserId = tb.UserId; ud.RoleId = 2; db.tblUserRoles.Add(ud); db.SaveChanges(); tblIdRequest tbid = new tblIdRequest(); tbid.UserEmail = tb.Email; tbid.FullName = tb.Fullname; tbid.UserId = tb.UserId; db.tblIdRequests.Add(tbid); db.SaveChanges(); return(Json(new { success = true, message = "Registration Completed . A Email would be send to your email" + tb.Email + "If You are a Valid User" }, JsonRequestBehavior.AllowGet)); } } }
private bool IsUseDefaultPassword() { _newUserInfo = new tblUser(); _newUserInfo.Username = UIPViewModel.UserNameText; _newUserInfo.IsAdmin = false; _newUserInfo.IsActive = true; _newUserInfo.FullName = UIPViewModel.FullNameText; _newUserInfo.Address = UIPViewModel.AdressText; _newUserInfo.Link = UIPViewModel.LinkText; _newUserInfo.Phone = UIPViewModel.PhoneText; _newUserInfo.Job = UIPViewModel.JobText; _newUserInfo.Email = UIPViewModel.EmailText; if (String.IsNullOrEmpty(UIPViewModel?.NewPassword)) { var queryRes = App.Current.ShowApplicationMessageBox("Trường mật khẩu bị bỏ trống, bạn muốn dùng mật khẩu mặc định là \"abc@13579\"?", HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.YesNo, HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Question, OwnerWindow.MainScreen, "Thông báo!"); if (queryRes == HPSolutionCCDevPackage.netFramework.AnubisMessgaeResult.ResultYes) { _newUserInfo.Password = "******"; return(true); } else { return(false); } } else { _newUserInfo.Password = UIPViewModel.NewPassword; } return(true); }
public ActionResult Edit(tblUser tbluser, int id, FormCollection collection) { if (ModelState.IsValid) { db.Entry(tbluser).State = EntityState.Modified; var user = db.tblUsers.First(p => p.id == id); string pass = tbluser.Password; if (pass == user.Password) { tbluser.Password = EncryptandDecrypt.Encrypt(tbluser.Password); } else { tbluser.Password = EncryptandDecrypt.Encrypt(tbluser.Password); } tbluser.UserName = user.UserName; tbluser.DateCreate = DateTime.Now; string idUser = Request.Cookies["Username"].Values["UserID"]; tbluser.idUser = int.Parse(idUser); db.SaveChanges(); #region [Updatehistory] Updatehistoty.UpdateHistory("Edit User", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString()); #endregion if (collection["btnSave"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa tài khoản thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/Users/Index")); } if (collection["btnSaveCreate"] != null) { Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm tài khoản thành công, mời bạn thêm tài khoản mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>"; return(Redirect("/Users/Create")); } } return(View(tbluser)); }
public bool EmployerLoadUserById(Guid userId) { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblEmployer employer = dc.tblEmployers.Where(e => e.UserId == userId).FirstOrDefault(); tblUser user = dc.tblUsers.Where(u => u.Id == employer.UserId).FirstOrDefault(); if (employer != null & user != null) { this.EmployerId = employer.Id; this.RepresentativeFirstName = employer.RepresentativeFirstName; this.RepresentativeLastName = employer.RepresentativeLastName; this.Phone = employer.Phone; this.Email = employer.Email; this.OrganizationName = employer.OrganizationName; this.Industry = employer.Industry; this.Password = user.Password; this.UserName = user.UserName; this.UserId = employer.UserId; this.ProfilePicture = employer.ProfilePicture; return(true); } else { return(false); } } } catch (Exception ex) { throw ex; } }
public ActionResult SignUp(tblAccount account, tblUser usertbl) { var listacc = (from acc_check in data.tblAccounts where acc_check.userName == account.userName select acc_check).FirstOrDefault(); if (listacc == null) { using (data) { try { tblAccount acc = new tblAccount(); acc = account; data.tblAccounts.Add(acc); data.SaveChanges(); int idacc = data.tblAccounts.Max(id => id.id_acc); tblUser User = new tblUser(); User.id_acc = idacc; User.nickName = usertbl.nickName; data.tblUsers.Add(User); data.SaveChanges(); Session["account"] = acc; Session["nickName"] = usertbl.nickName; return(Json(new { Result = "True" })); } catch (Exception ex) { return(Json(new { Result = ex })); } } } else { return(Json(new { Result = "Tài khoản đã tồn tại" })); } return(View("Index_Login")); }
public static async Task <bool> UserLogin(string url) { tblUser tbluser = new tblUser(); bool result = false; var request = System.Net.WebRequest.Create(url) as HttpWebRequest; if (request != null) { request.Method = "GET"; request.ServicePoint.Expect100Continue = false; request.Timeout = 20000; request.ContentType = "application/json"; using (WebResponse response = await request.GetResponseAsync()) { using (Stream stream = response.GetResponseStream()) { string x = JsonObject.Load(stream).ToString(); JsonObject jObj = (JsonObject)JsonObject.Parse(x); JsonArray jArr = (JsonArray)jObj["result"]; foreach (var item in jArr) { tbluser.id = 1; tbluser.userid = Convert.ToString((int)item["id"]); tbluser.username = item ["username"]; tbluser.password = item ["password"]; tbluser.fname = item ["fname"]; tbluser.lname = item ["lname"]; tbluser.token = item ["token"]; tbluser.status = "1"; GlobalVariables.GlobalUserid = Convert.ToString((int)item["id"]); ItemRepository.UserLogin(tbluser); } } } } return(result); }
/// <summary> /// Deletes user if the uderID exists /// </summary> /// <param name="userID">the user that is being deleted</param> public void DeleteUser(int userID) { List <tblUser> allUsers = GetAllUsers(); try { using (EmployeeDBEntities context = new EmployeeDBEntities()) { bool isUser = IsUserID(userID); if (isUser == true) { // find the user before removing them tblUser userToDelete = (from r in context.tblUsers where r.UserID == userID select r).First(); // Update the manager id for users where we deleted their manager for (int i = 0; i < allUsers.Count; i++) { if (userToDelete.UserID == allUsers[i].ManagerID) { int? managerID = allUsers[i].ManagerID; tblUser usersToEdit = (from ss in context.tblUsers where ss.ManagerID == managerID select ss).First(); usersToEdit.ManagerID = null; context.SaveChanges(); } } context.tblUsers.Remove(userToDelete); context.SaveChanges(); } } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public async Task <bool> ChangePwd(User user) { try { var repo = uow.UserRepo(); tblUser temp = null; foreach (var item in await repo.GetEntities()) { if (item.UserId == user.UserId) { temp = item; break; } } if (null == temp) { return(false); } temp.Salt = BCrypt.Net.BCrypt.GenerateSalt(); temp.Pwd = BCrypt.Net.BCrypt.HashPassword(user.Pwd.Trim(), temp.Salt); var GUID = Guid.NewGuid(); byte[] key = GUID.ToByteArray(); string token = Convert.ToBase64String(key.ToArray()); temp.Uid = GUID.ToString(); temp.Token = token; var filter = Builders <tblUser> .Filter.Eq(x => x.UserId, temp.UserId); return(await repo.UpdateEntities(filter, temp)); } catch (Exception) { return(false); throw; } }
public SavingResult ApproveUser(int UserID, bool Approval) { SavingResult res = new Models.Template.SavingResult(); using (dbUltraCoralEntities db = new DAL.dbUltraCoralEntities()) { tblUser SaveModel = db.tblUsers.Find(UserID); if (SaveModel == null) { res.ExecutionResult = eExecutionResult.ValidationError; res.ValidationError = "Invalid request. User has been deleted or moved."; return(res); } SaveModel.IsApproved = Approval; SaveModel.redt = DateTime.Now; SaveModel.reuid = (Common.Props.LoginUser != null? (int?)Common.Props.LoginUser.UserID : null); db.tblUsers.Attach(SaveModel); db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified; //-- try { db.SaveChanges(); res.PrimeKeyValue = SaveModel.UserID; res.ExecutionResult = eExecutionResult.CommitedSucessfuly; } catch (Exception ex) { ex = Common.Functions.FindFinalError(ex); res.ExecutionResult = eExecutionResult.ErrorWhileExecuting; res.Exception = ex; } } return(res); }
public bool EmployerInsert() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblUser user = new tblUser(); user.UserName = this.UserName; user.Password = this.Password; this.UserInsert(); tblUser userGetUserId = dc.tblUsers.Where(u => u.UserName == this.UserName).FirstOrDefault(); Guid guidUserId = userGetUserId.Id; tblEmployer employer = new tblEmployer(); employer.Id = Guid.NewGuid(); employer.RepresentativeFirstName = this.RepresentativeFirstName; employer.RepresentativeLastName = this.RepresentativeLastName; employer.Phone = this.Phone; employer.Email = this.Email; employer.OrganizationName = this.OrganizationName; employer.Industry = this.Industry; employer.UserId = guidUserId; employer.ProfilePicture = this.ProfilePicture; dc.tblEmployers.Add(employer); dc.SaveChanges(); return(true); } } catch (Exception ex) { throw ex; } }
public bool AddEmployee(vwEmployee addemployee) { try { using (DAN_LIIIEntities context = new DAN_LIIIEntities()) { tblUser user = new tblUser { DateOfBirth = addemployee.DateOfBirth, Email = addemployee.Email, NameSurname = addemployee.NameSurname, Pasword = addemployee.Pasword, Username = addemployee.Username }; context.tblUsers.Add(user); context.SaveChanges(); addemployee.UserID = user.UserID; tblEmployee employee = new tblEmployee { UserID = user.UserID, Citizenship = addemployee.Citizenship, Engagment = addemployee.Engagment, Gender = addemployee.Gender, HotelFloor = addemployee.HotelFloor, }; context.tblEmployees.Add(employee); context.SaveChanges(); addemployee.EmployeeID = employee.EmployeeID; return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }
/// <summary> /// /// </summary> /// <param name="model"></param> /// <returns></returns> public JsonResult SaveUser(UserViewModel model) { var result = false; try { if (model.userId > 0) { tblUser u = db.tblUsers.SingleOrDefault(x => x.isDeleted == false && x.userId == model.userId); u.userName = model.userName; u.userEmail = model.userEmail; u.userPassword = model.userPassword; u.status = model.status; u.designationId = model.designationId; db.SaveChanges(); result = true; } else { tblUser u = new tblUser(); u.userName = model.userName; u.userEmail = model.userEmail; u.userPassword = model.userPassword; u.status = model.status; u.isDeleted = false; u.designationId = model.designationId; db.tblUsers.Add(u); db.SaveChanges(); result = true; } } catch (Exception ex) { throw ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }
/// <summary> /// /// </summary> /// <param name="u"></param> /// <returns></returns> public bool UpdateUser(tbUser u) { tblUser u1 = new tblUser(); var info = (from u2 in db.tblUsers where u2.Id == u.Id select u2).FirstOrDefault(); tbUser c1 = GetUserDetail().Find(delegate(tbUser o) { return(u.EmailId.Trim().Equals(o.EmailId.Trim())); }); u1 = (tblUser)info; if (c1 != null && c1.Id != u.Id) { return(false); } else { if (info != null) { u1.Id = u.Id; u1.FirstName = u.FName; u1.LastName = u.LName; u1.PhoneNo = u.PhoneNumber; u1.CellPhoneNo = u.CellPhone; u1.EmailId = u.EmailId; //u1.CreatedDate = u.CreatedDate; u1.ModifyDate = DateTime.Now; u1.Password = u.Password; u1.Status = u.Status; } try { db.SubmitChanges(); return(true); } catch (Exception ex) { return(false); } } }
//------------------- END PASSWORD METHODS --------------------- #endregion User Password #region Password Recovery //------------------- START PASSWORD RECOVERY METHODS --------------------- // Generate ForgotPasswordKey public Guid ForgotPasswordKeyGen(string email) { try { using (PortfolioEntities dc = new PortfolioEntities()) { //Create a new row in the table for this forgotten password request tblUser user = dc.tblUsers.Where(u => u.Email == email).FirstOrDefault(); tblForgotPassword fp = new tblForgotPassword(); ForgotPasswordList previouslinks = new ForgotPasswordList(); // Clears previous reset links associated with user previouslinks.ClearForgottenPasswordsByUser(user); try { // Inserting new reset link in DB (User currently has none in DB here) fp.Id = Guid.NewGuid(); fp.UserId = dc.tblUsers.FirstOrDefault(u => u.Email == email).Id; // Expiration of reset link set to 2 hours from link creation fp.ExpirationDate = DateTime.Now.AddHours(2); dc.tblForgotPasswords.Add(fp); dc.SaveChanges(); return(fp.Id); } catch (Exception ex) { throw ex; } } } catch (Exception ex) { throw ex; } }
/// <summary> /// method for adding new user /// </summary> private void SaveExecute() { try { using (SocialNetworkEntities context = new SocialNetworkEntities()) { tblUser newUser = new tblUser(); newUser.FirstName = user.FirstName; newUser.LastName = user.LastName; newUser.BirthDate = user.BirthDate; newUser.Username = user.Username; if (PasswordValidation(user.UserPassword)) { newUser.UserPassword = user.UserPassword; } else { MessageBox.Show("Wrong password. Password must have at least 8 characters.\n(1 upper char, 1 lower char, 1 number and 1 special char)\nPlease try again."); } newUser.UserID = user.UserID; context.tblUsers.Add(newUser); context.SaveChanges(); MessageBox.Show("The user created successfully."); } signUp.Close(); } catch (Exception) { MessageBox.Show("Wrong inputs, please check your inputs or try again."); } }
public int CreateNewUser(LoginUser user, List<string> messages) { using (var entities = new atmEntities()) { var exist = (from a in entities.tblUsers where a.LoginId == user.LoginId select a).SingleOrDefault(); if (null != exist) return 0; var usr = new tblUser { AlternativeEmail = user.AlternativeEmail, ApplicantId = user.ApplicantId, CreatedBy = user.CreatedBy, CreatedDt = DateTime.Now, FullName = user.FullName, FirstTime = user.FirstTime, Email = user.Email, IsLocked = user.IsLocked, LastLoginDt = user.LastLoginDt, LoginId = user.LoginId, Password = ObjectBuilder.GetObject<ICryptorService>("CryptorService").ComputeHashInString(user.Salt, user.Password), Salt = user.Salt, ServiceCd = user.ServiceCd, UserName = user.UserName }; if (entities.SaveChanges() > 0) { messages.Add("Berjaya"); return usr.UserId; } messages.Add("Tidak Berjaya"); } return 0; }
partial void DeletetblUser(tblUser instance);
partial void UpdatetblUser(tblUser instance);
partial void InserttblUser(tblUser instance);
internal bool UserLogout(ReqLogOut objReq) { using (var db = new WizzDataContext()) { tblUser tUser = new tblUser(); int fkuserid = Convert.ToInt32(objReq.userId); tUser = db.tblUsers.Where(x => x.pkUserId == fkuserid).FirstOrDefault(); if (tUser == null) return false; else { tUser.deviceToken = null; db.SubmitChanges(); return true; } } }
//internal bool AcceptStudent(StudentTeacherMap objReq) //{ // // var isTutor = Convert.ToBoolean(objReq.userId); // using (var db = new WizzDataContext()) // { // if (objReq.isAccept.ToLower() == "true") // { // tblRequest reqStudent = new tblRequest(); // var studentList = db.tblRequestStudents.Where(x => x.isAccepted != true && x.isDelete == false && x.uniqueRequestId == objReq.uniqueRequestId && x.fkUserId == Convert.ToInt32(objReq.tutorId)).ToList(); // studentList.ForEach(a => { a.isAccepted = true; a.updatedDate = DateTime.UtcNow; }); // db.SubmitChanges();//update student request // var totalList = db.tblRequests.Where(x => x.isAccepted != true && x.uniqueRequestId == objReq.uniqueRequestId && x.fkStudentId==Convert.ToInt32(objReq.studentId)).ToList(); // var deleteList = totalList.Where(x => x.fkTutorId != Convert.ToInt32(objReq.tutorId)).ToList(); // //delete all tutors who recived the notiifcation except the tutor who is accepeting the notification // reqStudent = totalList.Where(x => x.fkTutorId == Convert.ToInt32(objReq.tutorId)).FirstOrDefault(); // db.tblRequests.DeleteAllOnSubmit(deleteList); // db.SubmitChanges(); // //accept the request // if (reqStudent == null)//if request is not exist // return false; // reqStudent.isAccepted = true; // reqStudent.updatedDate = DateTime.UtcNow; // var userData = db.tblUsers.Where(x => x.pkUserId == Convert.ToInt32(objReq.studentId)&& x.isTeacher==false).FirstOrDefault(); // var teacherData = db.tblUsers.Where(x => x.pkUserId == Convert.ToInt32(objReq.tutorId)).FirstOrDefault(); // if (userData!=null &&!string.IsNullOrEmpty(userData.deviceToken)) // { // // objPush.type = Convert.ToInt16(PushType.acceptRequest).ToString(); // PushData push = new PushData() // { // registration_ids = userData.deviceToken, // //push.data = CommonMethod.ObjectToJson(objPush); // message = PushMessages.FormatMessage(PushMessages.acceptRequest, teacherData.userName), // type = Convert.ToInt16(PushType.acceptRequest).ToString(), // badge = Convert.ToString(userData.badge) // }; // if (userData.deviceType == Convert.ToInt16(DeviceType.ios))//ios // { // SendPush objIOS = new SendPush(); // objIOS.ConnectToAPNS(push); // } // else if (userData.deviceType == Convert.ToInt16(DeviceType.android))//android // { // Android objAndroid = new Android(); // objAndroid.send(push); // } // } // // update tblrequest by isAccept=1 and delete rest of request // } // else // { // var objRequestData = db.tblRequests.Where(x => x.isAccepted == false && x.fkTutorId ==Convert.ToInt32(objReq.tutorId) && x.uniqueRequestId==objReq.uniqueRequestId).FirstOrDefault(); // if (objRequestData != null) // { // db.tblRequests.DeleteOnSubmit(objRequestData); // db.SubmitChanges(); // } // else { // return false; // } // } // db.SubmitChanges(); // return true; // } //} #endregion internal bool SendPushForIos(IosPushModel push) { tblUser receiverData = new tblUser(); using (var db = new WizzDataContext()) { receiverData = db.tblUsers.Where(c => c.pkUserId == Convert.ToInt32(push.receiverId)).FirstOrDefault(); var sendor = db.tblUsers.Where(c => c.pkUserId == Convert.ToInt32(push.senderId)).FirstOrDefault(); // objPush.deviceToken = receiverData.deviceToken; PushData objPush = new PushData() { message = sendor.userName + ": " + push.Message, type = Convert.ToInt16(PushType.chatPush).ToString(), messageType=push.Type, userId=push.senderId, subject=push.subjectName, registration_ids = receiverData.deviceToken, badge = Convert.ToString(receiverData.badge), uniqueRequestid=push.requestId }; // push.type = PushType.newRequest.ToString(); // push.data = CommonMethod.ObjectToJson(objPush); // push.Type =push.Type; // push.messageId = push.messageId; // push.Message = push.Message; // push.senderName=push if (receiverData.deviceType == 1)//ios { SendPush objIOS = new SendPush(); objIOS.ConnectToAPNS(objPush); } else if (receiverData.deviceType == 2)//android { PushForIos objAndroid = new PushForIos(); objAndroid.SendPushForIos(push); } } return true; ///throw new NotImplementedException(); }