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