public async Task <BaseResult <int> > InsertBoard(ListTaskViewModel model)
{
var listTask = _mapper.Map <TaskProject>(model);
await _reposProjectTask.InsertAsync(listTask);
return(BaseResult <int> .OK(listTask.Id, Messages.ItemInserted));
}
public async Task <HttpResponse <int> > InsertListTask(ListTaskViewModel model)
{
var repos = _unitOfWork.Repository <ListTask>();
var listTask = _mapper.Map <ListTask>(model);
await repos.InsertAsync(listTask);
return(HttpResponse <int> .OK(listTask.Id, Messages.ItemInserted));
}
public async Task <IActionResult> Update([FromBody] ListTask model, int id, ListTaskViewModel viewModel)
{
if (!ModelState.IsValid)
{
var errors = ModelState.Select(x => x.Value.Errors)
.Where(y => y.Count > 0)
.ToList();
return(BadRequest(errors));
}
var found = await context.ListTasks.FindAsync(id);
if (found != null)
{
found.Title = model.Title;
found.Desc = model.Desc;
found.UpdatedAt = DateTime.Now;
await context.SaveChangesAsync();
var history = new ProjectHistory()
{
ProjectId = model.ProjectId,
UserId = model.UserId,
Content = "Thay đổi danh sách công việc",
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
await context.ProjectHistories.AddAsync(history);
await context.SaveChangesAsync();
var FullName = await context.Users.Where(u => u.Id == model.UserId).Select(u => u.FullName).FirstAsync();
/*==============================
* Get projects and projectHistory
* ==============================*/
viewModel.Id = id;
viewModel.Title = model.Title;
viewModel.Desc = model.Desc;
viewModel.ProjectId = model.ProjectId;
viewModel.FullName = FullName;
viewModel.Content = history.Content;
viewModel.CreatedAt = viewModel.CreatedAt;
return(Ok(viewModel));
}
return(BadRequest("Không tồn tại list task"));
}
private ListTaskViewModel GetTaskViewModel(Task task, ListItemModelBase parent)
{
var taskViewModel = new ListTaskViewModel(task, parent, _dataService, _userRepository);
foreach (var timeEntry in task.TimeEntries)
{
var timeEntryViewModel = GetTimeEntryViewModel(timeEntry, taskViewModel);
if (timeEntryViewModel != null)
{
taskViewModel.Children.Add(timeEntryViewModel);
}
}
return(taskViewModel);
}
public async Task <BaseResult <int> > UpdateBoard(ListTaskViewModel model, int id)
{
var listTask = await _reposProjectTask.FindAsync(id);
if (listTask == null)
{
return(BaseResult <int> .Error(Messages.ActionFailed, statusCode : System.Net.HttpStatusCode.NoContent));
}
listTask.Name = model.Name;
listTask.ProjectId = model.ProjectId;
int saved = await _unitOfWork.SaveChangesAsync();
if (saved > 0)
{
return(BaseResult <int> .OK(listTask.Id, Messages.ItemUpdated));
}
return(BaseResult <int> .Error(Messages.ActionFailed, statusCode : System.Net.HttpStatusCode.BadRequest));
}
public async Task <HttpResponse <int> > UpdateListTask(ListTaskViewModel model, int id)
{
var repos = _unitOfWork.Repository <ListTask>();
var listTask = await repos.FindAsync(id);
if (listTask == null)
{
return(HttpResponse <int> .Error(Messages.ActionFailed, statusCode : System.Net.HttpStatusCode.NoContent));
}
listTask.Name = model.Name;
listTask.ProjectId = model.ProjectId;
int saved = await _unitOfWork.SaveChangesAsync();
if (saved > 0)
{
return(HttpResponse <int> .OK(listTask.Id, Messages.ItemUpdated));
}
return(HttpResponse <int> .Error(Messages.ActionFailed, statusCode : System.Net.HttpStatusCode.BadRequest));
}
public async Task <IActionResult> Delete(int id, int UserId, ListTaskViewModel viewModel)
{
var found = await context.ListTasks.FindAsync(id);
if (found != null)
{
context.ListTasks.Remove(found);
await context.SaveChangesAsync();
var history = new ProjectHistory()
{
ProjectId = found.ProjectId,
UserId = found.UserId,
Content = "Xóa danh sách công việc",
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
await context.ProjectHistories.AddAsync(history);
await context.SaveChangesAsync();
var FullName = await context.Users.Where(u => u.Id == UserId).Select(u => u.FullName).FirstAsync();
/*==============================
* Get projects and projectHistory
* ==============================*/
viewModel.Id = id;
viewModel.Title = found.Title;
viewModel.Desc = found.Desc;
viewModel.ProjectId = found.ProjectId;
viewModel.FullName = FullName;
viewModel.Content = history.Content;
viewModel.CreatedAt = viewModel.CreatedAt;
return(Ok(viewModel));
}
return(BadRequest("Không tồn tại list task"));
}
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);
}
public async Task <IActionResult> UpdateBoard([FromBody] ListTaskViewModel model, [FromRoute] int boardId)
{
var response = await _taskService.UpdateBoard(model, boardId);
return(StatusCode(response));
}
public async Task <IActionResult> InsertBoard([FromBody] ListTaskViewModel model)
{
var response = await _taskService.InsertBoard(model);
return(StatusCode(response));
}
public async Task <IActionResult> UpdateListTask([FromBody] ListTaskViewModel model, int id)
{
var response = await _taskService.UpdateListTask(model, id);
return(StatusCode(response));
}
public List <ListTaskViewModel> UploadData(UploadViewModel model, string guid)
{
List <ListTaskViewModel> ListData = new List <ListTaskViewModel>();
var connectionString = context.Database.GetDbConnection().ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
var querySstring = "spMKT_POLO_UPLOAD_STATUS_TASK";
SqlCommand command = new SqlCommand(querySstring, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
//Define Query Parameter
command.Parameters.AddWithValue("@pOfficeCode", model.CabId);
command.Parameters.AddWithValue("@pOfficeName", model.BranchName);
command.Parameters.AddWithValue("@pOfficeRegionCode", model.RegionalId);
command.Parameters.AddWithValue("@pOfficeRegionName", model.Region);
command.Parameters.AddWithValue("@pTaskID", model.TaskID);
command.Parameters.AddWithValue("@pJenisTask", model.JenisTask);
command.Parameters.AddWithValue("@pCustNo", model.CustID);
command.Parameters.AddWithValue("@pCustName", model.CustomerName);
command.Parameters.AddWithValue("@pDistributedDt", model.DistributedDate);
command.Parameters.AddWithValue("@pStartedDt", model.StartedDate);
command.Parameters.AddWithValue("@pEmpPosition", model.EmpPosition);
command.Parameters.AddWithValue("@pSoa", model.soa);
command.Parameters.AddWithValue("@pReferentor1", model.Referentor1);
command.Parameters.AddWithValue("@pProduct", model.Product);
command.Parameters.AddWithValue("@pIdNo", model.NIK);
command.Parameters.AddWithValue("@pBirthPlace", model.TempatLahir);
command.Parameters.AddWithValue("@pBirthDt", model.TglLahir);
command.Parameters.AddWithValue("@pRwLeg", model.RWLeg);
command.Parameters.AddWithValue("@pProvinsiLeg", model.ProvLeg);
command.Parameters.AddWithValue("@pKabupatenLeg", model.KabLeg);
command.Parameters.AddWithValue("@pKecamatanLeg", model.KecLeg);
command.Parameters.AddWithValue("@pKelurahanLeg", model.KelLeg);
command.Parameters.AddWithValue("@pAlamatRes", model.AlamatRes);
command.Parameters.AddWithValue("@pRtRes", model.RTRes);
command.Parameters.AddWithValue("@pRwRes", model.RWRes);
command.Parameters.AddWithValue("@pProvinsiRes", model.ProvRes);
command.Parameters.AddWithValue("@pKabupatenRes", model.KabRes);
command.Parameters.AddWithValue("@pKecamatanRes", model.KecRes);
command.Parameters.AddWithValue("@pKelurahanRes", model.KelRes);
command.Parameters.AddWithValue("@pMachineNo", model.NoMesin);
command.Parameters.AddWithValue("@pChassisNo", model.NoRangka);
command.Parameters.AddWithValue("@pItemType", model.ItemType);
command.Parameters.AddWithValue("@pItemDescription", model.ItemDescription);
command.Parameters.AddWithValue("@pMobile1", model.Mobile1);
command.Parameters.AddWithValue("@pMobile2", model.Mobile2);
command.Parameters.AddWithValue("@pPhone1", model.Phone1);
command.Parameters.AddWithValue("@pPhone2", model.Phone2);
command.Parameters.AddWithValue("@pOfficePhone1", model.OfficePhone1);
command.Parameters.AddWithValue("@pOfficePhone2", model.OfficePhone2);
command.Parameters.AddWithValue("@pOtrPrice", model.OtrPrice);
command.Parameters.AddWithValue("@pItemYear", model.ItemYear);
command.Parameters.AddWithValue("@pMonthIncome", model.MonthlyIncome);
command.Parameters.AddWithValue("@pMonthlyInstallment", model.MonthInstallment);
command.Parameters.AddWithValue("@pDownPayment", model.DP);
command.Parameters.AddWithValue("@pLtv", model.LTV);
command.Parameters.AddWithValue("@pPlafond", model.Plafond);
command.Parameters.AddWithValue("@pProfession", model.Pekerjaan);
command.Parameters.AddWithValue("@pOsTenor", model.SisaTenor);
command.Parameters.AddWithValue("@pTenorId", model.TenorId);
command.Parameters.AddWithValue("@pReleaseDateBpkb", model.ReleaseDateBpkb);
command.Parameters.AddWithValue("@pMaxPastDueDt", model.MaxPastDueDt);
command.Parameters.AddWithValue("@pReligion", model.Religion);
command.Parameters.AddWithValue("@pMaturityDt", model.MaturityDt);
command.Parameters.AddWithValue("@pTglJatuhTempo", model.TanggalJatuhTempo);
command.Parameters.AddWithValue("@pCallStat", model.StatusCall);
command.Parameters.AddWithValue("@pAnswerCall", model.AnswerCall);
command.Parameters.AddWithValue("@pCustRating", model.CustomerRating);
command.Parameters.AddWithValue("@pProspectStat", model.StatusProspek);
command.Parameters.AddWithValue("@pReasonNotProspek", model.ReasonNotProspek);
command.Parameters.AddWithValue("@pNotes", model.Notes);
command.Parameters.AddWithValue("@pQueueUid", guid);
command.Parameters.AddWithValue("@pEmpNo", model.EmpNo);
command.Parameters.AddWithValue("@pZipcodeLeg", model.KodePosLeg);
command.Parameters.AddWithValue("@pSubZipcodeLeg", model.SubZipcodeLeg);
command.Parameters.AddWithValue("@pZipcodeRes", model.KodePosRes);
command.Parameters.AddWithValue("@pSubZipcodeRes", model.SubZipcodeRes);
//open Connection
command.Connection.Open();
//PRoses Sp
SqlDataReader rd = command.ExecuteReader();
while (rd.Read())
{
ListTaskViewModel data = new ListTaskViewModel();
}
//Connection Close
command.Connection.Close();
}
return(ListData);
}
private ListTimeEntryViewModel GetTimeEntryViewModel(TimeEntry timeEntry, ListTaskViewModel parent)
{
return(new ListTimeEntryViewModel(timeEntry, parent, _dataService, _userRepository));
}
