protected void searchButton_Click(object sender, EventArgs e)
{
ViewSales viewSales = new ViewSales();
viewSales.FromDate = fromDateTextBox.Text;
viewSales.ToDate = toDateTextBox.Text;
string message = viewSalesManager.IsValidDate(viewSales);
if (message != "valid")
{
outputLabel.Text = message;
}
else
{
List <ViewSales> viewSaleItemsList = viewSalesManager.ViewByDate(viewSales);
if (viewSaleItemsList.Count <= 0)
{
outputLabel.Text = "No matched record found";
}
else
{
outputLabel.Text = "";
}
salesViewGridView.DataSource = viewSaleItemsList;
salesViewGridView.DataBind();
}
}
private List <ViewSales> GetViewSales(List <Sale> sales)
{
List <ViewSales> viewSales = new List <ViewSales>();
foreach (Sale l in sales)
{
ViewSales viewsale = new ViewSales();
viewsale.SalesId = l.SalesId;
if (l.EmployeeId == null)
{
viewsale.Type = "Cash";
}
else
{
viewsale.Type = "Due";
viewsale.Name = l.Employee.EmpFullName;
viewsale.EmpId = l.Employee.Emp_Id;
}
viewsale.Date = l.Date.ToString("dd-MMMM-yyyy");
viewsale.Price = l.Discount + l.Amount;
viewsale.Discount = l.Discount;
viewsale.Payable = l.Amount;
viewsale.Note = l.Note;
viewSales.Add(viewsale);
}
return(viewSales);
}
public List <ViewSales> ViewByDate(ViewSales viewSales)
{
string query = "SELECT * FROM SalesView WHERE (Date BETWEEN @fromDate AND @toDate) AND StockOutType='Sell' ORDER BY Item";
command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@fromDate", viewSales.FromDate);
command.Parameters.AddWithValue("@toDate", viewSales.ToDate);
connection.Open();
reader = command.ExecuteReader();
List <ViewSales> saleList = new List <ViewSales>();
while (reader.Read())
{
ViewSales viewSale = new ViewSales();
viewSale.ItemName = reader["Item"].ToString();
viewSale.CompanyName = reader["Company"].ToString();
viewSale.Quantity = Convert.ToInt32(reader["Quantity"]);
saleList.Add(viewSale);
}
connection.Close();
int len = saleList.Count;
for (int i = 0; i < len - 1; i++)
{
for (int j = i + 1; j < len; j++)
{
if (saleList[i].CompanyName == saleList[j].CompanyName &&
saleList[i].ItemName == saleList[j].ItemName)
{
saleList[i].Quantity += saleList[j].Quantity;
saleList.RemoveAt(j);
len -= 1;
j--;
}
}
}
return(saleList);
}
public string IsValidDate(ViewSales viewSales)
{
string fromDate = viewSales.FromDate;
string toDate = viewSales.ToDate;
if (fromDate == "" || toDate == "")
{
return("Please input the dates correctly");
}
for (int i = 0; i < toDate.Length; i++)
{
if (fromDate[i] > toDate[i])
{
return("To Date must be greater than or equal to From Date");
}
if (fromDate[i] < toDate[i])
{
break;
}
}
return("valid");
}
public List <ViewSales> GetsalesItemByDate(string fromDate, string toDate)
{
query = " SELECT ItemName,SELL FROM StockOutTable as s LEFT JOIN ItemTable AS i ON S.ItemID=I.ItemID WHERE SellDate BETWEEN '"+ fromDate + "' AND '" + toDate + "' AND StockOutType='sell' ";
command = new SqlCommand(query, connection);
List <ViewSales> salesItemList = new List <ViewSales>();
connection.Open();
reader = command.ExecuteReader();
int sl = 1;
while (reader.Read())
{
ViewSales salesItem = new ViewSales();
salesItem.Id = sl++;
salesItem.ItemName = reader["ItemName"].ToString();
salesItem.SellQuantity = Convert.ToInt32(reader["Sell"]);
salesItemList.Add(salesItem);
}
reader.Close();
connection.Close();
return(salesItemList);
}
public List <ViewSales> ViewByDate(ViewSales viewSales)
{
return(viewSalesGateway.ViewByDate(viewSales));
}
