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);
}
