public List <SalesShow> ShowSalesProduct(string salesCode)
{
List <SalesShow> salesProductShows = new List <SalesShow>();
Connect();
query = "SELECT Code, Product, Category, Quantity, TotalMRP, DiscountAmount, PayableAmount FROM SalesView WHERE SalesCode = '" + salesCode + "'";
_sqlCommand = new SqlCommand {
CommandText = query, Connection = DatabaseConnection.sqlConnection
};
_sqlDataReader = _sqlCommand.ExecuteReader();
while (_sqlDataReader.Read())
{
SalesShow aSalesShow = new SalesShow
{
ProductCode = _sqlDataReader["Code"].ToString(),
Product = _sqlDataReader["Product"].ToString(),
Category = _sqlDataReader["Category"].ToString(),
Quantity = Convert.ToInt32(_sqlDataReader["Quantity"]),
TotalMRP = Convert.ToDouble(_sqlDataReader["TotalMRP"]),
DiscountAmount = Convert.ToDouble(_sqlDataReader["DiscountAmount"]),
PayableAmount = Convert.ToDouble(_sqlDataReader["PayableAmount"])
};
salesProductShows.Add(aSalesShow);
}
DatabaseConnection.sqlConnection.Close();
return(salesProductShows);
}
public List <SalesShow> SearchSales(string searchItem)
{
List <SalesShow> salesShows = new List <SalesShow>();
Connect();
query = "select distinct (SalesCode), SalesDate, Customer FROM SalesView WHERE SalesCode LIKE '%" + searchItem + "%' OR SalesDate LIKE '%" + searchItem + "%' OR Customer LIKE '%" + searchItem + "%' ";
_sqlCommand = new SqlCommand {
CommandText = query, Connection = DatabaseConnection.sqlConnection
};
_sqlDataReader = _sqlCommand.ExecuteReader();
while (_sqlDataReader.Read())
{
SalesShow aSalesShow = new SalesShow
{
Date = Convert.ToDateTime(_sqlDataReader["SalesDate"]),
SalesCode = _sqlDataReader["SalesCode"].ToString(),
Customer = _sqlDataReader["Customer"].ToString()
};
salesShows.Add(aSalesShow);
}
DatabaseConnection.sqlConnection.Close();
return(salesShows);
}
public List <SalesShow> ShowSales()
{
List <SalesShow> salesShows = new List <SalesShow>();
Connect();
query = "SELECT distinct (SalesCode), SalesDate, Customer FROM SalesView";
_sqlCommand = new SqlCommand {
CommandText = query, Connection = DatabaseConnection.sqlConnection
};
_sqlDataReader = _sqlCommand.ExecuteReader();
while (_sqlDataReader.Read())
{
SalesShow aSalesShow = new SalesShow
{
Date = Convert.ToDateTime(_sqlDataReader["SalesDate"]),
SalesCode = _sqlDataReader["SalesCode"].ToString(),
Customer = _sqlDataReader["Customer"].ToString()
};
salesShows.Add(aSalesShow);
}
DatabaseConnection.sqlConnection.Close();
return(salesShows);
}
