public string CreateUserFromExist(string Firstname, string LastName, string UserName, string EmailAddress, string ContactTelephone, string ExistUser) { try { //test: https://localhost:44339/api/user?Firstname=tnguyen3z&Lastname=cachon&UserName=tnguyen399&[email protected]&ContactTelephone=1111&ExistUser=tnguyen327.u1 DBAskDataContext db = new DBAskDataContext(); string Password = GeneratePassword(10); int res = db.usp_CreateUserFromExistUser(Firstname, LastName, UserName, EmailAddress, ContactTelephone, Password, ExistUser); //"tnguyen327.u1" db.SubmitChanges(); // db.Foods.InsertOnSubmit(food); return(Password); } catch (Exception ex) { return("Error:" + ex.Message); } }
public string SetPermission(string Username, string IsLocked) { DBAskDataContext db = new DBAskDataContext(); usp_tbl_EmailMessage_SearchResult em = db.usp_tbl_EmailMessage_Search(" LanguageID = 2057 AND tbl_EmailMessage.PK = 1 ").FirstOrDefault(); SendEmail("test Sub", em.Body, "*****@*****.**", "*****@*****.**", "*****@*****.**"); return(""); ///var obj = db.tbl_Users.Where(x => x.UserName.Contains(Username) && x.Leaver == false).ToList(); tbl_User user = db.tbl_Users.FirstOrDefault(x => x.UserName == Username); if (user == null) { return("not found"); } user.Locked = (IsLocked == "1"); //db.SubmitChanges(); if (IsLocked != "1") { tbl_PasswordReset pr = db.tbl_PasswordResets.Where(x => x.UserID == user.PK).OrderByDescending(x => x.PK).First(); if (pr != null) { if ((PasswordResetStatus)pr.Status == PasswordResetStatus.InProgress) { pr.Status = (int)PasswordResetStatus.Expired; pr.LastAttemptDate = DateTime.UtcNow; } } } tbl_PasswordReset resetPwdEnt = new tbl_PasswordReset(); string tempPwd = GeneratePassword(10); string validationCode = GetMD5String(DateTime.UtcNow.ToString()); resetPwdEnt.UserID = user.PK; resetPwdEnt.TempPassword = tempPwd; resetPwdEnt.ValidationCode = validationCode; resetPwdEnt.ResetDate = DateTime.UtcNow; db.SubmitChanges(); string URL_CHANGE_PASSWORD = ConfigurationManager.AppSettings["URL_RESET"]; }