/// <summary>
/// to fetch details
/// </summary>
/// <returns></returns>
public PAPliveliwoodAfterList 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);
PAPLiveliwoodAfter objLivelihood = null;
PAPliveliwoodAfterList Livelihoods = new PAPliveliwoodAfterList();
while (dr.Read())
{
objLivelihood = new PAPLiveliwoodAfter();
objLivelihood.LivelihoodItemID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ITEMID")));
objLivelihood.ITEMNAME = dr.GetString(dr.GetOrdinal("ITEMNAME"));
Livelihoods.Add(objLivelihood);
}
dr.Close();
return(Livelihoods);
}
public PAPliveliwoodAfterList GetLivelihoodItemsByIDCD(int householdID, string CaptDate)
{
proc = "USP_TRN_GET_LIVHOODABYID";
cnn = new OracleConnection(con);
PAPliveliwoodAfterList LivelihoodItems = new PAPliveliwoodAfterList();
PAPLiveliwoodAfter objLivelihood = null;
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HOUSEHOLDID_", householdID);
cmd.Parameters.Add("CAPTUREDDATE_", Convert.ToDateTime(CaptDate).ToString(UtilBO.DateFormatDB));
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 PAPLiveliwoodAfter();
if (!dr.IsDBNull(dr.GetOrdinal("ID")))
{
objLivelihood.LID = dr.GetInt32(dr.GetOrdinal("ID"));
}
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"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CAPTUREDDATE")))
{
objLivelihood.CAPTUREDDATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("CAPTUREDDATE")));
}
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 PAPliveliwoodAfterList();
PAPLiveliwoodAfter objLivelihood = null;
int id = 0;
foreach (GridViewRow grdRow in grdLivelihoodItems.Rows)
{
if (grdRow.RowType == DataControlRowType.DataRow)
{
string LivelihoodItemID = ((Literal)(grdRow.FindControl("litItemID"))).Text;
string LID = ((Literal)(grdRow.FindControl("litID"))).Text;
TextBox txtCash = (TextBox)grdRow.FindControl("txtCash");
TextBox txtInKind = (TextBox)grdRow.FindControl("txtInKind");
objLivelihood = new PAPLiveliwoodAfter();
id = Convert.ToInt32(LID);
objLivelihood.LID = Convert.ToInt32(LID);
objLivelihood.LivelihoodItemID = Convert.ToInt32(LivelihoodItemID);
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"]);
if (dpCapturedDate.Text.Trim() != "")
{
objLivelihood.CAPTUREDDATE = Convert.ToDateTime(dpCapturedDate.Text);
}
LivelihoodItems.Add(objLivelihood);
}
}
PAPliveliwoodAfterBLL objLivelihoodBLL = new PAPliveliwoodAfterBLL();
string message = objLivelihoodBLL.UpdateLivelihood(LivelihoodItems);
if (message == "")
{
if (id == 0)
{
message = "Data saved successfully";
}
else
{
message = "Data Updated successfully";
}
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "UpdatedBank", "alert('" + message + "');", true);
SetUpdateMode(false);
ClearDetails();
GetLivelihoodItems();
}
private void GetLivelihoodByIDCD(PAPLiveliwoodAfter objLivelihood)
{
PAPliveliwoodAfterBLL objLivelihoodBLL = new PAPliveliwoodAfterBLL();
grdPAPLiveTotal.DataSource = objLivelihoodBLL.GetLivelihoodItemsByID(objLivelihood.HouseHoldID);
}
