/// <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> /// To Get Welfare Indicator /// </summary> /// <returns></returns> public WelfareIndicatorList GetWelfareIndicator() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETWELFARE_INDICATOR"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); WelfareIndicatorBO objWelfareIndicatorBO = null; WelfareIndicatorList OBJWelfareIndicatorList = new WelfareIndicatorList(); while (dr.Read()) { objWelfareIndicatorBO = new WelfareIndicatorBO(); objWelfareIndicatorBO.Wlf_indicatorID = dr.GetInt32(dr.GetOrdinal("wlf_indicatorid")); objWelfareIndicatorBO.Wlf_indicatorname = dr.GetString(dr.GetOrdinal("wlf_indicatorname")); objWelfareIndicatorBO.Fieldtype = dr.GetString(dr.GetOrdinal("fieldtype")); if (!dr.IsDBNull(dr.GetOrdinal("ASSOCIATEDWITH"))) { objWelfareIndicatorBO.AssociatedWith = dr.GetInt32(dr.GetOrdinal("ASSOCIATEDWITH")); } objWelfareIndicatorBO.IsDeleted = dr.GetString(dr.GetOrdinal("isdeleted")); OBJWelfareIndicatorList.Add(objWelfareIndicatorBO); } dr.Close(); return(OBJWelfareIndicatorList); }
/// <summary> /// To Update Welfare Indicator /// </summary> /// <param name="objWelfareIndicatorBO"></param> /// <returns></returns> public string UpdateWelfareIndicator(WelfareIndicatorBO objWelfareIndicatorBO) { string result = ""; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDWELFARE_INDICATOR", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("WLF_INDICATORID_", objWelfareIndicatorBO.Wlf_indicatorID); dcmd.Parameters.Add("WLF_INDICATORNAME_", objWelfareIndicatorBO.Wlf_indicatorname); dcmd.Parameters.Add("FIELDTYPE_", objWelfareIndicatorBO.Fieldtype); if (objWelfareIndicatorBO.AssociatedWith > 0) { dcmd.Parameters.Add("ASSOCIATEDWITH_", objWelfareIndicatorBO.AssociatedWith); } else { dcmd.Parameters.Add("ASSOCIATEDWITH_", DBNull.Value); } dcmd.Parameters.Add("UPDATEDBY_", objWelfareIndicatorBO.UserID); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { result = dcmd.Parameters["errorMessage_"].Value.ToString(); } return(result); } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } }
/// <summary> /// To Update Welfare Indicator /// </summary> /// <param name="objWelfareIndicatorBO"></param> /// <returns></returns> public string UpdateWelfareIndicator(WelfareIndicatorBO objWelfareIndicatorBO) { WelfareIndicatorDAL objWelfareIndicatorDAL = new WelfareIndicatorDAL(); //Data pass -to Database Layer try { return(objWelfareIndicatorDAL.UpdateWelfareIndicator(objWelfareIndicatorBO)); } catch { throw; } finally { objWelfareIndicatorDAL = null; } }
/// <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(); }