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