public bool isUserDataCorrect(string login, string password) { bool isDataCorrect = false; string _password = String.Empty; try { using (var reader = doQuery.Start(SqlQueries.PasswordByLogin(login))) _password = reader.GetString(0); } catch (Exception err) { System.Windows.Forms.MessageBox.Show(err.Message); return(isDataCorrect); } if (_password == password) { isDataCorrect = true; } return(isDataCorrect); }
public long NewOutputInvoiceNumber() { using (var reader = doQuery.Start(SqlQueries.OutputInvoiceNumber())) return(reader.GetLong(0)); }
public void AddClient(string Name, string PhoneNumber, decimal Discount, string ExtraData) { doQuery.Start(SqlQueries.AddProduct(Name, PhoneNumber, Discount, ExtraData)); }