/// <summary> /// Update Database Make data as Obsoluted /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void IsObsolete_CheckedChanged(Object sender, EventArgs e) { string message = string.Empty; try { CheckBox chk = (CheckBox)sender; GridViewRow gr = (GridViewRow)chk.Parent.Parent; string SUBCOUNTYID = ((Literal)gr.FindControl("litSUBCOUNTYID")).Text; SubCountyBLL SubCountyBLLobj = new SubCountyBLL(); message = SubCountyBLLobj.ObsoleteSubCounty(Convert.ToInt32(SUBCOUNTYID), Convert.ToString(chk.Checked), Convert.ToInt32(Session["USER_ID"])); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } ClearData(); BindGrid(); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Obsoleted", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// To fetch suncounty details based on ID from database /// </summary> private void GetSubCountyById() { SubCountyBLL SubCountyBLLobj = new SubCountyBLL(); SubCountyBO SubCountyBOobj = SubCountyBLLobj.GetSubCountyById(Convert.ToInt32(ViewState["SUBCOUNTYID"])); if (SubCountyBOobj != null) { txtSubcounty.Text = SubCountyBOobj.SubCountyName; } ddlDistrict.ClearSelection(); ddlCounty.ClearSelection(); if (ddlDistrict.Items.FindByText(SubCountyBOobj.DistrictName.ToString()) != null) { ddlDistrict.Items.FindByText(SubCountyBOobj.DistrictName.ToString()).Selected = true; } BindCounties(ddlDistrict.SelectedItem.Value); if (ddlCounty.Items.FindByText(SubCountyBOobj.CountyName.ToString()) != null) { ddlCounty.Items.FindByText(SubCountyBOobj.CountyName.ToString()).Selected = true; } SubCountyBOobj = null; SubCountyBLLobj = null; }
/// <summary> /// Set edit mode for edit comand /// Delete data from the database for delete comand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdSubcounty_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ViewState["SUBCOUNTYID"] = e.CommandArgument; GetSubCountyById(); SetUpdateMode(true); pnlSubCountyDetails.Visible = true; pnlSearch.Visible = false; } else if (e.CommandName == "DeleteRow") { // ViewState["CDAPBUDGETID"] = e.CommandArgument; SubCountyBLL SubCountyBLLobj = new SubCountyBLL(); message = SubCountyBLLobj.DeleteSubCounty(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } SetUpdateMode(false); BindGrid(); ClearData(); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param> private void BindGrid() { int COUNTYID = Convert.ToInt32(ddlCounty.SelectedValue); SubCountyBLL SubCountyBLLobj = new SubCountyBLL(); grdSubcounty.DataSource = SubCountyBLLobj.GetAllSubCounties(COUNTYID); grdSubcounty.DataBind(); }
/// <summary> /// Search banks data from the database and set filterd data to Grid Data source /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void searchBind(string subCounty) { SubCountyBLL subCountyBLLobj = new SubCountyBLL(); grdSubcounty.DataSource = subCountyBLLobj.GetSubCounties(subCounty); grdSubcounty.DataBind(); //ddlDistrictSearch.ClearSelection(); txtSearchSubcounty.Text = string.Empty; }
/// <summary> /// Save and Update Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UpdateBudgetItem() { SubCountyBLL SubCountyBLLobj = new SubCountyBLL(); SubCountyBO objSubCountyBO = new SubCountyBO(); string message = ""; try { if (ViewState["SUBCOUNTYID"] != null) { objSubCountyBO.SubCountyID = Convert.ToInt32(ViewState["SUBCOUNTYID"].ToString()); } string uID = string.Empty; uID = Session["USER_ID"].ToString(); objSubCountyBO.DistrictID = Convert.ToInt32(ddlDistrict.SelectedItem.Value); objSubCountyBO.CountyID = Convert.ToInt32(ddlCounty.SelectedItem.Value); objSubCountyBO.SubCountyName = txtSubcounty.Text.Trim(); objSubCountyBO.CreatedBy = Convert.ToInt32(uID); message = SubCountyBLLobj.UpdateSubCounty(objSubCountyBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } ClearData(); SetUpdateMode(false); BindGrid(); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { SubCountyBLLobj = null; } }
/// <summary> /// Save and Update Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SaveBudgetItem() { SubCountyBLL SubCountyBLLobj = new SubCountyBLL(); SubCountyBO objSubCountyBO = new SubCountyBO(); string message = ""; string uID = string.Empty; uID = Session["USER_ID"].ToString(); // objSubCountyBO.DistrictID = Convert.ToInt32(ddlDistrict.SelectedItem.Value); objSubCountyBO.CountyID = Convert.ToInt32(ddlCounty.SelectedItem.Value); if (txtSubcounty.Text != "") { objSubCountyBO.SubCountyName = txtSubcounty.Text.Trim(); } objSubCountyBO.CreatedBy = Convert.ToInt32(uID); try { message = SubCountyBLLobj.AddSubCounty(objSubCountyBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } ClearData(); BindGrid(); } catch (Exception ee) { throw ee; } finally { SubCountyBLLobj = null; } }