// GET: Report public ActionResult PurchaseReport() { PurchaseView1 purchaseView1 = new PurchaseView1(); purchaseView1.PurchaseView1s = _purchaseReportManager.LoadProducts(); return(View(purchaseView1)); }
//double availableQuantity; //public double GetAvailableProduct(int productId) //{ // SqlConnection sqlConnection = new SqlConnection(connectionString); // sqlConnection.Open(); // string query = "SELECT AvailableQuantity FROM PurchaseView1 WHERE ProductId = " + productId+ " ORDER BY AvailableQuantity DESC"; // SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); // SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); // DataTable dataTable = new DataTable(); // int isFill = sqlDataAdapter.Fill(dataTable); // if (dataTable.Rows.Count > 0) // { // availableQuantity = double.Parse(dataTable.Rows[0][0].ToString()); // } // return availableQuantity; //} public List <PurchaseView1> SearchProducts(PurchaseView1 purchaseView1) { List <PurchaseView1> purchaseView1s = new List <PurchaseView1>(); SqlConnection sqlConnection = new SqlConnection(connectionString); sqlConnection.Open(); string query = @"SELECT * FROM PurchaseView1 WHERE Date BETWEEN '" + purchaseView1.StartDate + "' AND '" + purchaseView1.EndDate + "'"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { PurchaseView1 purchaseView = new PurchaseView1(); purchaseView.Product = sqlDataReader["Product"].ToString(); purchaseView.Date = sqlDataReader["Date"].ToString(); purchaseView.AvailableQuantity = Convert.ToDouble(sqlDataReader["AvailableQuantity"].ToString()); purchaseView.UnitPrice = Convert.ToDouble(sqlDataReader["UnitPrice"].ToString()); purchaseView.MRP = Convert.ToDouble(sqlDataReader["MRP"].ToString()); purchaseView.Profit = Convert.ToDouble(sqlDataReader["Profit"].ToString()); purchaseView1s.Add(purchaseView); } sqlConnection.Close(); return(purchaseView1s); }
public List <PurchaseView1> LoadProducts() { List <PurchaseView1> purchaseView1s = new List <PurchaseView1>(); SqlConnection sqlConnection = new SqlConnection(connectionString); sqlConnection.Open(); string query = "SELECT * FROM PurchaseView1"; SqlCommand sqlCommand = new SqlCommand(query, sqlConnection); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { PurchaseView1 purchaseView1 = new PurchaseView1(); purchaseView1.Product = sqlDataReader["Product"].ToString(); purchaseView1.Date = sqlDataReader["Date"].ToString(); purchaseView1.AvailableQuantity = Convert.ToDouble(sqlDataReader["AvailableQuantity"].ToString()); purchaseView1.UnitPrice = Convert.ToDouble(sqlDataReader["UnitPrice"].ToString()); purchaseView1.MRP = Convert.ToDouble(sqlDataReader["MRP"].ToString()); purchaseView1.Profit = Convert.ToDouble(sqlDataReader["Profit"].ToString()); purchaseView1s.Add(purchaseView1); } sqlConnection.Close(); return(purchaseView1s); }
public ActionResult PurchaseReport(PurchaseView1 purchaseView1) { //PurchaseView1 purchaseView1 = new PurchaseView1(); purchaseView1.PurchaseView1s = _purchaseReportManager.SearchProducts(purchaseView1); return(View(purchaseView1)); }
public List <PurchaseView1> SearchProducts(PurchaseView1 purchaseView1) { return(_purchaseReportRepository.SearchProducts(purchaseView1)); }