/* Static Boolean method to validate credentials from Login Form */
public static bool ValidateCredentials(string username, string password)
{
bool loginSuccessfully = false;
//If string null
if (string.IsNullOrWhiteSpace(username) || string.IsNullOrWhiteSpace(password))
{
MessageBox.Show("Please provide a Username and Password!", "Warning");
return(false);
}
using (var db = new GestiuneDBEntities())
{
// string ecryptedPassword = EncryptPassword(password, hashString);
var loginAttempt = db.Credentials.FirstOrDefault(u => u.Username == username && u.Password == password);
if (loginAttempt != null)
{
loginSuccessfully = true;
}
}
if (loginSuccessfully == true)
{
return(true);
}
else
{
MessageBox.Show("Username sau parola incorecte", "Warning", MessageBoxButtons.OK);
}
return(false);
}
static public void SearchSuppliers(string txtSearchSuppliers, DataGridView dataGridView)
{
using (var db = new GestiuneDBEntities())
{
var search = db.Furnizori.Where(s => s.Denumire.StartsWith(txtSearchSuppliers));
dataGridView.DataSource = search.ToList();
}
}
static public void SaveAndCloseEmployees()
{
if (db != null)
{
db.SaveChanges();
db.Dispose();
db = null;
}
}
/* Static boolean method to register new user from Login Form*/
public static bool RegisterNewUser(int userID, string username, string password, string email)
{
if (string.IsNullOrWhiteSpace(username) || string.IsNullOrWhiteSpace(password) || string.IsNullOrWhiteSpace(email))
{
MessageBox.Show("Va rugam completati toate campurile!", "Warning", MessageBoxButtons.OK);
return(false);
}
using (var db = new GestiuneDBEntities())
{
var idFound = db.Angajati.FirstOrDefault(b => b.AngajatID == userID);
var idDuplicate = db.Credentials.FirstOrDefault(c => c.AngajatID == userID);
var usernameFound = db.Credentials.FirstOrDefault(a => a.Username == username);
if (idFound != null)
{
if (idDuplicate == null)
{
if (IsMailValid(email))
{
if (usernameFound == null)
{
Credentials credential = new Credentials();
credential.Username = username;
credential.Password = EncryptPassword(password, hashString);
credential.AngajatID = userID;
credential.Email = email;
db.Entry(credential).State = EntityState.Added;
db.Credentials.Add(credential);
db.SaveChanges();
return(true);
}
else
{
MessageBox.Show("Username-ul introdus exista deja. Incercati unul nou", "Warning", MessageBoxButtons.OK);
return(false);
}
}
else
{
MessageBox.Show("Emailul introdus nu este valid. Incercati din nou", "Warning", MessageBoxButtons.OK);
return(false);
}
}
else
{
MessageBox.Show("Exista deja un utilizator inregistrat cu acest Cod unic", "Warning", MessageBoxButtons.OK);
return(false);
}
}
else
{
MessageBox.Show("Cod unic inexistent. Contactati administratorul pentru o cheie valida.", "Error", MessageBoxButtons.OK);
return(false);
}
}
}
static public void SaveAndCloseProducts()
{
if (db != null)
{
db.SaveChanges();
db.Dispose();
db = null;
}
}
public static void EditProducts(BindingSource articoleBindingSource, DataGridView gv)
{
db = new GestiuneDBEntities();
db.Articole.Load();
articoleBindingSource.DataSource = db.Articole.Local.ToBindingList();
//String sugestiv = "select * from Articole where ";
}
static public void ShowSuppliers(DataGridView dataGridView)
{
using (var db = new GestiuneDBEntities())
{
db.Furnizori.Load();
var fur = from Furnizori in db.Furnizori.Local select Furnizori;
dataGridView.DataSource = fur.ToList();
}
}
static public void SaveAndCloseSuppliers()
{
if (db != null)
{
db.SaveChanges();
db.Dispose();
db = null;
}
}
public static void Suggest(DataGridView dataGVProducts, DataGridViewEditingControlShowingEventArgs e)
{
using (var db = new GestiuneDBEntities())
{
db.Furnizori.Load();
var suppliersName = from Furnizori in db.Furnizori.Local select Furnizori.Denumire;
autoComplete = new AutoCompleteStringCollection();
autoComplete.AddRange(suppliersName.ToArray());
if (dataGVProducts.CurrentCell.ColumnIndex == 8)
{
TextBox txt = e.Control as TextBox;
if (txt != null)
{
txt.AutoCompleteMode = AutoCompleteMode.Suggest;
txt.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt.AutoCompleteCustomSource = autoComplete;
}
}
}
}
public static void UpdateSupplierNameColumn(DataGridView dataGVProducts)
{
using (var db = new GestiuneDBEntities())
{
db.Furnizori.Load();
int suppliersColumnIndex = 8;
foreach (DataGridViewRow row in dataGVProducts.Rows)
{
//gets the suppliers Id from each cell in FurnizoriId
var supplierId = row.Cells[suppliersColumnIndex - 1].Value;
if (supplierId != null)
{
//if the supplierId is equal with the id in Furnizori
var supplierName = db.Furnizori.Local.FirstOrDefault(a => a.FurnizorID.Equals(supplierId));
if (supplierName != null)
{
row.Cells[suppliersColumnIndex].Value = supplierName.Denumire.ToString();
}
}
}
}
}
public static bool RecoverPassword(string email)
{
if (IsMailValid(email))
{
using (var db = new GestiuneDBEntities())
{
var emailAttempt = db.Credentials.FirstOrDefault(a => a.Email == email);
if (emailAttempt != null)
{
return(SendMail(DecryptPassword(emailAttempt.Password, hashString), emailAttempt.Email, emailAttempt.Username));
}
else
{
MessageBox.Show("Nu exista niciun cont cu acest email", "Warning", MessageBoxButtons.OK);
return(false);
}
}
}
else
{
MessageBox.Show("Emailul introdus nu este valid. Incercati din nou.", "Warning", MessageBoxButtons.OK);
return(false);
}
}
public static void EditEmployees(BindingSource angajatiBindingSource)
{
db = new GestiuneDBEntities();
db.Angajati.Load();
angajatiBindingSource.DataSource = db.Angajati.Local.ToBindingList();
}
public static void EditSuppliers(BindingSource furnizoriBindingSource)
{
db = new GestiuneDBEntities();
db.Furnizori.Load();
furnizoriBindingSource.DataSource = db.Furnizori.Local.ToBindingList();
}
