/// <summary> /// Get the details /// </summary> private void GetWelfareIndicatorDetails() { WelfareIndicatorBLL objWelfareIndicatorBLL = new WelfareIndicatorBLL(); int WelfareIndicatorID = 0; if (ViewState["WelfareIndicatorID"] != null) { WelfareIndicatorID = Convert.ToInt32(ViewState["WelfareIndicatorID"]); } WelfareIndicatorBO objWelfareIndicatorBO = new WelfareIndicatorBO(); objWelfareIndicatorBO = objWelfareIndicatorBLL.GetWelfareIndicatorById(WelfareIndicatorID); txtWelfareIndicator.Text = objWelfareIndicatorBO.Wlf_indicatorname; rbtnfield.ClearSelection(); if (rbtnfield.Items.FindByText(objWelfareIndicatorBO.Fieldtype) != null) { rbtnfield.Items.FindByText(objWelfareIndicatorBO.Fieldtype).Selected = true; } ddlAssociatedWith.ClearSelection(); if (ddlAssociatedWith.Items.FindByValue(objWelfareIndicatorBO.AssociatedWith.ToString()) != null) { ddlAssociatedWith.Items.FindByValue(objWelfareIndicatorBO.AssociatedWith.ToString()).Selected = true; } ViewState["WelfareIndicatorID"] = objWelfareIndicatorBO.Wlf_indicatorID; }
/// <summary> /// Delete the data /// </summary> private void DeleteWelfareIndicator() { WelfareIndicatorBLL objWelfareIndicatorBLL = new WelfareIndicatorBLL(); int WelfareIndicatorID = 0; string message = string.Empty; try { if (ViewState["WelfareIndicatorID"] != null) { WelfareIndicatorID = Convert.ToInt32(ViewState["WelfareIndicatorID"].ToString()); } message = objWelfareIndicatorBLL.DeleteWelfareIndicator(WelfareIndicatorID); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Deleted successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } BindGrid(); } catch (Exception ex) { throw ex; } }
/// <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; ViewState["WelfareIndicatorID"] = ((Literal)gr.FindControl("litUserID")).Text; WelfareIndicatorBLL objWelfareIndicatorBLL = new WelfareIndicatorBLL(); message = objWelfareIndicatorBLL.ObsoleteWelfareIndicator(Convert.ToInt32(ViewState["WelfareIndicatorID"]), Convert.ToString(chk.Checked)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } BindGrid(); } catch (Exception ex) { throw ex; } }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param> private void BindGrid() { WelfareIndicatorBLL objWelfareIndicatorBLL = new WelfareIndicatorBLL(); grdWelfareIndicator.DataSource = objWelfareIndicatorBLL.GetWelfareIndicator(); grdWelfareIndicator.DataBind(); ListItem firstItem = new ListItem(ddlAssociatedWith.Items[0].Text, ddlAssociatedWith.Items[0].Value); ddlAssociatedWith.DataSource = objWelfareIndicatorBLL.GetWelfareIndicator(); ddlAssociatedWith.DataTextField = "Wlf_indicatorname"; ddlAssociatedWith.DataValueField = "Wlf_indicatorID"; ddlAssociatedWith.DataBind(); ddlAssociatedWith.Items.Insert(0, firstItem); }
/// <summary> /// Save and Update Data into Database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string message = ""; WelfareIndicatorBLL objWelfareIndicatorBLL = new WelfareIndicatorBLL(); if (Convert.ToInt32(ViewState["WelfareIndicatorID"]) == 0) { try { string uID = Session["USER_ID"].ToString(); WelfareIndicatorBO objWelfareIndicatorBO = new WelfareIndicatorBO(); objWelfareIndicatorBO.Wlf_indicatorname = txtWelfareIndicator.Text.ToString().Trim(); objWelfareIndicatorBO.Fieldtype = rbtnfield.SelectedItem.ToString(); objWelfareIndicatorBO.AssociatedWith = Convert.ToInt32(ddlAssociatedWith.SelectedItem.Value); objWelfareIndicatorBO.UserID = Convert.ToInt32(uID); message = objWelfareIndicatorBLL.InsertWelfareIndicator(objWelfareIndicatorBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { objWelfareIndicatorBLL = null; } BindGrid(); } //edit the data in the textbox exiting in the Grid else if (Convert.ToInt32(ViewState["WelfareIndicatorID"]) > 0) { try { string uID = Session["USER_ID"].ToString(); WelfareIndicatorBO objWelfareIndicatorBO = new WelfareIndicatorBO(); objWelfareIndicatorBO.Wlf_indicatorname = txtWelfareIndicator.Text.ToString().Trim(); objWelfareIndicatorBO.Fieldtype = rbtnfield.SelectedItem.ToString(); objWelfareIndicatorBO.AssociatedWith = Convert.ToInt32(ddlAssociatedWith.SelectedItem.Value); objWelfareIndicatorBO.Wlf_indicatorID = Convert.ToInt32(ViewState["WelfareIndicatorID"]); objWelfareIndicatorBO.UserID = Convert.ToInt32(uID); message = objWelfareIndicatorBLL.UpdateWelfareIndicator(objWelfareIndicatorBO); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } finally { objWelfareIndicatorBLL = null; } BindGrid(); SetUpdateMode(false); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } ClearData(); }