// get the Grid value into textBox private void GetSocialPAPConcernDetails() { SocioConcernBLL ConcernBLLobj = new SocioConcernBLL(); int PapConcernID = 0; if (ViewState["PapConcernID"] != null) { PapConcernID = Convert.ToInt32(ViewState["PapConcernID"]); } int HHID = Convert.ToInt32(Session["HH_ID"].ToString()); SocioConcernBO SocioConcernBOObj = new SocioConcernBO(); SocioConcernBOObj = ConcernBLLobj.GetSocioConcernById(PapConcernID, HHID); PAPConcernsDropDownList.ClearSelection(); if (PAPConcernsDropDownList.Items.FindByValue(SocioConcernBOObj.ConcernID.ToString()) != null) { PAPConcernsDropDownList.Items.FindByValue(SocioConcernBOObj.ConcernID.ToString()).Selected = true; } PAPOtherConcernsTextBox.Text = SocioConcernBOObj.OtherConcern.ToString(); PAPConcernsIDTextBox.Text = SocioConcernBOObj.PapConcernID.ToString(); }
/// <summary> /// for Edit and Delete Command /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdSocioConcerns_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ViewState["PapConcernID"] = e.CommandArgument; GetSocialPAPConcernDetails(); SetUpdateMode(true); } else if (e.CommandName == "DeleteRow") { ViewState["PapConcernID"] = e.CommandArgument; SocioConcernBLL SocioConcernBLLobj = new SocioConcernBLL(); int HHID = Convert.ToInt32(Session["HH_ID"].ToString()); message = SocioConcernBLLobj.DeleteSocialConcern(Convert.ToInt32(ViewState["PapConcernID"]), HHID); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Deleted successfully"; } clear(); SetUpdateMode(false); BindGrid(); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }
/// <summary> /// to bind the grid /// </summary> private void BindGrid() { SocioConcernBLL objSocioConcernBLL = new SocioConcernBLL(); SocioConcernList objSocioConcernList = new SocioConcernList(); int HHID = Convert.ToInt32(Session["HH_ID"].ToString()); objSocioConcernList = objSocioConcernBLL.getSocioConcern(HHID); grdSocioConcerns.DataSource = objSocioConcernList; grdSocioConcerns.DataBind(); }
/// <summary> /// to save the data /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string message = string.Empty; string AlertMessage = string.Empty; string uID = Session["USER_ID"].ToString(); string HHID = Session["HH_ID"].ToString(); SocioConcernBO objSocioConcern = new SocioConcernBO(); if (PAPConcernsIDTextBox.Text != "0") { objSocioConcern.PapConcernID = Convert.ToInt32(ViewState["PapConcernID"]); objSocioConcern.ConcernID = Convert.ToInt32(PAPConcernsDropDownList.SelectedItem.Value.ToString().Trim()); string strMax = PAPOtherConcernsTextBox.Text.Trim(); if (strMax.Trim().Length >= 500) { strMax = PAPOtherConcernsTextBox.Text.ToString().Trim().Substring(0, 500); } objSocioConcern.OtherConcern = strMax; objSocioConcern.UserID = Convert.ToInt32(uID); objSocioConcern.HHID = Convert.ToInt32(HHID); SocioConcernBLL SocioConcernobj = new SocioConcernBLL(); message = SocioConcernobj.EditSocioConcern(objSocioConcern); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); PAPConcernsIDTextBox.Text = "0"; BindGrid(); SetUpdateMode(false); clear(); } else { objSocioConcern.ConcernID = Convert.ToInt32(PAPConcernsDropDownList.SelectedItem.Value.ToString().Trim()); string strMax = PAPOtherConcernsTextBox.Text.Trim(); if (strMax.Trim().Length >= 500) { strMax = PAPOtherConcernsTextBox.Text.ToString().Trim().Substring(0, 500); } objSocioConcern.OtherConcern = strMax; objSocioConcern.UserID = Convert.ToInt32(uID); objSocioConcern.HHID = Convert.ToInt32(HHID); SocioConcernBLL SocioConcernobj = new SocioConcernBLL(); message = SocioConcernobj.InsertSocioConcern(objSocioConcern); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); clear(); BindGrid(); SetUpdateMode(false); } ChangeRequestStatusSocailConcerns(); projectFrozen(); }