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