protected void lnkbtnUpload_OnClick(object sender, EventArgs e)
        {
            string msg = string.Empty;

            if (!FileUpload.HasFile)
            {
                FileUpload.Focus();
                msg = "Please Select Excel File!";
                ShowMessageErr(msg);
                return;
            }
            if (ddlDateRange.SelectedValue == "0")
            {
                ddlDateRange.Focus();
                msg = "Please Select Date Range!";
                ShowMessageErr(msg);
                return;
            }
            if (ddlLocation.SelectedValue == "0")
            {
                ddlLocation.Focus();
                msg = "Please Select Location!";
                ShowMessageErr(msg);
                return;
            }
            OpenTyreDAL objOpenStockAccess = new OpenTyreDAL();
            string      excelfilename      = string.Empty;

            try
            {
                using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
                {
                    excelfilename = ApplicationFunction.UploadFileServerControl(FileUpload, "ExcelTyre", "OpeningStockAccessories");
                    if ((System.IO.Path.GetExtension(excelfilename) == ".xls") || (System.IO.Path.GetExtension(excelfilename) == ".xlsx"))
                    {
                        DataTable   dt          = ReadExcelFile("~/ExcelTyre/" + excelfilename);
                        Int64       value       = 0;
                        OpenTyreDAL clsOpngStck = new OpenTyreDAL();
                        DataTable   DtnotUpload = dt.Clone();

                        OpenTyreDAL objItem = new OpenTyreDAL();
                        for (int count = 0; count < dt.Rows.Count; count++)
                        {
                            var lst = objItem.GetItemDetailsExl(Convert.ToString(dt.Rows[count]["TyreName"]).Trim());
                            if (lst.Count <= 0)
                            {
                                ShowMessageErr(Convert.ToString(dt.Rows[count]["TyreName"].ToString()).Trim() + " Item Does Not Exist!");
                                return;
                            }
                            else
                            {
                                string Type = dt.Rows[count]["Type"].ToString();
                                if (Type == "New" || Type == "Old" || Type == "Retrieted")
                                {
                                    string Type_Idno = (Type == "New") ? "1" : (Type == "Old") ? "2" : "3";
                                    dt.Rows[count]["Type_Idno"] = Type_Idno;
                                }
                                else
                                {
                                    ShowMessageErr(Convert.ToString(dt.Rows[count]["Type"].ToString()).Trim() + " Type Does Not Exist of " + dt.Rows[count]["TyreName"].ToString() + " Item!");
                                    return;
                                }
                            }
                        }
                        int dttruncate = objOpenStockAccess.TurncatePartsAccessoriesFromExcel(ApplicationFunction.ConnectionString());
                        value = clsOpngStck.InsertPartsByExcel(dt, ApplicationFunction.ConnectionString());

                        BindGridDB();
                    }
                    else
                    {
                        msg = "Excel File Format Not Supported!";
                        ShowMessageErr(msg);
                        return;
                    }
                }
            }
            catch (Exception Ex)
            {
            }
        }