/// <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 grdParish_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ViewState["PARISHID"] = e.CommandArgument; SetUpdateMode(true); GetParishById(); pnlDistrictDetails.Visible = true; pnlSearch.Visible = false; } else if (e.CommandName == "DeleteRow") { // ViewState["CDAPBUDGETID"] = e.CommandArgument; ParishBLL ParishBLLobj = new ParishBLL(); message = ParishBLLobj.DeleteParish(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } SetUpdateMode(false); ClearData(); BindGrid(); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }
/// <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 PARISHID = ((Literal)gr.FindControl("litPARISHID")).Text; ParishBLL ParishBLLobj = new ParishBLL(); message = ParishBLLobj.ObsoleteParish(Convert.ToInt32(PARISHID), 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> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid() { int subcountyid = Convert.ToInt32(ddlsubcounty.SelectedValue); int countyid = Convert.ToInt32(ddlCounty.SelectedValue); int districtid = Convert.ToInt32(ddlDistrict.SelectedValue); ParishBLL ParishBLLobj = new ParishBLL(); grdParish.DataSource = ParishBLLobj.GetAllParish(subcountyid, countyid, districtid); grdParish.DataBind(); }
/// <summary> /// Show search county Panel and hide Add panel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSearch_Click(object sender, EventArgs e) { string SearchParish = "0"; if (TxtSearchParish.Text != string.Empty) { SearchParish = TxtSearchParish.Text.ToString(); } ParishBLL ParishBLLobj = new ParishBLL(); grdParish.DataSource = ParishBLLobj.SearchParish(SearchParish); grdParish.DataBind(); }
/// <summary> /// To update details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UpdateParish() { ParishBLL ParishBLLobj = new ParishBLL(); ParishBO ParishBOobj = new ParishBO(); string message = ""; try { if (ViewState["PARISHID"] != null) { ParishBOobj.ParishId = Convert.ToInt32(ViewState["PARISHID"].ToString()); } string uID = string.Empty; uID = Session["USER_ID"].ToString(); ParishBOobj.SubcountyID = Convert.ToInt32(ddlsubcounty.SelectedItem.Value); ParishBOobj.ParishName = txtParish.Text.Trim(); ParishBOobj.UpdatedBy = Convert.ToInt32(uID); message = ParishBLLobj.UpdateParish(ParishBOobj); 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 { ParishBLLobj = null; } }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SaveParish() { ParishBLL ParishBLLobj = new ParishBLL(); ParishBO ParishBOobj = new ParishBO(); string message = ""; string uID = string.Empty; uID = Session["USER_ID"].ToString(); ParishBOobj.SubcountyID = Convert.ToInt32(ddlsubcounty.SelectedItem.Value); ParishBOobj.ParishName = txtParish.Text.Trim(); ParishBOobj.CreatedBy = Convert.ToInt32(uID); try { message = ParishBLLobj.AddParish(ParishBOobj); 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 { ParishBLLobj = null; } }
/// <summary> /// To fetch data from database based on ParishID /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void GetParishById() { ParishBLL ParishBLLobj = new ParishBLL(); ParishBO ParishBOobj = ParishBLLobj.GetParishById(Convert.ToInt32(ViewState["PARISHID"])); if (ParishBOobj != null) { ddlDistrict.ClearSelection(); } if (ddlDistrict.Items.FindByText(ParishBOobj.DistrictName.ToString()) != null) { ddlDistrict.Items.FindByText(ParishBOobj.DistrictName.ToString()).Selected = true; } ddlCounty.ClearSelection(); string districtID = ParishBOobj.DistrictID.ToString(); BindCounties(districtID); if (ddlCounty.Items.FindByText(ParishBOobj.countyName.ToString()) != null) { ddlCounty.Items.FindByText(ParishBOobj.countyName.ToString()).Selected = true; } ddlsubcounty.ClearSelection(); string countyID = ParishBOobj.CountyID.ToString(); BindSubCounties(countyID); if (ddlsubcounty.Items.FindByText(ParishBOobj.subcountyName.ToString()) != null) { ddlsubcounty.Items.FindByText(ParishBOobj.subcountyName.ToString()).Selected = true; } txtParish.Text = ParishBOobj.ParishName; ParishBOobj = null; ParishBLLobj = null; }