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