public int Delete(int id) { database = new Database.Database(); string query = string.Format("DELETE FROM Customer WHERE CustomerID = {0}", id); var customer = database.ExecuteQueries(query); return(customer); }
public int Delete(int id) { database = new Database.Database(); string query = string.Format("DELETE FROM SALER WHERE SalerId = {0}", id); var saler = database.ExecuteQueries(query); return(saler); }
public int Delete(int id) { database = new Database.Database(); string query = string.Format("DELETE FROM Personal WHERE Personalid = {0}", id); var personal = database.ExecuteQueries(query); return(personal); }
public int Delete(int StoreID) { database = new Database.Database(); string query = string.Format("DELETE FROM STORE WHERE StoreID = {0}", StoreID); var store = database.ExecuteQueries(query); return(store); }
public int Delete(int id) { database = new Database.Database(); string query = string.Format("DELETE FROM Storage WHERE StorageId = {0}", id); var storage = database.ExecuteQueries(query); return(storage); }
public bool Insert(Personal personal, int roleID) { try { database = new Database.Database(); string query = string.Format("INSERT INTO Personal (PersonalName,PersonalSurname,PersonalNationalNumber,PersonalNumber,PersonalAddress,PersonalEmail,PersonalTitle,PersonalNickName,PersonalPassword) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", personal.PersonalName, personal.PersonalSurname, personal.PersonalNationalNumber, personal.PersonalNumber, personal.PersonalAddress, personal.PersonalEmail, personal.PersonalTitle, personal.PersonalNickName, personal.PersonalPassword); database.ExecuteQueries(query); string query1 = string.Format("INSERT INTO UserRole (Personalid,RoleId) VALUES ({0},{1})", personal.PersonalId, roleID); database.ExecuteQueries(query1); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } return(true); }
public bool Update(Customer customer) { try { database = new Database.Database(); string query = string.Format("UPDATE Customer SET CustomerName='{0}',CustomerSurname='{1}',customerNumber='{2}',customerAddress='{3}',customerEmail='{4}'WHERE customerid='{5}'", customer.name, customer.Surname, customer.Number, customer.address, customer.email, customer.id); database.ExecuteQueries(query); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } return(true); }
public bool Insert(Customer customer) { try { database = new Database.Database(); string query = string.Format("INSERT INTO Customer (CustomerName, CustomerSurname, CustomerNumber, CustomerAddress, CustomerEmail) VALUES ('{0}','{1}','{2}','{3}','{4}')", customer.name, customer.Surname, customer.Number, customer.address, customer.email); database.ExecuteQueries(query); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } return(true); }
public bool Update(Class.Personal personal) { try { database = new Database.Database(); string query = string.Format("UPDATE Personal SET PersonalName='{0}',PersonalSurname='{1}',PersonalNationalNumber='{2}',PersonalNumber='{3}',PersonalAddress='{4}',PersonalEmail='{5}',PersonalTitle='{6}',PersonalNickName='{7}',PersonalPassword='******'WHERE Personalid='{9}'", personal.PersonalName, personal.PersonalSurname, personal.PersonalNationalNumber, personal.PersonalNumber, personal.PersonalAddress, personal.PersonalEmail, personal.PersonalTitle, personal.PersonalNickName, personal.PersonalPassword, personal.PersonalId); database.ExecuteQueries(query); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } return(true); }
public bool Update(Saler saler) { try { database = new Database.Database(); string query = string.Format("UPDATE Saler SET FirmName='{0}',FirmTitle='{1}',TaxNumber='{2}',TaxOffice='{3}',Address='{4}',WorkPhone='{5}',CellPhone='{6}',FaxNumber='{7}',Email='{8}' WHERE SalerId='{9}'", saler.FirmName, saler.FirmTitle, saler.TaxNumber, saler.TaxOffice, saler.Address, saler.WorkPhone, saler.CellPhone, saler.FaxNumber, saler.Email, saler.SalerId); database.ExecuteQueries(query); } catch (Exception ex) { return(false); } return(true); }
public virtual bool Insert(Saler saler) { try { database = new Database.Database(); string query = string.Format("INSERT INTO Saler (FirmName,FirmTitle,TaxNumber,TaxOffice,Address,WorkPhone,CellPhone,FaxNumber,Email) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", saler.FirmName, saler.FirmTitle, saler.TaxNumber, saler.TaxOffice, saler.Address, saler.WorkPhone, saler.CellPhone, saler.FaxNumber, saler.Email); database.ExecuteQueries(query); } catch (Exception ex) { return(false); } return(true); }
public bool Update(Store store) { try { database = new Database.Database(); string query = string.Format("UPDATE Store SET StoreName='{0}',StoreAdress='{1}',StoreOpenHour='{2}',StoreCloseHour='{3}',StoreStorage='{4}' WHERE StoreID='{5}'" , store.storeName, store.StoreAdress, store.StoreOpenHour, store.StoreCloseHour, store.StoreStorage, store.StoreID); database.ExecuteQueries(query); } catch (Exception ex) { return(false); } return(true); }
public bool Insert(Store store) { try { database = new Database.Database(); string query = string.Format("INSERT INTO Store (StoreName,StoreAdress,StoreOpenHour,StoreCloseHour,StoreStorage) VALUES ('{0}','{1}','{2}','{3}','{4}')" , store.StoreName, store.StoreAdress, store.StoreOpenHour, store.StoreCloseHour, store.StoreStorage); database.ExecuteQueries(query); } catch (Exception ex) { return(false); } return(true); }
public bool Update(Storage storage) { try { database = new Database.Database(); string query = string.Format("UPDATE Storage SET StorageType='{0}',StorageTaxNumber='{1}''StorageSize{2}',StorageAdress='{3}',StoragePhoneNumber='{4}',StorageFaxNumber='{5}' WHERE StorageID ='{6}'", storage.StorageType, storage.StorageTaxNumber, storage.StorageSize, storage.StorageAddress, storage.StoragePhoneNumber, storage.StorageFaxNumber, storage.StorageId); database.ExecuteQueries(query); } catch (Exception ex) { return(false); } return(true); }
public bool Save(User user) { try { database = new Database.Database(); string query = string.Format("UPDATE User SET UserName= '******',Password='******',Name='{2}',Surname='{3}',Email='{4}',PhoneNumber='{5}',Salary='{6}',FirstLogin='******',SecurityQuestion='{8}',SecurityAnswer = '{9}' WHERE UserId={10}", user.UserName, user.Password, user.Name, user.Surname, user.Email, user.PhoneNumber, user.Salary, user.Firstlogin, user.SecurityQuestion, user.SecurityAnswer, user.UserID); database.ExecuteQueries(query); } catch (Exception ex) { return(false); } return(true); }
public bool Insert(Storage storage) { try { database = new Database.Database(); string query = string.Format("INSERT INTO Storage (StorageType,StorageTaxNumber,StorageSize,StorageAdress,StoragePhoneNumber,StorageFaxNumber) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}')", storage.StorageType, storage.StorageTaxNumber, storage.StorageSize , storage.StorageAddress, storage.StoragePhoneNumber, storage.StorageFaxNumber); database.ExecuteQueries(query); } catch (Exception ex) { return(false); } return(true); }