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);
}
public static DataTable SelectData(DataTable dataTable, string storedProcedureName, Dictionary <string, object> inputParameter)
{
OracleDataAdapter adapter = new OracleDataAdapter();
OracleCommand command = new OracleCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = storedProcedureName;
command.Connection = DatabaseUtility.OpenConnectionDR();
command.CommandTimeout = 0;
adapter.SelectCommand = command;
foreach (KeyValuePair <string, object> items in inputParameter)
{
OracleParameter parameter = new OracleParameter(items.Key, items.Value == null ? DBNull.Value : items.Value);
parameter.Direction = ParameterDirection.Input;
command.Parameters.Add(parameter);
}
adapter.Fill(dataTable);
DatabaseUtility.closeConnection(command.Connection);
return(dataTable);
}
public DataTable MaxJobNo_Param()
{
DataTable dataTable = DatabaseUtility.SelectData(GenericStoredProcedure.COM_GetParamMaxNo);
return(dataTable);
}
public DataTable MaxJobNo_Rule()
{
DataTable dataTable = DatabaseUtility.SelectData(GenericStoredProcedure.COM_GetMaxRuleID);
return(dataTable);
}
public DataTable CM_SelectMaxIDinDocuments()
{
DataTable dataTable = DatabaseUtility.SelectData(GenericStoredProcedure.CM_MaxIDinDocuments);
return(dataTable);
}
public DataTable SelectMaxIDinImages()
{
DataTable dataTable = DatabaseUtility.SelectData(GenericStoredProcedure.CM_MaxIDinImages);
return(dataTable);
}
public DataTable GetBranchesRef()
{
DataTable dataTable = DatabaseUtility.SelectData(GenericStoredProcedure.IT_SelectBranchEmail);
return(dataTable);
}
//GetMax Job No
public DataTable MaxJobNo()
{
DataTable dataTable = DatabaseUtility.SelectData(GenericStoredProcedure.IT_GetMaxJobNo);
return(dataTable);
}
public DataTable GetPolicyCancelUsers()
{
DataTable dataTable = DatabaseUtility.SelectData(GenericStoredProcedure.GetUsersCancelExpirePolicies);
return(dataTable);
}