//public static List<OCPB.Service.Model.ComplainlistDetail> GetComplainTimeLine(string ApiKey, int? Skip, int? take, int? IsCloseJob)
//{
// SqlParameter[] param = new SqlParameter[4];
// param[0] = new SqlParameter("@RefKey", !String.IsNullOrEmpty(ApiKey) ? ApiKey : (Object)DBNull.Value);
// param[1] = new SqlParameter("@Skip", Skip != null ? Skip : (Object)DBNull.Value);
// param[2] = new SqlParameter("@take", take != null ? take : (Object)DBNull.Value);
// param[3] = new SqlParameter("@IsCloseJob", IsCloseJob != null ? IsCloseJob : (Object)DBNull.Value);
// return DirectSqlDao.GetAllStored<OCPB.Service.Model.ComplainlistDetail>("GetComplainTimeLine", param);
//}
public static List <OCPB.Service.Model.ComplainlistDetail> GetComplainByCaseId(string ApiKey, string Case_Id)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@RefKey", !String.IsNullOrEmpty(ApiKey) ? ApiKey : (Object)DBNull.Value);
param[1] = new SqlParameter("@Case_Id", !String.IsNullOrEmpty(Case_Id) ? Case_Id.Trim() : (Object)DBNull.Value);
return(DirectSqlDao.GetAllStored <OCPB.Service.Model.ComplainlistDetail>("GetComplainByCaseId", param));
}
public static List <ComplainGetFileModel> GetfileUploadByCaseId(string ApiKey, string Case_Id)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@RefKey", !String.IsNullOrEmpty(ApiKey) ? ApiKey : (Object)DBNull.Value);
param[1] = new SqlParameter("@Case_Id", Case_Id);
return(DirectSqlDao.GetAllStored <ComplainGetFileModel>("GetComplainFileUploadByCaseId", param));
}
public static List <OCPB.Service.Model.ComplainGetFileModel> GetfileUpload(int ComplainID)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ComplainID", ComplainID);
return(DirectSqlDao.GetAllStored <OCPB.Service.Model.ComplainGetFileModel>("GetComplainFileUpload", param));
}
public static List <OCPB.Service.Model.GetComplainTimeLineResult> GetComplainTimeLine(string ApiKey, int?Skip, int?take, int?IsCloseJob, int? @CusID)
{
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@RefKey", !String.IsNullOrEmpty(ApiKey) ? ApiKey : (Object)DBNull.Value);
param[1] = new SqlParameter("@Skip", Skip != null ? Skip : (Object)DBNull.Value);
param[2] = new SqlParameter("@take", take != null ? take : (Object)DBNull.Value);
param[3] = new SqlParameter("@IsCloseJob", IsCloseJob != null ? IsCloseJob : (Object)DBNull.Value);
param[4] = new SqlParameter("@CusID", CusID != null ? CusID : (Object)DBNull.Value);
return(DirectSqlDao.GetAllStored <OCPB.Service.Model.GetComplainTimeLineResult>("GetComplainTimeLine", param));
}
// GET api/integration/5
public string Get(int id)
{
SqlParameter[] param = new SqlParameter[0];
string Stored = null;
switch (id)
{
case 2: Stored = "Bi_rpt_Complains_By_Area"; break;
case 3: Stored = "Bi_rpt_Complain_Dept"; break;
case 4: Stored = "Bi_rpt_Complains_By_Call_Center"; break;
case 5: Stored = "Bi_rpt_Complains_By_Division"; break;
case 7: Stored = "Bi_rpt_in_process"; break;
case 8: Stored = "Bi_Rpt_Complains_by_CompanyName"; break;
}
return(DataTableToJsonObj(DirectSqlDao.GetAllStored_Datatable(Stored, param)));
}
public static List <OCPB.Service.Model.GetComplainTimeLineResult> GetTimelineHeader_From_Dep(int CompID)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@CompID", CompID);
return(DirectSqlDao.GetAllStored <OCPB.Service.Model.GetComplainTimeLineResult>("GetTimelineHeader_From_Dep", param));
}
// POST api/integration
public string Post([FromBody] string value)
{
SqlParameter[] param = new SqlParameter[0];
return(DataTableToJsonObj(DirectSqlDao.GetAllStored_Datatable("Bi_rpt_Complain_Dept", param)));
}
