private void BindProduct()
{
try
{
if (txtSearch.Text.Trim() != "Search")
{
objPI.SearchText = txtSearch.Text.Trim();
}
else
{
objPI.SearchText = "";
}
if (objPI.SortDirection == null && objPI.SortColumnName == null)
{
objPI.SortDirection = Convert.ToString(ViewState[Constants.SORTDERECTION]);
objPI.SortColumnName = Convert.ToString(ViewState[Constants.SORTCOLUMNNAME]);
}
//List<Manufacturer> objData = new ManufacturerBLL().GetAll(objPI);
BLL.Component.ProductBLL objprod = new BLL.Component.ProductBLL();
gvGrid.DataSource = objprod.GetStockByDate(objPI, toDate.Value);
gvGrid.DataBind();
}
catch (Exception ex)
{
SendMail.MailMessage("CSWeb > Error > " + (new System.Diagnostics.StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString());
}
}
protected void gvGrid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
Product objProd = new Product();
TextBox txtControl;
txtControl = ((TextBox)gvGrid.Rows[e.RowIndex].FindControl("txtProductIDE"));
if (txtControl.Text != null)
{
objProd.ProductID = Convert.ToInt32(txtControl.Text.Trim());
}
txtControl = ((TextBox)gvGrid.Rows[e.RowIndex].FindControl("txtProductNameE"));
if (txtControl != null)
{
objProd.ProductName = txtControl.Text.Trim();
}
txtControl = ((TextBox)gvGrid.Rows[e.RowIndex].FindControl("txtDescriptionE"));
if (txtControl != null)
{
objProd.Description = txtControl.Text.Trim();
}
txtControl = ((TextBox)gvGrid.Rows[e.RowIndex].FindControl("txtMarginE"));
if (txtControl != null)
{
objProd.Margin = Convert.ToDecimal(txtControl.Text.Trim());
}
objProd.UpdatedBy = 1;
int mintReturn = new BLL.Component.ProductBLL().EditProduct(objProd);
if (mintReturn == -1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Brand with same name already exists.');", true);
}
}
catch (Exception ex)
{
}
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Updated successfully');", true);
gvGrid.EditIndex = -1;
BindProduct();
}