/// <summary>
/// To Update Livelihood
/// </summary>
/// <param name="LivelihoodItems"></param>
public void UpdateLivelihood(PAP_LivelihoodList LivelihoodItems)
{
cnn = new OracleConnection(con);
proc = "USP_TRN_UPD_LIVELIHOOD";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("LIVELIHOOD_ITEMID_", "");
cmd.Parameters.Add("HOUSEHOLDID_", "");
cmd.Parameters.Add("CASH_", "");
cmd.Parameters.Add("INKIND_", "");
cmd.Parameters.Add("CREATEDBY_", "");
cmd.Parameters.Add("UPDATEDBY_", "");
foreach (PAP_LivelihoodBO objLivelihood in LivelihoodItems)
{
cmd.Parameters["LIVELIHOOD_ITEMID_"].Value = objLivelihood.LivelihoodItemID;
cmd.Parameters["HOUSEHOLDID_"].Value = objLivelihood.HouseHoldID;
cmd.Parameters["CASH_"].Value = objLivelihood.Cash;
cmd.Parameters["INKIND_"].Value = objLivelihood.InKind;
cmd.Parameters["CREATEDBY_"].Value = objLivelihood.CreatedBy;
cmd.Parameters["UPDATEDBY_"].Value = objLivelihood.UpdatedBy;
cmd.ExecuteNonQuery();
}
cmd.Connection.Close();
}
/// <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();
}
/// <summary>
/// To get the LivelihoodItems
/// </summary>
private void GetLivelihoodItems()
{
PAP_LivelihoodBLL objLivelihoodBLL = new PAP_LivelihoodBLL();
LivelihoodItems = objLivelihoodBLL.GetLivelihoodItemsByID(Convert.ToInt32(Session["HH_ID"]));
}
/// <summary>
/// To Get Livelihood Items
/// </summary>
private void GetLivelihoodItems()
{
PAP_LivelihoodBLL objLivelihoodBLL = new PAP_LivelihoodBLL();
LivelihoodItems = objLivelihoodBLL.GetLivelihoodItemsByID(Convert.ToInt32(ViewState["HHID"]));
}
/// <summary>
/// To Update Livelihood
/// </summary>
/// <param name="LivelihoodItems"></param>
public void UpdateLivelihood(PAP_LivelihoodList LivelihoodItems)
{
(new PAP_LivelihoodDAL()).UpdateLivelihood(LivelihoodItems);
}
