public static int usp_25_Commitment_CreateCommitmentRequest(string LoginEmail, CommitmentChangeEnt commitment, out string sql) { string procName = "OVPR.usp_25_Commitment_CreateCommitmentRequest"; var prms = new List <SqlParameter>(); prms.Add(new SqlParameter("@LoginEmail", LoginEmail)); prms.Add(new SqlParameter("@CampusPK", commitment.CampusPK)); prms.Add(new SqlParameter("@CommitTypePK", commitment.CommitTypePK)); prms.Add(new SqlParameter("@CommitSchoolPK", commitment.CommitSchoolPK)); prms.Add(new SqlParameter("@CommitDeptPK", commitment.CommitDeptPK)); prms.Add(new SqlParameter("@CommitPiPK", commitment.CommitPiPK)); prms.Add(new SqlParameter("@InfoEdID", commitment.InfoEdID)); prms.Add(new SqlParameter("@CommitDate", commitment.CommitDate)); prms.Add(new SqlParameter("@FiscalYear", commitment.FiscalYear)); prms.Add(new SqlParameter("@NoOfYears", commitment.NoOfYears)); prms.Add(new SqlParameter("@TotalCommitment", commitment.TotalCommitment)); prms.Add(new SqlParameter("@CommitStatusPK", commitment.CommitStatusPK)); prms.Add(new SqlParameter("@Comment", commitment.Comment)); prms.Add(new SqlParameter("@CommitmentDesc", commitment.CommitmentDesc)); prms.Add(new SqlParameter("@CorrectedPropSchoolPK", commitment.CorrectedPropSchoolPK)); prms.Add(new SqlParameter("@CorrectedPropOrgnPK", commitment.CorrectedPropOrgnPK)); prms.Add(new SqlParameter("@CorrectedPropPiPK", commitment.CorrectedPropPiPK)); prms.Add(new SqlParameter("@CorrectedPropSponsorPK", commitment.CorrectedPropSponsorPK)); sql = Utility.ExecCall(procName, prms); return(DataAccessHelpers.ExecuteGetInt(procName, prms)); }
public static int usp_28A_Payment_GetNextAvailablePaymentNumber(int Commitment_PK) { string procName = "OVPR.usp_28A_Payment_GetNextAvailablePaymentNumber"; var prms = new List <SqlParameter>(); prms.Add(new SqlParameter("@Commitment_PK", Commitment_PK)); return(DataAccessHelpers.ExecuteGetInt(procName, prms)); }