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 usp_24a_Document_DelSpecificDocument(int Document_PK)
{
string procName = "OVPR.usp_24a_Document_DelSpecificDocument";
var prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@prm_Document_PK", Document_PK));
DataAccessHelpers.ExecuteGetDataTableStoredProc(procName, prms);
}
public static byte[] usp_22a_Document_GetDocFileByDocPK(int DOC_PK_ID)
{
string procName = "OVPR.usp_22a_Document_GetDocFileByDocPK";
var prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@prm_DOC_PK_ID", DOC_PK_ID));
var dt = DataAccessHelpers.ExecuteGetDataTableStoredProc(procName, prms);
return((byte[])dt.Rows[0]["BinaryDocument"]);
}
public static void usp_34_CommitType_AddLevel2(TypeLevel2Ent ent, string userName)
{
string procName = "OVPR.usp_34_CommitType_AddLevel2";
var prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@Level1_PK", ent.Level1_PK));
prms.Add(new SqlParameter("@Level2Description", ent.Description));
prms.Add(new SqlParameter("@User_Name", userName));
DataAccessHelpers.ExecuteGetDataTableStoredProc(procName, prms);
}
public static byte[] usp_22_Document_GetDocFileByCommitmentPkFileName(int Commit_PK, string FileName)
{
string procName = "OVPR.usp_22_Document_GetDocFileByCommitmentPkFileName";
var prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@prm_Commit_PK", Commit_PK));
prms.Add(new SqlParameter("@prm_FileName", FileName));
var dt = DataAccessHelpers.ExecuteGetDataTableStoredProc(procName, prms);
return((byte[])dt.Rows[0]["BinaryDocument"]);
}
public static void usp_29_Payment_DeletePayment(int Commitment_PK, int Payment_PK, string PayStatus)
{
string procName = "OVPR.usp_29_Payment_DeletePayment";
var prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@Commitment_PK", Commitment_PK));
prms.Add(new SqlParameter("@Payment_PK", Payment_PK));
prms.Add(new SqlParameter("@PayStatus", PayStatus));
//prms.Add(new SqlParameter("@DeleteAll", DeleteAll));
DataAccessHelpers.ExecuteGetDataTableStoredProc(procName, prms);
}
public static void usp_23_Document_InsertDocFile(int Commit_PK, string FileName, int FileSize, string FileType, byte[] bytes, string UpLoadedBy)
{
string procName = "OVPR.usp_23_Document_InsertDocFile";
var prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@prm_Commit_PK", Commit_PK));
prms.Add(new SqlParameter("@prm_FileName", FileName));
prms.Add(new SqlParameter("@prm_FileSize", FileSize));
prms.Add(new SqlParameter("@prm_FileType", FileType));
prms.Add(new SqlParameter("@prm_Document", bytes));
prms.Add(new SqlParameter("@prm_UpLoadedBy", UpLoadedBy));
DataAccessHelpers.ExecuteGetDataTableStoredProc(procName, prms);
}
public static void usp_02_User_AddUsers(UserEnt userEnt, int insertByUserID)
{
string procName = "OVPR.usp_02_User_AddUsers";
var prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@Email", userEnt.USER_EmailAddress));
prms.Add(new SqlParameter("@LastName", userEnt.USER_LastName));
prms.Add(new SqlParameter("@FirstName", userEnt.USER_FirstName));
prms.Add(new SqlParameter("@MI", userEnt.USER_MI));
prms.Add(new SqlParameter("@Role", userEnt.ROLE_PK_ID));
prms.Add(new SqlParameter("@User_PK", insertByUserID));
DataAccessHelpers.ExecuteGetDataTableStoredProc(procName, prms);
}
public static void usp_28_Payment_AddPayment(PaymentChangeEnt ent)
{
string procName = "OVPR.usp_28_Payment_AddPayment";
var prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@Commitment_PK", ent.Commitment_PK));
prms.Add(new SqlParameter("@FY", ent.FY));
prms.Add(new SqlParameter("@PaymentNumber", ent.PaymentNumber));
prms.Add(new SqlParameter("@DueDate", ent.DueDate));
prms.Add(new SqlParameter("@PayStatus", ent.PayStatus));
prms.Add(new SqlParameter("@PayComment", ent.PayComment));
prms.Add(new SqlParameter("@Amount", ent.Amount));
prms.Add(new SqlParameter("@TransNumber", ent.TransNumber));
prms.Add(new SqlParameter("@PaymentDate", ent.PaymentDate));
prms.Add(new SqlParameter("@AcctFrom", ent.AcctFrom));
prms.Add(new SqlParameter("@AcctTo", ent.AcctTo));
prms.Add(new SqlParameter("@Reason", ent.Reason));
DataAccessHelpers.ExecuteGetDataTableStoredProc(procName, prms);
}
