/// <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); }