public bool AddSalesman(User u)
{
DbCommunicator dc = new DbCommunicator();
string query = $"SELECT* FROM Users WHERE UserName = '******'";
SqlDataReader data = dc.GetData(query);
while (data.Read())
{
u.ErrorMessage = "This user is already exist";
dc.DbConnection.Close();
return(false);
}
dc.DbConnection.Close();
query = $"INSERT INTO Users VALUES ('{u.UserName}','{u.Password}','{u.Role}')";
int row = dc.WriteData(query);
dc.DbConnection.Close();
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool SaveSales(List <SaleModel> sales)
{
int row = 0;
foreach (SaleModel ss in sales)
{
DbCommunicator dc1 = new DbCommunicator();
string query = $"INSERT INTO Sales VALUES (" +
$"{ss.PrductData.Id}, '{ss.Salesman.UserName}'," +
$"{ss.SalesPrice}, {ss.Profit}," +
$"'{ss.Date.Date}', {ss.Quantity})";
row += dc1.WriteData(query);
dc1.DbConnection.Close();
DbCommunicator dc2 = new DbCommunicator();
query = "UPDATE Products SET CurrentStock = " + (ss.PrductData.CurrentStock - ss.Quantity) + " WHERE ID = '" + ss.PrductData.Id + "'";
row += dc2.WriteData(query);
dc2.DbConnection.Close();
}
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateProduct(Product p)
{
DbCommunicator dc = new DbCommunicator();
string query = $"UPDATE Products SET CurrentStock = {p.CurrentStock}, BuyingCost = {p.BuyingCost}, Price = {p.Price}, RestockDate = '{p.RestockDate}'" +
$" WHERE Id = {p.Id}";
int row = dc.WriteData(query);
dc.DbConnection.Close();
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool AddProduct(Product pp)
{
DbCommunicator dc = new DbCommunicator();
string query = $"INSERT INTO Products VALUES (" +
$"'{pp.ProductName}', {pp.CurrentStock}," +
$"'{pp.Description}', {pp.BuyingCost}," +
$"{pp.Price}, '{pp.RestockDate}')";
int row = dc.WriteData(query);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}