/// <summary> /// to fetch details /// </summary> /// <returns></returns> public LivelihoodList GetLivelihood() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETLIVELIHOOD"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); LivelihoodBO objLivelihood = null; LivelihoodList Livelihoods = new LivelihoodList(); while (dr.Read()) { objLivelihood = new LivelihoodBO(); objLivelihood.Itemid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ITEMID"))); objLivelihood.ITEMNAME = dr.GetString(dr.GetOrdinal("ITEMNAME")); Livelihoods.Add(objLivelihood); } dr.Close(); return(Livelihoods); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private string Insert() { string message = string.Empty; string uID = Session["USER_ID"].ToString(); objLivelihood = new LivelihoodBO(); objLivelihood.ITEMNAME = livelihoodTextBox.Text.ToString(); objLivelihood.Createddate = System.DateTime.Now; objLivelihood.Isdeleted = "False"; objLivelihood.Createdby = Convert.ToInt32(Session["USER_ID"]); LivelihoodBLL objLivelihoodBLL = new LivelihoodBLL(); try { message = objLivelihoodBLL.AddLivelihood(objLivelihood); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; cleardetails(); } } catch (Exception ex) { string errorMsg = ex.Message.ToString(); } finally { objLivelihoodBLL = null; } return(message); }
/// <summary> /// calls method save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; try { if (btnSave.Text == "Save") { message = Insert(); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; cleardetails(); } BindGrid(true, true); } else { string uID = Session["USER_ID"].ToString(); int itemid = Convert.ToInt32(ViewState["ITEMID"]); objLivelihood = new LivelihoodBO(); objLivelihood.ITEMNAME = livelihoodTextBox.Text.ToString(); objLivelihood.Createdby = Convert.ToInt32(uID); LivelihoodBLL objLivelihoodBLL = new LivelihoodBLL(); message = objLivelihoodBLL.UpdateLivelihood(objLivelihood, itemid); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; // ClearDetails(); cleardetails(); BindGrid(true, true); SetUpdateMode(false); } //BindGrid(true, true); //cleardetails(); } btnSave.Text = "Save"; } catch (Exception ex) { string errorMsg = ex.Message.ToString(); Response.Write(errorMsg); } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); }
/// <summary> /// To Update Livelihood /// </summary> /// <param name="objLivelihood"></param> /// <param name="itemid"></param> /// <returns></returns> public string UpdateLivelihood(LivelihoodBO objLivelihood, int itemid) { LivelihoodDAL objLivelihoodDAL = new LivelihoodDAL(); try { return(objLivelihoodDAL.UpdateLivelihood(objLivelihood, itemid)); } catch (Exception ex) { throw ex; } finally { objLivelihood = null; } }
/// <summary> /// To Add Livelihood /// </summary> /// <param name="objLivelihood"></param> /// <returns></returns> public string AddLivelihood(LivelihoodBO objLivelihood) { LivelihoodDAL objLivelihoodDAL = new LivelihoodDAL(); //Data pass -to Database Layer try { return(objLivelihoodDAL.AddLivelihood(objLivelihood)); } catch (Exception ex) { throw ex; } finally { objLivelihoodDAL = null; } }
public string AddLivelihood(LivelihoodBO objLivelihood) { string returnResult = string.Empty; OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); con.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_INSERTLIVELIHOOD", con); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("L_itemname", objLivelihood.ITEMNAME); dcmd.Parameters.Add("L_createdby", objLivelihood.Createdby); //return dcmd.ExecuteNonQuery(); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { returnResult = dcmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } } catch (Exception ex) { throw ex;; } finally { dcmd.Dispose(); con.Close(); con.Dispose(); } return(returnResult); }