/// <summary> /// To Add CDAP Phase Activity details /// </summary> /// <param name="objCDAPImplementationBO"></param> /// <returns></returns> public int AddCDAPPhaseActivity(CDAPImplementationBO objCDAPImplementationBO) { cnn = new OracleConnection(con); int returnResult = 0; proc = "USP_TRN_CDAP_PHASE_ACTIVITY"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("CDAP_PHASEACTIVITYID_", objCDAPImplementationBO.Cdap_phaseactivityid); cmd.Parameters.Add("CDAP_PHASEID_", objCDAPImplementationBO.Cdap_phaseid); cmd.Parameters.Add("CDAP_ACTIVITYID_", objCDAPImplementationBO.Cdap_activityid); cmd.Parameters.Add("DISTRICT_", objCDAPImplementationBO.District); cmd.Parameters.Add("COUNTY_", objCDAPImplementationBO.County); cmd.Parameters.Add("SUBCOUNTY_", objCDAPImplementationBO.SubCounty); cmd.Parameters.Add("VILLAGES_", objCDAPImplementationBO.Village); cmd.Parameters.Add("ACTIVITYDETAILS_", objCDAPImplementationBO.Activitydetails); cmd.Parameters.Add("MODEOFIMPLEMENTATION_", objCDAPImplementationBO.Modeofimplementation); cmd.Parameters.Add("CHALLENGES_", objCDAPImplementationBO.Challenges); cmd.Parameters.Add("COMMENTS_", objCDAPImplementationBO.Comments); cmd.Parameters.Add("ACTIVITYDATEFROM_", objCDAPImplementationBO.Activitydatefrom.ToString(UtilBO.DateFormatDB)); cmd.Parameters.Add("ACTIVITYDATETO_", objCDAPImplementationBO.Activitydateto.ToString(UtilBO.DateFormatDB)); cmd.Parameters.Add("UPDATEDBY_", objCDAPImplementationBO.Updatedby); returnResult = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return(returnResult); }
/// <summary> /// To Get CDAP Village by ID /// </summary> /// <param name="village"></param> /// <returns></returns> public CDAPImplementationList GetCDAPVillageID(string village) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_GET_VILLAGEID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("VILLAGES_", village); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CDAPImplementationBO obCDAPImplementationBO = null; CDAPImplementationList objCDAPImplementationList = new CDAPImplementationList(); while (dr.Read()) { obCDAPImplementationBO = new CDAPImplementationBO(); if (!dr.IsDBNull(dr.GetOrdinal("VillageID"))) { obCDAPImplementationBO.Villageid = dr.GetInt32(dr.GetOrdinal("VillageID")); } objCDAPImplementationList.Add(obCDAPImplementationBO); } dr.Close(); return(objCDAPImplementationList); }
/// <summary> /// To Add CDAP Phase to database /// </summary> /// <param name="objCDAPImplementationBO"></param> /// <returns></returns> public string AddCDAPPhase(CDAPImplementationBO objCDAPImplementationBO) { cnn = new OracleConnection(con); string result = ""; proc = "USP_TRN_CDAP_PHASE"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("CDAP_PHASEID_", objCDAPImplementationBO.Cdap_phaseid); cmd.Parameters.Add("CDAP_PHASENO_", objCDAPImplementationBO.Cdap_phaseno); cmd.Parameters.Add("CDAP_PERIODFROM_", objCDAPImplementationBO.PeriodFrom.ToString(UtilBO.DateFormatDB)); cmd.Parameters.Add("CDAP_PERIODTO_", objCDAPImplementationBO.PeriodTo.ToString(UtilBO.DateFormatDB)); cmd.Parameters.Add("PROJECTID_", objCDAPImplementationBO.ProjectedId); cmd.Parameters.Add("UPDATEDBY_", objCDAPImplementationBO.Updatedby); cmd.Parameters.Add("EXPENDITURE_", objCDAPImplementationBO.EXPENDITURE); cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); if (cmd.Parameters["errorMessage_"].Value != null) { result = cmd.Parameters["errorMessage_"].Value.ToString(); } else { result = string.Empty; } //result = cmd.Parameters["NEWPHASEID_"].Value.ToString(); cmd.Connection.Close(); return(result); }
/// <summary> /// To Add CDAP Activity PAPS details /// </summary> /// <param name="objCDAPImplementationBO"></param> /// <returns></returns> public int AddCDAPActivityPAPS(CDAPImplementationBO objCDAPImplementationBO) { cnn = new OracleConnection(con); int returnResult = 0; proc = "USP_CDAP_ACTIVITY_PAPS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection.Open(); cmd.Parameters.Add("CDAP_PHASEACTIVITYID_", objCDAPImplementationBO.Cdap_phaseactivityid); cmd.Parameters.Add("HHID_", objCDAPImplementationBO.HhId); cmd.Parameters.Add("UPDATEDBY_", objCDAPImplementationBO.Updatedby); returnResult = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return(returnResult); }
/// <summary> /// To Get CDAP Phase Details By ID /// </summary> /// <param name="PhaseID"></param> /// <returns></returns> public CDAPImplementationList GetCDAPPhaseDetailsByID(int PhaseID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_GET_TRN_CDAP_PHASESBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CDAP_PHASEID_", PhaseID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CDAPImplementationBO obCDAPImplementationBO = null; CDAPImplementationList objCDAPImplementationList = new CDAPImplementationList(); while (dr.Read()) { obCDAPImplementationBO = new CDAPImplementationBO(); if (!dr.IsDBNull(dr.GetOrdinal("CDAP_PHASENO"))) { obCDAPImplementationBO.Cdap_phaseno = dr.GetInt32(dr.GetOrdinal("CDAP_PHASENO")); } if (!dr.IsDBNull(dr.GetOrdinal("CDAP_PHASEID"))) { obCDAPImplementationBO.Cdap_phaseid = dr.GetInt32(dr.GetOrdinal("CDAP_PHASEID")); } if (!dr.IsDBNull(dr.GetOrdinal("CDAP_PERIODFROM"))) { obCDAPImplementationBO.PeriodFrom = dr.GetDateTime(dr.GetOrdinal("CDAP_PERIODFROM")); } if (!dr.IsDBNull(dr.GetOrdinal("CDAP_PERIODTO"))) { obCDAPImplementationBO.PeriodTo = dr.GetDateTime(dr.GetOrdinal("CDAP_PERIODTO")); } if (!dr.IsDBNull(dr.GetOrdinal("PROJECTID"))) { obCDAPImplementationBO.ProjectedId = dr.GetInt32(dr.GetOrdinal("PROJECTID")); } if (!dr.IsDBNull(dr.GetOrdinal("EXPENDITURE"))) { obCDAPImplementationBO.EXPENDITURE = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("EXPENDITURE"))); } objCDAPImplementationList.Add(obCDAPImplementationBO); } dr.Close(); return(objCDAPImplementationList); }
/// <summary> /// To Get CDAP PAP Details /// </summary> /// <param name="PhaseactivityID"></param> /// <returns></returns> public CDAPImplementationList GetCDAPPAPDetails(int PhaseactivityID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_GET_CDAPPLANDISPLAY"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CDAP_PHASEACTIVITYID_", PhaseactivityID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CDAPImplementationBO obCDAPImplementationBO = null; CDAPImplementationList objCDAPImplementationList = new CDAPImplementationList(); while (dr.Read()) { obCDAPImplementationBO = new CDAPImplementationBO(); // if (!dr.IsDBNull(dr.GetOrdinal("cdap_phaseid"))) obCDAPImplementationBO.Cdap_phaseid = dr.GetInt32(dr.GetOrdinal("cdap_phaseid")); // if (!dr.IsDBNull(dr.GetOrdinal("cdap_phaseno"))) obCDAPImplementationBO.Cdap_phaseno = dr.GetInt32(dr.GetOrdinal("cdap_phaseno")); // if (!dr.IsDBNull(dr.GetOrdinal("cdap_periodfrom"))) obCDAPImplementationBO.PeriodFrom = dr.GetDateTime(dr.GetOrdinal("cdap_periodfrom")); // if (!dr.IsDBNull(dr.GetOrdinal("cdap_periodto"))) obCDAPImplementationBO.PeriodTo = dr.GetDateTime(dr.GetOrdinal("cdap_periodto")); if (!dr.IsDBNull(dr.GetOrdinal("cdap_activityid"))) { obCDAPImplementationBO.Cdap_activityid = dr.GetInt32(dr.GetOrdinal("cdap_activityid")); } if (!dr.IsDBNull(dr.GetOrdinal("district"))) { obCDAPImplementationBO.District = dr.GetString(dr.GetOrdinal("district")); } if (!dr.IsDBNull(dr.GetOrdinal("county"))) { obCDAPImplementationBO.County = dr.GetString(dr.GetOrdinal("county")); } if (!dr.IsDBNull(dr.GetOrdinal("subcounty"))) { obCDAPImplementationBO.SubCounty = dr.GetString(dr.GetOrdinal("subcounty")); } if (!dr.IsDBNull(dr.GetOrdinal("villages"))) { obCDAPImplementationBO.Village = dr.GetString(dr.GetOrdinal("villages")); } if (!dr.IsDBNull(dr.GetOrdinal("activitydetails"))) { obCDAPImplementationBO.Activitydetails = dr.GetString(dr.GetOrdinal("activitydetails")); } if (!dr.IsDBNull(dr.GetOrdinal("modeofimplementation"))) { obCDAPImplementationBO.Modeofimplementation = dr.GetString(dr.GetOrdinal("modeofimplementation")); } if (!dr.IsDBNull(dr.GetOrdinal("challenges"))) { obCDAPImplementationBO.Challenges = dr.GetString(dr.GetOrdinal("challenges")); } if (!dr.IsDBNull(dr.GetOrdinal("comments"))) { obCDAPImplementationBO.Comments = dr.GetString(dr.GetOrdinal("comments")); } if (!dr.IsDBNull(dr.GetOrdinal("activitydatefrom"))) { obCDAPImplementationBO.Activitydatefrom = dr.GetDateTime(dr.GetOrdinal("activitydatefrom")); } if (!dr.IsDBNull(dr.GetOrdinal("activitydateto"))) { obCDAPImplementationBO.Activitydateto = dr.GetDateTime(dr.GetOrdinal("activitydateto")); } if (!dr.IsDBNull(dr.GetOrdinal("hhid"))) { obCDAPImplementationBO.HhId = dr.GetInt32(dr.GetOrdinal("hhid")); } objCDAPImplementationList.Add(obCDAPImplementationBO); } dr.Close(); return(objCDAPImplementationList); }
/// <summary> /// To Get CDAP Phase Activity Details /// </summary> /// <param name="prjctID"></param> /// <param name="PhaseID"></param> /// <returns></returns> public CDAPImplementationList GetCDAPPhaseActivityDetails(int prjctID, int PhaseID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_GET_PHASEACTIVITY"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("PROJECTID_", prjctID); cmd.Parameters.Add("PHASEID_", PhaseID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CDAPImplementationBO obCDAPImplementationBO = null; CDAPImplementationList objCDAPImplementationList = new CDAPImplementationList(); while (dr.Read()) { obCDAPImplementationBO = new CDAPImplementationBO(); if (!dr.IsDBNull(dr.GetOrdinal("CDAP_PHASENO"))) { obCDAPImplementationBO.Cdap_phaseno = dr.GetInt32(dr.GetOrdinal("CDAP_PHASENO")); } if (!dr.IsDBNull(dr.GetOrdinal("CDAP_PERIODFROM"))) { obCDAPImplementationBO.PeriodFrom = dr.GetDateTime(dr.GetOrdinal("CDAP_PERIODFROM")); } if (!dr.IsDBNull(dr.GetOrdinal("CDAP_PERIODTO"))) { obCDAPImplementationBO.PeriodTo = dr.GetDateTime(dr.GetOrdinal("CDAP_PERIODTO")); } //if (!dr.IsDBNull(dr.GetOrdinal("projectid"))) obCDAPImplementationBO.PeriodTo = dr.get(dr.GetOrdinal("projectid")); if (!dr.IsDBNull(dr.GetOrdinal("CDAP_PHASEACTIVITYID"))) { obCDAPImplementationBO.Cdap_phaseactivityid = dr.GetInt32(dr.GetOrdinal("CDAP_PHASEACTIVITYID")); } if (!dr.IsDBNull(dr.GetOrdinal("CDAP_ACTIVITYNAME"))) { obCDAPImplementationBO.Cdap_activityname = dr.GetString(dr.GetOrdinal("CDAP_ACTIVITYNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("DISTRICT"))) { obCDAPImplementationBO.District = dr.GetString(dr.GetOrdinal("DISTRICT")); } if (!dr.IsDBNull(dr.GetOrdinal("COUNTY"))) { obCDAPImplementationBO.County = dr.GetString(dr.GetOrdinal("COUNTY")); } if (!dr.IsDBNull(dr.GetOrdinal("SUBCOUNTY"))) { obCDAPImplementationBO.SubCounty = dr.GetString(dr.GetOrdinal("SUBCOUNTY")); } if (!dr.IsDBNull(dr.GetOrdinal("VILLAGES"))) { obCDAPImplementationBO.Village = dr.GetString(dr.GetOrdinal("VILLAGES")); } if (!dr.IsDBNull(dr.GetOrdinal("activitydatefrom"))) { obCDAPImplementationBO.Activitydatefrom = dr.GetDateTime(dr.GetOrdinal("activitydatefrom")); } if (!dr.IsDBNull(dr.GetOrdinal("activitydateto"))) { obCDAPImplementationBO.Activitydateto = dr.GetDateTime(dr.GetOrdinal("activitydateto")); } if (!dr.IsDBNull(dr.GetOrdinal("activitydetails"))) { obCDAPImplementationBO.Activitydetails = dr.GetString(dr.GetOrdinal("activitydetails")); } if (!dr.IsDBNull(dr.GetOrdinal("modeofimplementation"))) { obCDAPImplementationBO.Modeofimplementation = dr.GetString(dr.GetOrdinal("modeofimplementation")); } if (!dr.IsDBNull(dr.GetOrdinal("challenges"))) { obCDAPImplementationBO.Challenges = dr.GetString(dr.GetOrdinal("challenges")); } if (!dr.IsDBNull(dr.GetOrdinal("comments"))) { obCDAPImplementationBO.Comments = dr.GetString(dr.GetOrdinal("comments")); } if (!dr.IsDBNull(dr.GetOrdinal("PAPNAMES"))) { obCDAPImplementationBO.PapNames = dr.GetString(dr.GetOrdinal("PAPNAMES")); } objCDAPImplementationList.Add(obCDAPImplementationBO); } dr.Close(); return(objCDAPImplementationList); }
/// <summary> /// To Add CDAP Activity PAPS details /// </summary> /// <param name="objCDAPImplementationBO"></param> /// <returns></returns> public int AddCDAPActivityPAPS(CDAPImplementationBO objCDAPImplementationBO) { return((new CDAPImplementationDAL()).AddCDAPActivityPAPS(objCDAPImplementationBO)); }
/// <summary> /// To Add CDAP Phase Activity to database /// </summary> /// <param name="objCDAPImplementationBO"></param> /// <returns></returns> public int AddCDAPPhaseActivity(CDAPImplementationBO objCDAPImplementationBO) { return((new CDAPImplementationDAL()).AddCDAPPhaseActivity(objCDAPImplementationBO)); }
/// <summary> /// To Add CDAP Phase to database /// </summary> /// <param name="objCDAPImplementationBO"></param> /// <returns></returns> public string AddCDAPPhase(CDAPImplementationBO objCDAPImplementationBO) { return((new CDAPImplementationDAL()).AddCDAPPhase(objCDAPImplementationBO)); }