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