public IActionResult CheckList(AuditDetails auditDetails)
{
try
{
var token = HttpContext.Request.Cookies["Token"]; //Get the value of Token from Cookie
if (token == null)
{
ViewBag.Message = "Session Expired !! Please Login ....";
return(View("Login"));
}
List <CheckListQuestion> questionList = new List <CheckListQuestion>();
CheckListService checkListService = new CheckListService(_configuration);
questionList = checkListService.GetQuestions(auditDetails.Type, token);
return(View(questionList));
}
catch (Exception e)
{
return(View("Error"));
}
}
private void CheckList_Activated(object sender, EventArgs e)
{
if (veiculo != null)
{
if (new CheckListService().Verificar(veiculo.CodigoVeiculo))
{
Dictionary <long, Object> itens = new CheckListService().Buscar(veiculo.CodigoVeiculo);
textBox_Veiculo.Text = veiculo.Modelo;
textBox_KM.Text = veiculo.KM;
comboBox_Tanque.Text = veiculo.Tanque;
foreach (RadioButton radio in radios)
{
foreach (ItemConformidade item in ((List <ItemConformidade>)itens[2]))
{
if (radio.Name == item.Item)
{
radio.Select();
}
}
}
dateTimePicker1.Text = ((VeiculoTemCheckList)itens[0]).DataChecagem;
textBox_Observacoes.Text = ((Persistencia.Modelo.CheckList)itens[1]).Observacao;
}
else
{
textBox_Veiculo.Text = veiculo.Modelo;
textBox_KM.Text = veiculo.KM;
comboBox_Tanque.Text = veiculo.Tanque;
}
}
}
/// <summary>
/// 조회
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearch_Click(object sender, EventArgs e)
{
cl_name = product_id = cl_stnd = cl_comment = cl_uadmin = cl_udate = cl_type = "";
cl_id = 0;
string checkType = "";
if (cboCheckType.SelectedIndex > 0)
{
checkType = cboCheckType.Text;
}
try
{
CheckListService service = new CheckListService();
chkList = service.SearchChkList(checkType);
if (chkList.Count == 0)
{
MessageBox.Show("조회 결과가 없습니다.");
return;
}
dgvCheckList.DataSource = chkList;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// DGV 바인딩
/// </summary>
private void DGV_Binding()
{
CheckListService service = new CheckListService();
chkList = service.GetChkList();
dgvCheckList.DataSource = chkList;
}
private void newBtns_btnDelete_Event(object sender, EventArgs e)
{
if (cl_id == 0)
{
MessageBox.Show("선택된 항목이 없습니다");
return;
}
try
{
CheckListService service = new CheckListService();
bool bResult = service.ChkDelete(cl_id);
if (bResult)
{
MessageBox.Show("선택항목이 삭제되었습니다");
}
else
{
MessageBox.Show("삭제중 오류가 발생했습니다 다시 시도해주세요");
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private async Task DeleteItemsAsync(IEnumerable <CheckListModel> models)
{
foreach (var model in models)
{
await CheckListService.DeleteCheckListAsync(model);
}
}
private void frmdefective_Load(object sender, EventArgs e)
{
string[] gubun = { "불량유형" };
CheckListService cService = new CheckListService();
List <ComboItemVO> allCheckType = cService.GetCheckTypeInfoByCodeTypes(gubun);
CommonUtil.ComboBinding(cboDef, allCheckType, "불량유형");
}
public CheckListServiceTest()
{
var builder = new DbContextOptionsBuilder <ChecklistBotContext>();
var b = InMemoryDbContextOptionsExtensions.UseInMemoryDatabase(builder, "Data Source=:memory:");
_context = new ChecklistBotContext(b.Options);
_service = new CheckListService(_context);
}
private async Task <IList <CheckListModel> > GetItemsAsync()
{
if (!ViewModelArgs.IsEmpty)
{
DataRequest <Data.CheckList> request = BuildDataRequest();
return(await CheckListService.GetCheckListsAsync(request));
}
return(new List <CheckListModel>());
}
/// <summary>
/// 콤보박스바인딩 이벤트
/// </summary>
private void comboBinding()
{
string[] gubun = { "검사구분" };
CheckListService cService = new CheckListService();
List <ComboItemVO> allCheckType = cService.GetCheckTypeInfoByCodeTypes(gubun);
ProductService pService = new ProductService();
List <ProdCBOBindingVO> allProItem = pService.GetProductInfo();
CommonUtil.ComboBinding(cboCheckType, allCheckType, "검사구분");
CommonUtil.ProdNameBinding(cboProductName, allProItem);
}
/// <summary>
/// 폼로드
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmCheckList_Load(object sender, EventArgs e)
{
string[] gubun = { "검사구분" };
CheckListService cService = new CheckListService();
List <ComboItemVO> allCheckType = cService.GetCheckTypeInfoByCodeTypes(gubun);
CommonUtil.ComboBinding(cboCheckType, allCheckType, "검사구분");
CommonUtil.SetInitGridView(dgvCheckList);
CommonUtil.AddGridTextColumn(dgvCheckList, "검사ID", "cl_id", 60);
CommonUtil.AddGridTextColumn(dgvCheckList, "검사명", "cl_name", 150);
CommonUtil.AddGridTextColumn(dgvCheckList, "품목ID", "product_id", 60);
CommonUtil.AddGridTextColumn(dgvCheckList, "품목명", "product_name", 150);
CommonUtil.AddGridTextColumn(dgvCheckList, "검사타입", "cl_type", 120);
CommonUtil.AddGridTextColumn(dgvCheckList, "기준", "cl_stnd", 100);
CommonUtil.AddGridTextColumn(dgvCheckList, "비고", "cl_comment", 150);
CommonUtil.AddGridTextColumn(dgvCheckList, "수정자", "cl_uadmin", 100);
CommonUtil.AddGridTextColumn(dgvCheckList, "수정일", "cl_udate", 150);
DGV_Binding();
}
public CheckListItemServiceTest()
{
_context = TestConfig.CreateTestContext();
_checklistService = new CheckListService(_context);
}
public async Task <IActionResult> GetAllCheckLists()
{
List <FMSDailyCheckListVM> checklist = new List <FMSDailyCheckListVM>();
try
{
List <string> vehicleNumbers = (from v in dbContext.Vehicles
join gv in dbContext.GBMSVehicles on v.VehicleNumber equals gv.Description
select gv.Description).ToList();
foreach (var vehicleNumber in vehicleNumbers)
{
IEnumerable <DailyMorning> fMSDailyMornings = from m in dbContext.DailyMorningChecks where m.VehicleNumber == vehicleNumber && m.LastUpdated.Date == (PakistanDateTime.Today) select m;
if (fMSDailyMornings.Any())
{
DailyMorning dailyMorning = fMSDailyMornings.FirstOrDefault();
checklist.Add(CheckListService.DailyMorningCheckListToViewModel(dailyMorning));
}
else
{
Vehicle vehicle = (from f in dbContext.Vehicles
join v in dbContext.GBMSVehicles on f.VehicleNumber equals v.Description
where v.Description == vehicleNumber
select f).SingleOrDefault();
Region region = (from r in dbContext.Regions
where r.XDescription == vehicle.Region
select r).SingleOrDefault();
SubRegion subRegion = (from s in dbContext.SubRegions
where s.XDescription == vehicle.SubRegion
select s).SingleOrDefault();
Station station = (from st in dbContext.Stations
where st.XDescription == vehicle.Station
select st).SingleOrDefault();
string DriverName = (from f in dbContext.Vehicles
join d in dbContext.Drivers on f.VehicleNumber equals d.VehicleNumber
join v in dbContext.GBMSVehicles on f.VehicleNumber equals v.Description
where v.Description == vehicleNumber
select d.Name).SingleOrDefault();
DailyMorning dailyMorning = new();
dailyMorning.Id = Guid.NewGuid();
dailyMorning.LastUpdated = PakistanDateTime.Now;
dailyMorning.VehicleNumber = vehicleNumber;
dailyMorning.DriverName = DriverName;
dailyMorning.Region = region.XDescription;
dailyMorning.Subregion = subRegion.XDescription;
dailyMorning.Station = station.XDescription;
await dbContext.DailyMorningChecks.AddAsync(dailyMorning);
await dbContext.SaveChangesAsync();
checklist.Add(CheckListService.DailyMorningCheckListToViewModel(dailyMorning));
}
IEnumerable <DailyEvening> fMSDailyEvenings = from e in dbContext.DailyEveningChecks where e.VehicleNumber == vehicleNumber && e.LastUpdated.Date == (PakistanDateTime.Today) select e;
if (fMSDailyEvenings.Any())
{
DailyEvening dailyEvening = fMSDailyEvenings.FirstOrDefault();
checklist.Add(CheckListService.DailyEveningEngineCheckListToViewModel(dailyEvening));
checklist.Add(CheckListService.DailyEveningBodyCheckListToViewModel(dailyEvening));
checklist.Add(CheckListService.DailyEveningInteriorCheckListToViewModel(dailyEvening));
checklist.Add(CheckListService.DailyEveningAcCheckListToViewModel(dailyEvening));
checklist.Add(CheckListService.DailyEveningGeneralCheckListToViewModel(dailyEvening));
}
else
{
Vehicle vehicle = (from f in dbContext.Vehicles
join v in dbContext.GBMSVehicles on f.VehicleNumber equals v.Description
where v.Description == vehicleNumber
select f).SingleOrDefault();
Region region = (from r in dbContext.Regions
where r.XDescription == vehicle.Region
select r).SingleOrDefault();
SubRegion subRegion = (from s in dbContext.SubRegions
where s.XDescription == vehicle.SubRegion
select s).SingleOrDefault();
Station station = (from st in dbContext.Stations
where st.XDescription == vehicle.Station
select st).SingleOrDefault();
string DriverName = (from f in dbContext.Vehicles
join d in dbContext.Drivers on f.VehicleNumber equals d.VehicleNumber
join v in dbContext.GBMSVehicles on f.VehicleNumber equals v.Description
where v.Description == vehicleNumber
select d.Name).SingleOrDefault();
DailyEvening dailyEvening = new DailyEvening();
dailyEvening.Id = Guid.NewGuid();
dailyEvening.LastUpdated = PakistanDateTime.Now;
dailyEvening.VehicleNumber = vehicleNumber;
dailyEvening.DriverName = DriverName;
dailyEvening.Region = region.XDescription;
dailyEvening.Subregion = subRegion.XDescription;
dailyEvening.Station = station.XDescription;
await dbContext.DailyEveningChecks.AddAsync(dailyEvening);
await dbContext.SaveChangesAsync();
checklist.Add(CheckListService.DailyEveningEngineCheckListToViewModel(dailyEvening));
checklist.Add(CheckListService.DailyEveningBodyCheckListToViewModel(dailyEvening));
checklist.Add(CheckListService.DailyEveningInteriorCheckListToViewModel(dailyEvening));
checklist.Add(CheckListService.DailyEveningAcCheckListToViewModel(dailyEvening));
checklist.Add(CheckListService.DailyEveningGeneralCheckListToViewModel(dailyEvening));
}
}
foreach (var check in checklist)
{
foreach (var point in check.Checklist)
{
IEnumerable <Complaint> complaint = from c in dbContext.Complaints
where c.VehicleNumber == check.VehicleNumber && c.PointCode == point.Code && c.IsActive
select c;
if (complaint.Any())
{
point.IsNotOk = true;
point.Value = DailyCheckStatus.NotOk;
}
}
}
return(Ok(checklist));
}
catch (Exception ex)
{
return(BadRequest(ex.ToString()));
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (cboProductName.SelectedIndex < 1 && cboCheckType.SelectedIndex < 1 && txtCheckListName.Text.Trim().Length < 1)
{
MessageBox.Show("필수항목을 채워주세요");
return;
}
try
{
if (headName == "검사항목등록")
{
CheckListVO chk = new CheckListVO
{
cl_name = txtCheckListName.Text,
product_id = cboProductName.SelectedValue.ToString(),
cl_type = cboCheckType.Text,
cl_stnd = txtStd.Text,
cl_comment = txtComment.Text,
cl_uadmin = txtUadmin.Text
};
CheckListService service = new CheckListService();
bool bResult = service.ChkInsert(chk);
if (bResult)
{
MessageBox.Show("새로운 검사항목을 등록하셨습니다");
}
else
{
MessageBox.Show("등록에 실패하셨습니다");
}
}
else if (headName == "검사항목수정")
{
CheckListVO chk = new CheckListVO
{
cl_id = cl_id,
cl_name = txtCheckListName.Text,
product_id = cboProductName.SelectedValue.ToString(),
cl_type = cboCheckType.Text,
cl_stnd = txtStd.Text,
cl_comment = txtComment.Text,
cl_uadmin = txtUadmin.Text
};
CheckListService service = new CheckListService();
bool bResult = service.ChkUpdate(chk);
if (bResult)
{
MessageBox.Show("검사항목을 수정하셨습니다");
}
else
{
MessageBox.Show("수정에 실패하셨습니다");
}
}
this.Close();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
