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 LoginAction(User u)
{
DbCommunicator dc = new DbCommunicator();
string query = $"SELECT * FROM Users WHERE UserName = '******' AND Password = '******'";
SqlDataReader data = dc.GetData(query);
while (data.Read())
{
u.Role = data.GetString(2);
if (u.Role.Equals("admin"))
{
new AdminForm().Show();
}
else if (u.Role.Equals("Salesman"))
{
SalesForm.user = u;
new SalesForm().Show();
}
dc.DbConnection.Close();
return(true);
}
u.ErrorMessage = "Login credentials do not match";
return(false);
}
public ReportModel GetReport(DateTime dt)
{
ReportModel rp = new ReportModel();
string query = $"SELECT Profit, SalesPrice FROM Sales WHERE Date = '{dt.Date}'";
DbCommunicator dc = new DbCommunicator();
SqlDataReader data = dc.GetData(query);
double profit = 0, total = 0;
while (data.Read())
{
profit += data.GetDouble(0);
total += data.GetDouble(1);
}
dc.DbConnection.Close();
rp.Profit = profit.ToString();
rp.Total = total.ToString();
return(rp);
}
public List <Product> GetAllProducts()
{
DbCommunicator dc = new DbCommunicator();
string query = "SELECT * FROM Products";
SqlDataReader data = dc.GetData(query);
List <Product> ppList = new List <Product>();
while (data.Read())
{
ppList.Add(new Product()
{
Id = data.GetInt32(0),
ProductName = data.GetString(1),
CurrentStock = data.GetInt32(2),
Description = data.GetString(3),
BuyingCost = data.GetDouble(4),
Price = data.GetDouble(5)
});
}
dc.DbConnection.Close();
return(ppList);
}