public List <tbl_User> GetUserLists(string Username) //List<tbl_User>
{
DBAskDataContext db = new DBAskDataContext();
var obj = db.tbl_Users.Where(x => x.UserName.Contains(Username) && x.Leaver == false).ToList();
return(obj);
}
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"];
}
