protected void btn_importLOA_Click(object sender, EventArgs e) { DataTable dtLOA; ImportYEBData iObj = new ImportYEBData(); if (Session["yrmo"] != null) { usryrmo = Session["yrmo"].ToString(); } if (Session["pilotind"] != null) { pilotind = Session["pilotind"].ToString(); } status = "EBALOA"; if (pilotind != "" && status != "") { try { //Delete any previously imported data for the specified YRMO and criteria ImportYEBData.Rollback("LOA" + pilotind, usryrmo); //retrieve the datatable for the criteria specified based on status dtLOA = ImportYEBData.getYEBEmployeesbyStatus(pilotind, status.Substring(3, 3)).Tables[0]; if (dtLOA.Rows.Count > 0) { ImportYEBData.PrintLOAProgressBar(); _counter = iObj.insertYEB_ACT_LOA_Data(dtLOA, usryrmo, pilotind, src, status); ImportYEBData.ClearProgressBar(_counter); if (_counter > 0) { MultiView1.SetActiveView(view_result); lbl_result.Text = "Import completed successfully -- " + _counter + " records imported"; } } } catch (Exception ex) { //resultDiv.Visible = false; //ImportYEBData iObj = new ImportYEBData(); ImportYEBData.Rollback("LOA" + pilotind, usryrmo); lbl_error.Text = "Error - " + ex.Message; } } }