private void BindGridDB()
{
OpenTyreDAL objOpeningStock = new OpenTyreDAL();
DataTable dtItem = objOpeningStock.SelectPartFromExcel(ApplicationFunction.ConnectionString());
if (dtItem.Rows.Count > 0)
{
for (int i = 0; i < dtItem.Rows.Count; i++)
{
dtTemp = (DataTable)ViewState["dt"];
if ((dtTemp != null) && (dtTemp.Rows.Count > 0))
{
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToString(row["SerialNo"]) == Convert.ToString(dtItem.Rows[i]["SerialNo"].ToString()))
{
string msg = "Serial No. Already Exist For Same Item";
ddlItemName.Focus();
ShowMessageErr(msg);
return;
}
}
}
Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1;
int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1;
string compName = dtItem.Rows[i]["CompanyName"].ToString();
string strSerialNo = dtItem.Rows[i]["SerialNo"].ToString();
string TypeID = dtItem.Rows[i]["Type_Idno"].ToString();
string strType = dtItem.Rows[i]["Type"].ToString();
string strPur = dtItem.Rows[i]["PurchaseFrom"].ToString();
string strItemName = dtItem.Rows[i]["Item_Name"].ToString();
string strItemIdno = dtItem.Rows[i]["Item_Idno"].ToString();
string openRate = Convert.ToDouble(dtItem.Rows[i]["Item_Rate"].ToString()).ToString("N2");
ApplicationFunction.DatatableAddRow(dtTemp, id, strSerialNo, compName, TypeID, strType, strPur, openRate, strItemName, strItemIdno);
}
}
ViewState["dt"] = dtTemp;
this.BindGridT();
}
