public void Update_IT_Cancel_Expire(string Case, string PolicyNo) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add(@"V_CASE", Case); inputParameter.Add(@"V_POL_NO", PolicyNo); DatabaseUtility.PopulateData(GenericStoredProcedure.IT_UpdateCancelExpirePolicies, inputParameter, outputParameter, outputParameterValues); }
public void UpdateAssignUser(string JobNo, string User) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_JOB_NO", JobNo); inputParameter.Add("V_USER", User); DatabaseUtility.PopulateData(GenericStoredProcedure.IT_UpdateAssignUser, inputParameter, outputParameter, outputParameterValues); }
public void UpdateRegister_StatusByHandler(string ReqID, string Status, string User) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add(@"V_REQ_ID", ReqID); inputParameter.Add(@"V_STATUS", Status); inputParameter.Add(@"V_USER", User); DatabaseUtility.PopulateData(GenericStoredProcedure.IT_UpdateHandlerStatus, inputParameter, outputParameter, outputParameterValues); }
public void UpdateRegister_Approve(string CM_ID, string ApproveReason, string ApproveUser) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_CM_ID", CM_ID); inputParameter.Add("V_APPROVE_REASON", ApproveReason); inputParameter.Add("V_USER", ApproveUser); DatabaseUtility.PopulateData(GenericStoredProcedure.CM_UpdateRegister_Approve, inputParameter, outputParameter, outputParameterValues); }
public void UpdateRegister_Reject(string CM_ID, string RejectReason, string RejectUser) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_CM_ID", CM_ID); inputParameter.Add("V_REJECT_REASON", RejectReason); inputParameter.Add("V_USER", RejectUser); DatabaseUtility.PopulateData(GenericStoredProcedure.CM_UpdateRegister_Reject, inputParameter, outputParameter, outputParameterValues); }
public void InsertDocsToJobNo(string JOBNO, string DocumentName) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_JOBNO", JOBNO); inputParameter.Add("V_DOC_NAME", DocumentName); DatabaseUtility.PopulateData(GenericStoredProcedure.CM_InsertDocumentsToJobNo, inputParameter, outputParameter, outputParameterValues); }
public void UpdateRegister_ReleaseUAT(string CM_ID, string Release, string ApproveUser) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_CM_ID", CM_ID); inputParameter.Add("V_RELEASE", Release); inputParameter.Add("V_USER", ApproveUser); DatabaseUtility.PopulateData(GenericStoredProcedure.CM_UpdateRegister_Release_UAT, inputParameter, outputParameter, outputParameterValues); }
//Insert Documents public void InsertDocuments(string JobNo, OracleDbType DocName, string DocPath) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_JOB_NO", JobNo); inputParameter.Add("V_DOCNAME", DocName); inputParameter.Add("V_DOCPATH", DocPath); DatabaseUtility.PopulateData(GenericStoredProcedure.IT_InsertDocsToJobNo, inputParameter, outputParameter, outputParameterValues); }
public void InsertContacts(string JOBNO, string User) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_JOBNO", JOBNO); inputParameter.Add("V_USERNAME", User); DatabaseUtility.PopulateData(GenericStoredProcedure.CM_InsertContactsToJobNo, inputParameter, outputParameter, outputParameterValues); }
public void InsertPath(string JOBNO, string Path) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_JOBNO", JOBNO); inputParameter.Add("V_PATH", Path); DatabaseUtility.PopulateData(GenericStoredProcedure.CM_InsertCIPath, inputParameter, outputParameter, outputParameterValues); }
//--------Report--- public void UpdateRegister_FromChangeManagement(string ReqID, string UnitRemark, string Status, string User) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add(@"V_REQ_ID", ReqID); inputParameter.Add(@"V_REMARKS_UNIT", UnitRemark); inputParameter.Add(@"V_STATUS", Status); inputParameter.Add(@"V_USER", User); DatabaseUtility.PopulateData(GenericStoredProcedure.IT_UpdateRegister_ByChangeManagement, inputParameter, outputParameter, outputParameterValues); }
public void InsertAgentRef(string Code, string Des, string Status, string Level, string User) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_CODE", Code); inputParameter.Add("V_DES", Des); inputParameter.Add("V_STATUS", Status); inputParameter.Add("V_LEVEL", Level); inputParameter.Add("V_USER", User); DatabaseUtility.PopulateData(GenericStoredProcedure.COM_InsertAgentRef, inputParameter, outputParameter, outputParameterValues); }
public void UpdateParameters(string ParamID, string Description, string UserInfo, string valueType, string ParamLength) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_PARAMID", ParamID); inputParameter.Add("V_DES", Description); inputParameter.Add("V_USERINFO", UserInfo); inputParameter.Add("V_VALUETYPE", valueType); inputParameter.Add("V_PARAMLENGTH", ParamLength); DatabaseUtility.PopulateData(GenericStoredProcedure.COM_UpdateParameters, inputParameter, outputParameter, outputParameterValues); }
public void InsertReferanceData(string code, string Description, string Status, string UserInfo, string RefType) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_CODE", code); inputParameter.Add("V_DES", Description); inputParameter.Add("V_STATUS", Status); inputParameter.Add("V_USERINFO", UserInfo); inputParameter.Add("V_REFTYPE", RefType); DatabaseUtility.PopulateData(GenericStoredProcedure.COM_InsertReferance, inputParameter, outputParameter, outputParameterValues); }
public void InsertRule(string RuleDes, string Status, string User, string Definition, string Type, string Percentage) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_RULE_DES", RuleDes); inputParameter.Add("V_STATUS", Status); inputParameter.Add("V_CREATED_USER", User); inputParameter.Add("V_RULE_DEFINITION", Definition); inputParameter.Add("V_TYPE", Type); inputParameter.Add("V_PERCENTAGE", Percentage); DatabaseUtility.PopulateData(GenericStoredProcedure.COM_InsertRules, inputParameter, outputParameter, outputParameterValues); }
public void Update_IT_UnlockUser(string UserCode, string RoleID, DateTime StartDate, string PartyID, string PartyFunction) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add(@"V_USER_CODE", UserCode); inputParameter.Add(@"V_ROLE_ID", RoleID); inputParameter.Add(@"V_START_DATE", StartDate); inputParameter.Add(@"V_PARTY_ID", PartyID); inputParameter.Add(@"V_PARTY_FUNCTION", PartyFunction); DatabaseUtility.PopulateData(GenericStoredProcedure.IT_UnlockUser, inputParameter, outputParameter, outputParameterValues); }
public void UpdateRegister(string CM_ID, string IT_WF_ID, string ParentChangeID, string Title, string System, string Description, string RequestUser) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_CM_ID", CM_ID); inputParameter.Add("V_ITWF_ID", IT_WF_ID); inputParameter.Add("V_PARENTCHANGE", ParentChangeID); inputParameter.Add("V_TITLE", Title); inputParameter.Add("V_SYSTEM", System); inputParameter.Add("V_DESCRIPTION", Description); inputParameter.Add("V_REQUEST_USER", RequestUser); DatabaseUtility.PopulateData(GenericStoredProcedure.CM_UpdateRegister, inputParameter, outputParameter, outputParameterValues); }
public void InsertAgentHierarchy(string Code, string ParentCode, decimal Percentage, string Level, string Statue, string User, DateTime?EndDate) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_AGENT_CODE", Code); inputParameter.Add("V_PARENT_CODE", ParentCode); inputParameter.Add("V_PARENT_PERCENTAGE", Percentage); inputParameter.Add("V_PARENT_LEVEL", Level); inputParameter.Add("V_STATUS", Statue); inputParameter.Add("V_USER_NAME", User); inputParameter.Add("V_END_DATE", EndDate); DatabaseUtility.PopulateData(GenericStoredProcedure.COM_InsertAgentHierarchy, inputParameter, outputParameter, outputParameterValues); }
//Update Register By Branch(Re-open) public void UpdateRegisterByBranch(string ReqID, string RefNo, string System, string Remarks, string Branch, string User, string Status, string Priority) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add(@"V_REQ_ID", ReqID); inputParameter.Add(@"V_REF_NO", RefNo); inputParameter.Add(@"V_SYSTEM", System); inputParameter.Add(@"V_REMARKS", Remarks); inputParameter.Add(@"V_BRANCH", Branch); inputParameter.Add(@"V_USER", User); inputParameter.Add(@"V_STATUS", Status); inputParameter.Add(@"V_PRIORITY", Priority); DatabaseUtility.PopulateData(GenericStoredProcedure.IT_UpdateRegisterByBranch, inputParameter, outputParameter, outputParameterValues); }
public void UpdateRule_RowByRow(string RuleID, string LineNo, string Col1, string Col2, string Col3, string Col4, string Col5, string Col6) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_RULE_ID", RuleID); inputParameter.Add("V_LINE_NO", LineNo); inputParameter.Add("V_COL1", Col1); inputParameter.Add("V_COL2", Col2); inputParameter.Add("V_COL3", Col3); inputParameter.Add("V_COL4", Col4); inputParameter.Add("V_COL5", Col5); inputParameter.Add("V_COL6", Col6); DatabaseUtility.PopulateData(GenericStoredProcedure.COM_UpdateRules_rowByrow, inputParameter, outputParameter, outputParameterValues); }
//Insert Register public void InsertRegisterBranch(string RefNo, string System, string Remarks, string Branch, string RequestUser, string RequestUser_Email, string Priority, string Company, string Department) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_REF_NO", RefNo); inputParameter.Add("V_SYSTEM", System); inputParameter.Add("V_REMARKS", Remarks); inputParameter.Add("V_BRANCH", Branch); inputParameter.Add("V_REQUEST_USER", RequestUser); inputParameter.Add("V_REQUEST_USER_EMAIL", RequestUser_Email); inputParameter.Add("V_PRIORITY", Priority); inputParameter.Add("V_COMPANY", Company); inputParameter.Add("V_DEPARTMENT", Department); DatabaseUtility.PopulateData(GenericStoredProcedure.IT_InsertRegisterBranch, inputParameter, outputParameter, outputParameterValues); }
public void UpdateRegister_Implement(string CM_ID, string ImplementationComment, string CIAttatched, string SVN_Attatched, string DeploymentPlan, string CheckList, string Prerequisites, string ApproveUser) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_CM_ID", CM_ID); inputParameter.Add("V_IMPLEMENTATION", ImplementationComment); inputParameter.Add("V_CI_ATTATCHED", CIAttatched); inputParameter.Add("V_SVN_ATTATCHED", SVN_Attatched); inputParameter.Add("V_DEPLOYMENT_PLAN", DeploymentPlan); inputParameter.Add("V_CHECKLIST_FORTEST", CheckList); inputParameter.Add("V_PREREQUISITES", Prerequisites); inputParameter.Add("V_USER", ApproveUser); DatabaseUtility.PopulateData(GenericStoredProcedure.CM_UpdateRegister_Implement, inputParameter, outputParameter, outputParameterValues); }
public void UpdateRegister(string ReqID, string JobType, string UnitRemark, string DesID, string Status, string User, string ReassignUser, string HandledUser, string TcsErrorNo, string Company) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add(@"V_REQ_ID", ReqID); inputParameter.Add(@"V_JOB_TYPE", JobType); inputParameter.Add(@"V_REMARKS_UNIT", UnitRemark); inputParameter.Add(@"V_JOB_DES", DesID); inputParameter.Add(@"V_STATUS", Status); inputParameter.Add(@"V_USER", User); inputParameter.Add(@"V_REASSIGN_USER", ReassignUser); inputParameter.Add(@"V_HANDLED_USER", HandledUser); inputParameter.Add(@"V_TCS_NO", TcsErrorNo); inputParameter.Add(@"V_COMPANY", Company); DatabaseUtility.PopulateData(GenericStoredProcedure.IT_UpdateRegister, inputParameter, outputParameter, outputParameterValues); }
public void UpdateRegister_Plan(string CM_ID, string Impact, string Outage, DateTime Start, DateTime End, string Fallback, string Manager, string Implementor, string QA, string ReleasePerson, string UpdateUser) { Dictionary <string, object> inputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameter = new Dictionary <string, object>(); Dictionary <string, object> outputParameterValues = new Dictionary <string, object>(); inputParameter.Add("V_CM_ID", CM_ID); inputParameter.Add("V_IMPACT", Impact); inputParameter.Add("V_OUTAGE", Outage); inputParameter.Add("V_START_DATE", Start); inputParameter.Add("V_END_DATE", End); inputParameter.Add("V_FALLBACK_PLAN", Fallback); inputParameter.Add("V_MANAGER", Manager); inputParameter.Add("V_IMPLEMENTOR", Implementor); inputParameter.Add("V_QAAGENT", QA); inputParameter.Add("V_RELEASE_PERSN", ReleasePerson); inputParameter.Add("V_USER", UpdateUser); DatabaseUtility.PopulateData(GenericStoredProcedure.CM_UpdateRegister_PlanandAssign, inputParameter, outputParameter, outputParameterValues); }