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