public ActionResult ListDetail(ParamListDetail model)
{
ChangeDukcapilProvider changeDukcapilProvider = new ChangeDukcapilProvider();
var result = changeDukcapilProvider.get(model);
return(Json(result));
}
public ActionResult ListDetail(ParamListDetail model)
{
TaskInquiryViewProvider taskInquiryProvider = new TaskInquiryViewProvider();
var result = taskInquiryProvider.get(model);
return(Json(result));
}
public List <ListTaskViewModel> get(ParamListDetail model)
{
List <ListTaskViewModel> ListData = new List <ListTaskViewModel>();
var connectionString = context.Database.GetDbConnection().ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
var pPriorityLevel = string.Join(",", model.pPriorityLevel);
//foreach (var item in model.pPriorityLevel)
//{
// pPriorityLevel = pPriorityLevel + "|" + item;
//}
//Declare COnnection
var querySstring = "spMKT_POLO_TASK_INQUIRY_LIST_VIEW";
SqlCommand command = new SqlCommand(querySstring, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
//Define Query Parameter
command.Parameters.AddWithValue("@pRegion", model.pRegion);
command.Parameters.AddWithValue("@pFPName", model.pFPName);
command.Parameters.AddWithValue("@pBranchName", model.pBranchName);
command.Parameters.AddWithValue("@pEmpPosition", model.pEmpPosition);
command.Parameters.AddWithValue("@pTaskID", model.pTaskID);
command.Parameters.AddWithValue("@pStatProspek", model.pStatProspek);
command.Parameters.AddWithValue("@pAppID", model.pAppID);
command.Parameters.AddWithValue("@pPriorityLevel", pPriorityLevel);
command.Parameters.AddWithValue("@pCustName", model.pCustName);
command.Parameters.AddWithValue("@pStatDukcapil", model.pStatDukcapil);
command.Parameters.AddWithValue("@pSdate", model.pSdate);
command.Parameters.AddWithValue("@pEdate", model.pEdate);
command.Parameters.AddWithValue("@pSourceData", model.pSourceData);
command.Parameters.AddWithValue("@pEmpNo", model.pEmpNo);
//open Connection
command.Connection.Open();
//PRoses Sp
SqlDataReader rd = command.ExecuteReader();
while (rd.Read())
{
ListTaskViewModel data = new ListTaskViewModel();
data.sourceData = rd[0].ToString();
data.cabang = rd[1].ToString();
data.regional = rd[2].ToString();
data.taskID = rd[3].ToString();
data.jenisTask = rd[4].ToString();
data.customerID = rd[5].ToString();
data.customerName = rd[6].ToString();
try
{
data.distributedDT = Convert.ToDateTime(rd[7].ToString()).ToString("dd/MM/yyyy HH:mm:ss.mmm");
}
catch
{
data.distributedDT = rd[7].ToString();
}
try
{
data.startedDT = Convert.ToDateTime(rd[8].ToString()).ToString("dd/MM/yyyy HH:mm:ss.mmm");
}
catch
{
data.startedDT = rd[8].ToString();
}
data.slaRemaining = rd[9].ToString();
data.fieldPersonName = rd[10].ToString();
data.empPosition = rd[11].ToString();
data.statusProspek = rd[12].ToString();
data.priorityLevel = rd[13].ToString();
data.aplikasiAI = rd[14].ToString();
data.applicationID = rd[15].ToString();
data.statusMSS = rd[16].ToString();
data.statusWISE = rd[17].ToString();
data.statusDukcapil = rd[18].ToString();
data.soa = rd[19].ToString();
data.referentorName = rd[20].ToString();
data.referentorName2 = rd[21].ToString();
data.orderInID = rd[22].ToString();
ListData.Add(data);
}
//Connection Close
command.Connection.Close();
}
return(ListData);
}
