/// <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 get the LivelihoodItems
/// </summary>
private void GetLivelihoodItems()
{
PAPliveliwoodAfterBLL objLivelihoodBLL = new PAPliveliwoodAfterBLL();
LivelihoodItems = objLivelihoodBLL.GetLivelihoodItemsByID(Convert.ToInt32(Session["HH_ID"]));
grdPAPLiveTotal.DataSource = LivelihoodItems;
grdPAPLiveTotal.DataBind();
}
/// <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();
}
/// <summary>
/// To Update Livelihood
/// </summary>
/// <param name="LivelihoodItems"></param>
public string UpdateLivelihood(PAPliveliwoodAfterList LivelihoodItems)
{
cnn = new OracleConnection(con);
string returnResult = string.Empty;
proc = "USP_TRN_UPD_LIVELIHOODAFTER";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("ID_", "");
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_", "");
cmd.Parameters.Add("CAPTUREDDATE_", "");
cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
foreach (PAPLiveliwoodAfter objLivelihood in LivelihoodItems)
{
cmd.Parameters["ID_"].Value = objLivelihood.LID;
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.Parameters["CAPTUREDDATE_"].Value = Convert.ToDateTime(objLivelihood.CAPTUREDDATE).ToString(UtilBO.DateFormatDB);
cmd.ExecuteNonQuery();
if (cmd.Parameters["errorMessage_"].Value != null && cmd.Parameters["errorMessage_"].Value.ToString().ToLower() != "null" && cmd.Parameters["errorMessage_"].Value.ToString().Trim() != "")
{
returnResult = cmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
cmd.Connection.Close();
return(returnResult);
}
protected void grdLivelihoodItems_RowCommand(object sender, GridViewCommandEventArgs e)
{
string message = string.Empty;
if (e.CommandName == "EditRow")
{
GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer;
Literal PapLDate = (Literal)row.FindControl("PapLDate");
string CAPTUREDDATE = PapLDate.Text.ToString();
LivelihoodItems = (new PAPliveliwoodAfterBLL()).GetLivelihoodItemsByIDCD(Convert.ToInt32(Session["HH_ID"]), CAPTUREDDATE);
grdLivelihoodItems.DataSource = LivelihoodItems;
grdLivelihoodItems.DataBind();
if (LivelihoodItems.Count > 0)
{
dpCapturedDate.Text = Convert.ToDateTime(CAPTUREDDATE).ToString(UtilBO.DateFormat);
}
SetUpdateMode(true);
//ClearDetails();
}
else if (e.CommandName == "DeleteRow")
{
GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer;
Literal PapLDate = (Literal)row.FindControl("PapLDate");
string CAPTUREDDATE = PapLDate.Text.ToString();
PAPliveliwoodAfterBLL PAPliveliwoodAfterBLLOBJ = new PAPliveliwoodAfterBLL();
message = PAPliveliwoodAfterBLLOBJ.DeleteLiveliHood(Convert.ToInt32(Session["HH_ID"]), CAPTUREDDATE);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data deleted successfully";
}
ClearDetails();
GetLivelihoodItems();
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
/// <summary>
/// to bind the livelihood Items
/// </summary>
private void BindLivelihoodItems()
{
LivelihoodItems = (new PAPliveliwoodAfterBLL()).GetLivelihood();
grdLivelihoodItems.DataSource = LivelihoodItems;
grdLivelihoodItems.DataBind();
}
/// <summary>
/// To Update Livelihood
/// </summary>
/// <param name="LivelihoodItems"></param>
public string UpdateLivelihood(PAPliveliwoodAfterList LivelihoodItems)
{
return((new PAPliveliwoodAfterDAL()).UpdateLivelihood(LivelihoodItems));
}
