/// <summary> /// To Get Livelihood Items By ID /// </summary> /// <param name="householdID"></param> /// <returns></returns> public PAP_LivelihoodList GetLivelihoodItemsByID(int householdID) { proc = "USP_TRN_GET_LIVELIHOODITEMS"; cnn = new OracleConnection(con); PAP_LivelihoodList LivelihoodItems = new PAP_LivelihoodList(); PAP_LivelihoodBO objLivelihood = null; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("HOUSEHOLDID_", householdID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objLivelihood = new PAP_LivelihoodBO(); if (!dr.IsDBNull(dr.GetOrdinal("LIVELIHOOD_ITEMID"))) { objLivelihood.LivelihoodItemID = dr.GetInt32(dr.GetOrdinal("LIVELIHOOD_ITEMID")); } if (!dr.IsDBNull(dr.GetOrdinal("HHID"))) { objLivelihood.HouseHoldID = dr.GetInt32(dr.GetOrdinal("HHID")); } if (!dr.IsDBNull(dr.GetOrdinal("CASH"))) { objLivelihood.Cash = dr.GetDecimal(dr.GetOrdinal("CASH")); } if (!dr.IsDBNull(dr.GetOrdinal("INKIND"))) { objLivelihood.InKind = dr.GetString(dr.GetOrdinal("INKIND")); } LivelihoodItems.Add(objLivelihood); } dr.Close(); } catch (Exception ex) { throw ex; } return(LivelihoodItems); }
/// <summary> /// to save the data to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { LivelihoodItems = new PAP_LivelihoodList(); PAP_LivelihoodBO objLivelihood = null; foreach (GridViewRow grdRow in grdLivelihoodItems.Rows) { if (grdRow.RowType == DataControlRowType.DataRow) { string itemID = ((Literal)(grdRow.FindControl("litItemID"))).Text; TextBox txtCash = (TextBox)grdRow.FindControl("txtCash"); TextBox txtInKind = (TextBox)grdRow.FindControl("txtInKind"); objLivelihood = new PAP_LivelihoodBO(); objLivelihood.LivelihoodItemID = Convert.ToInt32(itemID); objLivelihood.HouseHoldID = Convert.ToInt32(Session["HH_ID"]); if (txtCash.Text.Trim() != "") { objLivelihood.Cash = Convert.ToDecimal(txtCash.Text.Trim()); } objLivelihood.InKind = txtInKind.Text.Trim(); objLivelihood.CreatedBy = Convert.ToInt32(Session["USER_ID"]); objLivelihood.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); LivelihoodItems.Add(objLivelihood); } } PAP_LivelihoodBLL objLivelihoodBLL = new PAP_LivelihoodBLL(); objLivelihoodBLL.UpdateLivelihood(LivelihoodItems); // ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "UpdatedLivelihood", "alert('Livelihood details updated successfully');", true); ChangeRequestStatusPAPLivehood(); projectFrozen(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "UpdatedBank", "alert('Data saved successfully');", true); BindLivelihoodItems(); }