public RequestResult InsertAnnualSubsidyCommittees( CommitteeRequestInfo CommitteeRequestInfo, List <Files> Files ) { try { /// Data Validations DataValidation.IsEmptyOrDefault2(CommitteeRequestInfo); DataValidation.IsEmptyOrDefault2(CommitteeRequestInfo.CheckedData); DataValidation.IsEmptyOrDefaultList2(CommitteeRequestInfo.Projects); DataValidation.IsEmptyOrDefaultList2(Files); //if (DataValidation.IsEmptyOrDefault(CommitteeRequestInfo) || // DataValidation.IsEmptyOrDefault(CommitteeRequestInfo.CheckedData) || // DataValidation.IsEmptyOrDefaultList(CommitteeRequestInfo.Projects) || // DataValidation.IsEmptyOrDefaultList(Files)) // throw new FaultException<ValidationFault>(new ValidationFault()); /// Call Database using (CommitteesDAL dal = new CommitteesDAL(new ADO(true))) { return(dal.InsertAnnualSubsidyCommitteesDAL( CommitteeRequestInfo, Files )); } } catch (FaultException <ValidationFault> flex) { //ValidationFault fault = new ValidationFault //{ // Result = true, // Message = "Parameter not correct", // Description = "Invalid Parameters is Required but have null or empty or 0 value" //}; //var flex = new FaultException<ValidationFault>(fault, new FaultReason("Invalid Parameters is Required but have null or empty or 0 value")); _log.Error(flex); throw flex; } catch (Exception ex) { ValidationFault fault = new ValidationFault { Result = false, Message = ex.Message, Description = "Service have an internal error please contact service administartor [email protected]" }; _log.Error(ex); throw new FaultException <ValidationFault>(fault); } }
public RequestResult InsertFoundationAdditionalSubsidyCommitteesDAL( CommitteeRequestInfo obj ) { List <SpInPuts> inputs = new List <SpInPuts> { new SpInPuts() { KEY = "P_REG_TYPE_CODE", VALUE = obj.CheckedData.AgencyType }, new SpInPuts() { KEY = "P_SOC_REG_NO", VALUE = obj.CheckedData.AgencyLicenseNumber }, new SpInPuts() { KEY = "P_SUBSIDY_CODE", VALUE = obj.SubsidyType }, new SpInPuts() { KEY = "P_FIN_YEAR", VALUE = obj.FinancialYear }, new SpInPuts() { KEY = "P_LOGIN_ID", VALUE = obj.CheckedData.CommissionerNumber } }; List <SpOutPuts> Outouts = new List <SpOutPuts>() { new SpOutPuts() { ParameterName = "P_RESULT_CODE", OracleDbType = OracleDbType.Varchar2, Size = 300 }, new SpOutPuts() { ParameterName = "P_RESULT_TEXT", OracleDbType = OracleDbType.Varchar2, Size = 2000 }, new SpOutPuts() { ParameterName = "P_REQUEST_ID", OracleDbType = OracleDbType.Varchar2, Size = 300 } }; //Populate Parameters List <OracleParameter> OpParms = ado.PopulateSpInPuts( in inputs ); ado.PopulateSpOutPuts( ref OpParms, in Outouts ); try { ado.ExecuteStoredProcedure( "SD_P_SUBSIDY_REQUEST", OpParms, out OracleParameterCollection OPCs ); RequestResult RequestResult = new RequestResult { RequestId = OPCs[":P_REQUEST_ID"].Value != null?Convert.ToInt64(OPCs[":P_REQUEST_ID"].Value.ToString()) : 0, RequestCode = OPCs[":P_RESULT_CODE"].Value.ToString(), RequestName = OPCs[":P_RESULT_TEXT"].Value.ToString(), }; for (int i = 0; i < obj.Projects.Count(); i++) { RequestResult rr = InsertProjectDAL( RequestResult.RequestId, obj.CheckedData.CommissionerNumber, obj.Projects[i] ); if (rr.RequestCode != "1") { RequestResult.RequestId = -1; RequestResult.RequestCode = rr.RequestCode; RequestResult.RequestName = rr.RequestName; ado.SqlCommiteT(false); return(RequestResult); } RequestResult.RequestCode = rr.RequestCode; RequestResult.RequestName = rr.RequestName; } ado.SqlCommiteT(true); return(RequestResult); } catch (Exception ex) { ado.SqlCommiteT(false); throw ex; } }