/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ImgExpExcelVeteran_Click(object sender, EventArgs e) { try { int rowcount = ucCustomPagerItemsVeteranStatus.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN_VS"] == null) ? null : (ViewState["SORTBYCOLOUMN_VS"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION_VS"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION_VS"].ToString()); } BLL_Crew_Admin objBLL = new BLL_Crew_Admin(); DataTable dt = objBLL.CRUD_VeteranStatus("", "R", 0, 0, txtVeteranStatusFilter.Text != "" ? txtVeteranStatusFilter.Text : null, sortbycoloumn, sortdirection, null, null, ref rowcount, ref Result); string[] HeaderCaptions = { "Veteran Status" }; string[] DataColumnsName = { "VeteranStatus" }; GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "VeteranStatus", "VeteranStatus", ""); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
/// <summary> /// Delete Oil Major /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void onDeleteVeteranStatus(object source, CommandEventArgs e) { try { int rowcount = 0; BLL_Crew_Admin objBLL = new BLL_Crew_Admin(); DataTable dt = objBLL.CRUD_VeteranStatus("", "D", GetSessionUserID(), Convert.ToInt32(e.CommandArgument.ToString()), null, "", null, null, null, ref rowcount, ref Result); if (Result > 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "ShowMessage", "alert('Record deleted successfully')", true); } BindVeteranStatus(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
/// <summary> /// To save or update Veteran Status /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSaveVeteranStatus_OnClick(object sender, EventArgs e) { try { if (Convert.ToInt32(hdnVeteranStatusID.Value) > 0) { int rowcount = 0; BLL_Crew_Admin objBLL = new BLL_Crew_Admin(); DataTable dt = objBLL.CRUD_VeteranStatus(txtVeteranStatus.Text.Trim(), "U", GetSessionUserID(), Convert.ToInt32(hdnVeteranStatusID.Value), null, "", null, null, null, ref rowcount, ref Result); ///Result == 2 Already exists if (Result < 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('The selected Veteran Status already exist in the system');showModal('divAddVeteranStatus', false);", true); } else if (Result > 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("SuccessMessage/UpdateMessage") + "');hideModal('divAddVeteranStatus');", true); BindVeteranStatus(); } } else { int rowcount = 0; BLL_Crew_Admin objBLL = new BLL_Crew_Admin(); DataTable dt = objBLL.CRUD_VeteranStatus(txtVeteranStatus.Text.Trim(), "I", GetSessionUserID(), 0, null, "", null, null, null, ref rowcount, ref Result); ///Result == 2 Already exists if (Result < 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('The selected Veteran Status already exist in the system');showModal('divAddVeteranStatus', false);", true); } else if (Result > 0) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AlreadyExists", "alert('" + UDFLib.GetException("SuccessMessage/SaveMessage") + "');hideModal('divAddVeteranStatus');", true); BindVeteranStatus(); } } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
private void BindVeteranStatus() { try { int rowcount = ucCustomPagerItemsVeteranStatus.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN_VS"] == null) ? null : (ViewState["SORTBYCOLOUMN_VS"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION_VS"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION_VS"].ToString()); } BLL_Crew_Admin objBLL = new BLL_Crew_Admin(); DataTable dt = objBLL.CRUD_VeteranStatus("", "R", 0, 0, txtVeteranStatusFilter.Text != "" ? txtVeteranStatusFilter.Text : null, sortbycoloumn, sortdirection , ucCustomPagerItemsVeteranStatus.CurrentPageIndex, ucCustomPagerItemsVeteranStatus.PageSize, ref rowcount, ref Result); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItemsVeteranStatus.CountTotalRec = rowcount.ToString(); ucCustomPagerItemsVeteranStatus.BuildPager(); } if (dt.Rows.Count > 0) { gvVeteranStatus.DataSource = dt; gvVeteranStatus.DataBind(); ImgExpExcelVeteran.Visible = true; } else { gvVeteranStatus.DataSource = null; gvVeteranStatus.DataBind(); ImgExpExcelVeteran.Visible = false; } } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }