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