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