void loadSoldTable() { DateTime sDate = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")); DateTime eDate = Convert.ToDateTime(DateTime.Now.AddDays(+1).ToString("MM/dd/yyyy")); //eDate.ToString("dd-MMM-yyyy") //DateTime sDate = DateTime.ParseExact(sDates, "MM/dd/yyyy", CultureInfo.InvariantCulture); // DateTime eDate = DateTime.ParseExact(eDates, "MM/dd/yyyy", CultureInfo.InvariantCulture); List <GetProductStock> ListItem = new List <GetProductStock>(); GetProductStock lObj = new GetProductStock(); ListItem = lObj.getProdAlongWithSalesQuantity_ByDate(con, sDate, eDate); int i = 0; gridSOldItem.Rows.Clear(); foreach (GetProductStock item in ListItem) { gridSOldItem.Rows.Add(); gridSOldItem.Rows[i].Cells[1].Value = item.name; gridSOldItem.Rows[i].Cells[0].Value = item.ID; gridSOldItem.Rows[i].Cells[2].Value = item.cost; gridSOldItem.Rows[i].Cells[3].Value = item.unitPrice; gridSOldItem.Rows[i].Cells[4].Value = item.TotalQuantity; i++; } }
private void btnSearch_Click(object sender, EventArgs e) { try { //DateTime sDate = Convert.ToDateTime(dateStart.Text); //DateTime eDate = Convert.ToDateTime(dateEnd.Text); DateTime sDate = DateTime.ParseExact(dateStart.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture); DateTime eDate = DateTime.ParseExact(dateEnd.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture); List <GetProductStock> ListItem = new List <GetProductStock>(); GetProductStock lObj = new GetProductStock(); ListItem = lObj.getProdAlongWithSalesQuantity_ByDate(con, sDate, eDate); loadGrid(ListItem); } catch (Exception ex) { MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error); } }