public ControllerRegisterCompleteNotificationSending()
{
response = new MetaResponse();
DAL_REQUEST_ID = new REQUEST_ID(con);
DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con);
DAL_REPORT_HISTORY = new REPORT_HISTORY(con);
DAL_CLIENT_CERTIFICATE = new CLIENT_CERTIFICATE(con);
DAL_REQ_ADDRESS = new REQ_ADDRESS(con);
timer = new Stopwatch();
timer.Start();
//UPDATED_AT
UPDATED_AT_DATETIME = TEMP.ToString("yyyy/MM/dd HH:mm");
CURRENT_DATETIME = TEMP.ToString("yyyyMMddHHmmss");
}
public MetaResponse getInitialData(string COMPANY_NO_BOX, string REQ_SEQ, int REQ_STATUS, int REQ_TYPE)
{
try
{
DataSet ds = new DataSet();
string strMessage = "";
REQUEST_DETAIL DAL_REQUEST_DETAIL = new REQUEST_DETAIL(con);
DataTable dtList = DAL_REQUEST_DETAIL.GetInitialDataForApproval(COMPANY_NO_BOX, REQ_SEQ, REQ_STATUS, REQ_TYPE, out strMessage);
dtList.TableName = "LISTING";
ds.Tables.Add(dtList);
if (dtList.Rows.Count > 0)
{
response.Status = 1;
//SERVICE DESK POP UP
REQ_ADDRESS DAL_REQ_ADDRESS = new REQ_ADDRESS(con);
string _REQ_SEQ = dtList.Rows[0]["REQ_SEQ"].ToString().Trim();
if (REQ_TYPE == 2)
{
DataTable SERVICE_DESK_CURRENT = DAL_REQ_ADDRESS.GetServiceDeskPopUp(COMPANY_NO_BOX, _REQ_SEQ, out strMessage);
SERVICE_DESK_CURRENT.TableName = "SERVICE_DESK_CURRENT";
ds.Tables.Add(SERVICE_DESK_CURRENT);
}
DataTable SERVICE_DESK_NEW = DAL_REQ_ADDRESS.GetServiceDeskPopUp(COMPANY_NO_BOX, REQ_SEQ, out strMessage);
SERVICE_DESK_NEW.TableName = "SERVICE_DESK_CHANGE";
ds.Tables.Add(SERVICE_DESK_NEW);
//ERROR NOTI POP UP
if (REQ_TYPE == 2)
{
DataTable ERROR_NOTI_CURRENT = DAL_REQ_ADDRESS.GetErrorNotificationPopUp(COMPANY_NO_BOX, _REQ_SEQ, out strMessage);
ERROR_NOTI_CURRENT.TableName = "ERROR_NOTI_CURRENT";
ds.Tables.Add(ERROR_NOTI_CURRENT);
}
DataTable ERROR_NOTI_NEW = DAL_REQ_ADDRESS.GetErrorNotificationPopUp(COMPANY_NO_BOX, REQ_SEQ, out strMessage);
ERROR_NOTI_NEW.TableName = "ERROR_NOTI_CHANGE";
ds.Tables.Add(ERROR_NOTI_NEW);
//BREAK DOWN
if (REQ_TYPE == 2)
{
DataTable BREAKDOWN_CURRENT = DAL_REQ_ADDRESS.GetUsageChargeBreakDownPopUp(COMPANY_NO_BOX, _REQ_SEQ, out strMessage);
BREAKDOWN_CURRENT.TableName = "BREAKDOWN_CURRENT";
ds.Tables.Add(BREAKDOWN_CURRENT);
}
DataTable BREAKDOWN_NEW = DAL_REQ_ADDRESS.GetUsageChargeBreakDownPopUp(COMPANY_NO_BOX, REQ_SEQ, out strMessage);
BREAKDOWN_NEW.TableName = "BREAKDOWN_CHANGE";
ds.Tables.Add(BREAKDOWN_NEW);
}
else
{
if (string.IsNullOrEmpty(strMessage))
{
response.Status = 1;
response.Message = "There is no data to display.";
}
else
{
response.Status = 0;
response.Message = strMessage;
}
}
response.Data = Utility.Utility_Component.DsToJSon(ds, "INITIAL DATA");
timer.Stop();
response.Meta.Duration = timer.Elapsed.TotalSeconds;
return(response);
}
catch (Exception ex)
{
return(ResponseUtility.GetUnexpectedResponse(response, timer, ex));
}
}
