public static string CheckValidPassword(string username, string password) { string error = string.Empty; TUsers user = null; try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { if (string.IsNullOrEmpty(username)) { return("Моля въведете правилно потребителско име"); } if (string.IsNullOrEmpty(password)) { return("Моля въведете правилна парола"); } var use = (from us in db.Users where us.Username.Equals(username) && us.Password.Equals(password) select us).FirstOrDefault(); if (use == null) { return(" Невалидно потребителско име"); } user = new TUsers(use); } Program.CurrentUser = user; } catch (Exception ex) { error = ex.Message; } return(error); }
public TUsers LoadUser(int ID) { string error = ""; var user = new TUsers(); //TUsers user = new TUsers(); try { using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring)) { if (this.ID > 0) { user = (from us in db.Users where us.ID == this.ID select new TUsers(us)).FirstOrDefault(); } } } catch (Exception ex) { error = ex.Message; } return(user); }