public static int CreateCommitment(string LoginEmail, CommitmentChangeEnt commitment, List <FileToUpload> files, out string sql)
{
// var uploadArgs = new UploadArgs();
var Commit_PK = OVPRDat.usp_25_Commitment_CreateCommitmentRequest(LoginEmail, commitment, out sql);
//uploadArgs.Files = files;
//Upload(uploadArgs, LoginEmail);
SyncFiles(Commit_PK, files, LoginEmail);
return(Commit_PK);
}
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 void usp_26_Commitment_UpdateBaseCommitmentRequest(string LoginEmail, CommitmentChangeEnt commitment, out string sql)
{
//string procName = "OVPR.usp_26a_Commitment_UpdateBaseCommitmentRequest";
string procName = "OVPR.usp_26a_Commitment_UpdateCommitmentRequestType";
var prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@LoginEmail", LoginEmail));
prms.Add(new SqlParameter("@CommitmentPK", commitment.CommitmentPK));
prms.Add(new SqlParameter("@CampusPK", commitment.CampusPK));
prms.Add(new SqlParameter("@CommitmentTypePK", commitment.CommitTypePK));
prms.Add(new SqlParameter("@CommitSchoolPK", commitment.CommitSchoolPK));
prms.Add(new SqlParameter("@CommitDeptPK", commitment.CommitDeptPK));
prms.Add(new SqlParameter("@PI_PK", commitment.CommitPiPK));
prms.Add(new SqlParameter("@PropNumber", 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("@PropCorrectedOrg_PK", commitment.CorrectedPropOrgnPK));
prms.Add(new SqlParameter("@PropCorrectedPi_PK", commitment.CorrectedPropPiPK));
prms.Add(new SqlParameter("@PropCorrectedSponsor_PK", commitment.CorrectedPropSponsorPK));
sql = Utility.ExecCall(procName, prms);
DataAccessHelpers.ExecuteGetDataTableStoredProc(procName, prms);
}
public static void UpdateCommitment(string LoginEmail, CommitmentChangeEnt commitment, List <FileToUpload> files, out string sql)
{
SyncFiles(commitment.CommitmentPK.Value, files, LoginEmail);
OVPRDat.usp_26_Commitment_UpdateBaseCommitmentRequest(LoginEmail, commitment, out sql);
}
