/// <summary>
/// to fetch details by ID
/// </summary>
/// <param name="LivRestPlanId"></param>
/// <returns></returns>
public LivelihoodRestorationList GetLivelihoodRestReceivedByPlanId(int LivRestPlanId)
{
OracleConnection cnn = new OracleConnection(con);
OracleCommand cmd;
string proc = "USP_TRN_GET_PAP_LIV_REST_RECEI";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Liv_Rest_PlanID_", LivRestPlanId);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
LivelihoodRestorationBO objLivelihoodRestorationBO = null;
LivelihoodRestorationList oLivelihoodRestorationList = new LivelihoodRestorationList();
objLivelihoodRestorationBO = new LivelihoodRestorationBO();
while (dr.Read())
{
objLivelihoodRestorationBO = MapData(dr);
oLivelihoodRestorationList.Add(objLivelihoodRestorationBO);
}
dr.Close();
return(oLivelihoodRestorationList);
}
/// <summary>
/// to add data
/// </summary>
/// <param name="oLiveRestPlanBO"></param>
/// <returns></returns>
public string AddLiveReceivedPlan(LivelihoodRestorationBO oLiveRestPlanBO)
{
string returnResult = string.Empty;
LivelihoodRestorationBO ooLiveRestPlanBO = new LivelihoodRestorationBO();//For Storing & Returning Result as Object
OracleConnection OCon = new OracleConnection(con);
OCon.Open();
OracleCommand oCmd = new OracleCommand("USP_TRN_INS_PAP_LIV_REST_RECEI", OCon);
oCmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(oCmd.CommandType);
try
{
oCmd.Parameters.Add("liv_rest_recdid_", oLiveRestPlanBO.Liv_Rest_RecdID);
oCmd.Parameters.Add("liv_rest_planid_", oLiveRestPlanBO.Liv_Rest_PlanID);
//oCmd.Parameters.Add("Liv_Rest_ItemID_", oLiveRestPlanBO.Liv_Rest_ItemID);
//oCmd.Parameters.Add("UnitID_", oLiveRestPlanBO.UnitID);
//oCmd.Parameters.Add("Planned_", oLiveRestPlanBO.Planned);
oCmd.Parameters.Add("datereceived_", oLiveRestPlanBO.ReceivedDate);
oCmd.Parameters.Add("Received_", oLiveRestPlanBO.Received);
oCmd.Parameters.Add("isdeleted_", oLiveRestPlanBO.IsDeleted);
oCmd.Parameters.Add("createdby_", oLiveRestPlanBO.CreatedBy);
oCmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
//oCmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
oCmd.ExecuteNonQuery();
if (oCmd.Parameters["errorMessage_"].Value != null)
{
returnResult = oCmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch
{
throw;
}
finally
{
oCmd.Dispose();
OCon.Close();
OCon.Dispose();
}
return(returnResult);
}
/// <summary>
/// to delete data
/// </summary>
/// <param name="LiveRestPlanId"></param>
/// <returns></returns>
public string DeleteLivRestPlan(int LiveRestPlanId)
{
string returnResult = string.Empty;
LivelihoodRestorationBO ooLiveRestPlanBO = new LivelihoodRestorationBO();//For Storing & Returning Result as Object
OracleConnection OCon = new OracleConnection(con);
OCon.Open();
OracleCommand oCmd = new OracleCommand("USP_TRN_DEL_PAP_LIV_REST_PLAN", OCon);
oCmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(oCmd.CommandType);
try
{
oCmd.Parameters.Add("Liv_Rest_PlanID_", LiveRestPlanId);
oCmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
//oCmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
oCmd.ExecuteNonQuery();
if (oCmd.Parameters["errorMessage_"].Value != null)
{
returnResult = oCmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch
{
throw;
}
finally
{
oCmd.Dispose();
OCon.Close();
OCon.Dispose();
}
return(returnResult);
}
/// <summary>
/// to delete data
/// </summary>
/// <param name="ReceivedId"></param>
/// <returns></returns>
public string DeleteItemReceived(int ReceivedId)
{
string returnResult = string.Empty;
LivelihoodRestorationBO ooLiveRestPlanBO = new LivelihoodRestorationBO();//For Storing & Returning Result as Object
OracleConnection OCon = new OracleConnection(con);
OCon.Open();
OracleCommand oCmd = new OracleCommand("USP_TRN_DEL_PAP_LIV_REST_RECEI", OCon);
oCmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(oCmd.CommandType);
try
{
oCmd.Parameters.Add("liv_rest_recdid_", ReceivedId);
oCmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
oCmd.ExecuteNonQuery();
if (oCmd.Parameters["errorMessage_"].Value != null)
{
returnResult = oCmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch
{
throw;
}
finally
{
oCmd.Dispose();
OCon.Close();
OCon.Dispose();
}
return(returnResult);
}
/// <summary>
/// To Update Livelihood Restoration Plan
/// </summary>
/// <param name="oLiveRestPlanBO"></param>
/// <returns></returns>
public string UpdateLivelihoodRestorationPlan(LivelihoodRestorationBO oLiveRestPlanBO)
{
oLiveRestPlanDAL = new LivelihoodRestorationPlanDAL();
return(oLiveRestPlanDAL.UpdateLiveRestPlan(oLiveRestPlanBO));
}
/// <summary>
/// To Add Live Received Plan
/// </summary>
/// <param name="oLiveRestPlanBO"></param>
/// <returns></returns>
public string AddLiveReceivedPlan(LivelihoodRestorationBO oLiveRestPlanBO)
{
oLiveRestPlanDAL = new LivelihoodRestorationPlanDAL();
return(oLiveRestPlanDAL.AddLiveReceivedPlan(oLiveRestPlanBO));
}
private LivelihoodRestorationBO MapData(IDataReader reader)
{
LivelihoodRestorationBO oLiveRestPlanBO = new LivelihoodRestorationBO();
if (ColumnExists(reader, "Liv_Rest_PlanID") && !reader.IsDBNull(reader.GetOrdinal("Liv_Rest_PlanID")))
{
oLiveRestPlanBO.Liv_Rest_PlanID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Liv_Rest_PlanID")));
}
//if (ColumnExists(reader, "HHID") && !reader.IsDBNull(reader.GetOrdinal("HHID")))
// oLiveRestPlanBO.HHID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("HHID")));
if (ColumnExists(reader, "Liv_Rest_LocationID") && !reader.IsDBNull(reader.GetOrdinal("Liv_Rest_LocationID")))
{
oLiveRestPlanBO.Liv_Rest_LocationID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Liv_Rest_LocationID")));
}
if (ColumnExists(reader, "Liv_Rest_ItemID") && !reader.IsDBNull(reader.GetOrdinal("Liv_Rest_ItemID")))
{
oLiveRestPlanBO.Liv_Rest_ItemID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Liv_Rest_ItemID")));
}
if (ColumnExists(reader, "UnitID") && !reader.IsDBNull(reader.GetOrdinal("UnitID")))
{
oLiveRestPlanBO.UnitID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("UnitID")));
}
if (ColumnExists(reader, "Planned") && !reader.IsDBNull(reader.GetOrdinal("Planned")))
{
oLiveRestPlanBO.Planned = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("Planned")));
}
if (ColumnExists(reader, "PlannedDate") && !reader.IsDBNull(reader.GetOrdinal("PlannedDate")))
{
oLiveRestPlanBO.PlannedDate = Convert.ToDateTime(reader.GetDateTime(reader.GetOrdinal("PlannedDate")).ToString(UtilBO.DateFormat));
}
if (ColumnExists(reader, "Received") && !reader.IsDBNull(reader.GetOrdinal("Received")))
{
oLiveRestPlanBO.Received = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("Received")));
}
if (ColumnExists(reader, "DATERECEIVED") && !reader.IsDBNull(reader.GetOrdinal("DATERECEIVED")))
{
oLiveRestPlanBO.ReceivedDate = Convert.ToDateTime(reader.GetDateTime(reader.GetOrdinal("DATERECEIVED")).ToString(UtilBO.DateFormat));
}
//Convert.ToDateTime(reader.GetDateTime(reader.GetOrdinal("DATERECEIVED")));
if (ColumnExists(reader, "UnitName") && !reader.IsDBNull(reader.GetOrdinal("UnitName")))
{
oLiveRestPlanBO.UnitName = reader.GetString(reader.GetOrdinal("UnitName"));
}
if (ColumnExists(reader, "ItemName") && !reader.IsDBNull(reader.GetOrdinal("ItemName")))
{
oLiveRestPlanBO.ItemName = reader.GetString(reader.GetOrdinal("ItemName"));
}
if (ColumnExists(reader, "Liv_Rest_RecdID") && !reader.IsDBNull(reader.GetOrdinal("Liv_Rest_RecdID")))
{
oLiveRestPlanBO.Liv_Rest_RecdID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Liv_Rest_RecdID")));
}
if (ColumnExists(reader, "UNITPRICE") && !reader.IsDBNull(reader.GetOrdinal("UNITPRICE")))
{
oLiveRestPlanBO.UnitPrice = Convert.ToDecimal(reader.GetValue(reader.GetOrdinal("UNITPRICE")));
}
return(oLiveRestPlanBO);
}
