public IActionResult Edit(int id, CarrierDto carrierDto)
{
log.Info(nameof(Edit) + ":Post");
if (id != carrierDto.Id)
{
log.Warn(nameof(Edit) + " id is not equal to carrierDto.Id");
return(NotFound());
}
try
{
if (ModelState.IsValid)
{
carrierService.Update(carrierDto);
return(RedirectToAction(nameof(Index)));
}
return(View(carrierDto));
}
catch (Exception e)
{
log.Error(e);
return(BadRequest());
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (tbNameCarrier.Text == "")
{
tbNameCarrier.BorderBrush = Brushes.Red;
return;
}
try
{
if ((!string.IsNullOrEmpty(tbNameCarrier.Text)))
{
CarrierDto countr = new CarrierDto();
countr.NameCarrier = tbNameCarrier.Text;
countr.TimeCarrier = cbDataSet.Text;
ICarrierProcessDb workProcess = ProcessFactory.GetCarrierProcess();
if (_id == 0)
{
workProcess.Add(countr);
}
else
{
countr.IDCarrier = _id;
workProcess.Add(countr);
}
}
}
catch
{
}
Close();
}
private static List <Triple> ConvertCarrier(CarrierDto carrier)
{
return(new TripleBuilder(nodeFactory.AsBlankNode(carrier.NodeId))
.Add(nodeFactory.AsUriNode(Constants.Predicates.Type), nodeFactory.AsValueNode(Constants.Types.Carrier))
.Add(nodeFactory.AsUriNode(Constants.Predicates.CarrierCode), nodeFactory.AsValueNode(carrier.Code))
.Add(nodeFactory.AsUriNode(Constants.Predicates.CarrierDescription), nodeFactory.AsValueNode(carrier.Description))
.Build());
}
public void Load(CarrierDto carrier)
{
if (carrier == null)
{
return;
}
_id = carrier.IDCarrier;
tbNameCarrier.Text = carrier.NameCarrier;
}
public static Carrier Convert(CarrierDto carrierDto)
{
if (carrierDto == null)
{
return(null);
}
Carrier carrier = new Carrier();
carrier.IDCarrier = carrierDto.IDCarrier;
carrier.NameCarrier = carrierDto.NameCarrier;
carrier.TimeCarrier = carrierDto.TimeCarrier;
return(carrier);
}
public void Update(CarrierDto carrierDto)
{
var validationResult = carrierValidator.Validate(carrierDto);
if (!validationResult.IsValid)
{
throw new ArgumentException(validationResult.Errors.First().ErrorMessage);
}
var carrier = mapper.Map <CarrierDto, Carrier>(carrierDto);
uow.Carriers.Update(carrier);
uow.Save();
}
private void btnEditC_Click(object sender, RoutedEventArgs e)
{
CarrierDto item = dgCarrier.SelectedItem as CarrierDto;
if (item == null)
{
MessageBox.Show("Выберите запись для редактирования", "Редактирование");
return;
}
AddCarrier window = new AddCarrier();
window.Load(item);
window.ShowDialog();
btnUpdateTC_Click(sender, e);
}
public IActionResult CreateCarrier([FromBody, SwaggerRequestBody("Carrier payload", Required = true)] CarrierDto carrierDto)
{
log.Info(nameof(CreateCarrier));
try
{
carrierService.Create(carrierDto);
return(Created(nameof(GetCarrierById), carrierDto));
}
catch (Exception e)
{
log.Error(e);
return(BadRequest());
}
}
public CarrierServiceTests()
{
var mockRepository = new Mock <IRepository <Carrier, int> >();
var mockUnitOfWork = new Mock <IUnitOfWork>();
fakeCarriers = new List <Carrier>
{
new Carrier {
Id = 1, Name = "Carrier1", Phone = "380990112347", Address = "Some addr1", IBAN = "100023333113"
},
new Carrier {
Id = 5, Name = "Carrier5", Phone = "+380990136974", Address = "Some addr5", IBAN = "108233113"
},
new Carrier {
Id = 2, Name = "Carrier2", Phone = "+38(099)0136974", Address = "Some addr2", IBAN = "4655644242244"
},
new Carrier {
Id = 6, Name = "Carrier6", Phone = "0990136974", Address = "1", IBAN = "424252522424"
}
};
carrierDto = new CarrierDto
{
Id = 4,
Name = "Carrier4",
Phone = "+38(099)0136974",
Address = "Some addr4",
IBAN = "44423333113"
};
mockRepository.Setup(m => m.GetAll())
.Returns(fakeCarriers.AsQueryable);
mockRepository.Setup(m => m.Get(It.IsAny <int>()))
.Returns <int>(id => fakeCarriers.Single(t => t.Id == id));
mockRepository.Setup(r => r.Create(It.IsAny <Carrier>()))
.Callback <Carrier>(t => fakeCarriers.Add(carrier = t));
mockRepository.Setup(r => r.Update(It.IsAny <Carrier>()))
.Callback <Carrier>(t => carrier = t);
mockRepository.Setup(x => x.Delete(It.IsAny <int>()))
.Callback <int>(id => fakeCarriers.Remove(fakeCarriers.Single(t => t.Id == id)));
mockUnitOfWork.Setup(m => m.Carriers).Returns(mockRepository.Object);
carrierService = new CarrierService(mockUnitOfWork.Object);
}
private void btnDeleteC_Click(object sender, RoutedEventArgs e)
{
CarrierDto item = dgCarrier.SelectedItem as CarrierDto;
if (item == null)
{
MessageBox.Show("Выберите запись для удаления", "Удаление носителя");
return;
}
MessageBoxResult result = MessageBox.Show("Удалить " + item.NameCarrier + "?", "Удаление носителя", MessageBoxButton.YesNo, MessageBoxImage.Warning);
if (result != MessageBoxResult.Yes)
{
return;
}
ProcessFactory.GetCarrierProcess().Delete(item.IDCarrier);
btnUpdateTC_Click(sender, e);
}
public IActionResult Create(CarrierDto carrierDto)
{
log.Info(nameof(Create) + ":Post");
try
{
if (ModelState.IsValid)
{
carrierService.Create(carrierDto);
return(RedirectToAction(nameof(Index)));
}
return(View(carrierDto));
}
catch (Exception e)
{
log.Error(e);
return(BadRequest());
}
}
public IActionResult UpdateCarrier([SwaggerParameter("Int", Required = true)] int id, [FromBody, SwaggerRequestBody("Carrier payload", Required = true)] CarrierDto carrierDto)
{
log.Info(nameof(UpdateCarrier));
try
{
if (id != carrierDto.Id)
{
log.Warn(nameof(UpdateCarrier) + " id is not equal to carrierDto.Id");
return(BadRequest());
}
carrierService.Update(carrierDto);
return(NoContent());
}
catch (Exception e)
{
log.Error(e);
return(BadRequest());
}
}
public void Add(CarrierDto carrier)
{
_carrierDao.Add(DtoConvert.Convert(carrier));
}
public void fillExcelTableByType(IEnumerable <object> grid, string status, FileInfo xlsxFile)
{
try
{
if (grid != null)
{
ExcelPackage pck = new ExcelPackage(xlsxFile);
var excel = pck.Workbook.Worksheets.Add(status);
int x = 1;
int y = 1;
CultureInfo cultureInfo = new CultureInfo(Thread.CurrentThread.CurrentCulture.Name);
Thread.CurrentThread.CurrentCulture = cultureInfo;
cultureInfo.NumberFormat.NumberDecimalSeparator = ".";
excel.Cells["A1:Z1"].Style.Font.Bold = true;
excel.Cells.Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
excel.Cells.Style.Numberformat.Format = "General";
Object dtObj = new Object();
switch (status)
{
case "Managers": dtObj = new ManagersDto(); break;
case "Enterprises": dtObj = new EnterprisesDto(); break;
case "TypeReklama": dtObj = new TypeReklamaDto(); break;
case "Orders": dtObj = new OrdersDto(); break;
case "Carrier": dtObj = new CarrierDto(); break;
case "Wage": dtObj = new WageDto(); break;
}
foreach (var prop in dtObj.GetType().GetProperties())
{
excel.Cells[y, x].Value = prop.Name.Trim();
x++;
}
foreach (var item in grid)
{
y++;
Object itemObj = item;
x = 1;
foreach (var prop in itemObj.GetType().GetProperties())
{
object t = prop.GetValue(itemObj, null);
object val;
if (t == null)
{
val = "";
}
else
{
val = t.ToString();
if (t is ManagersDto)
{
val = ((ManagersDto)t).FullName;
}
if (t is EnterprisesDto)
{
val = ((EnterprisesDto)t).NameEnterprise;
}
if (t is CarrierDto)
{
val = ((CarrierDto)t).NameCarrier;
}
if (t is TypeReklamaDto)
{
val = ((TypeReklamaDto)t).NameReklama;
}
}
excel.Cells[y, x].Value = val;
x++;
}
}
excel.Cells.AutoFitColumns();
pck.Save();
}
else
{
MessageBox.Show("Данные не загружены!");
}
}
catch (Exception exc)
{
// MessageBox.Show(exc.Message, "Ошибка");
}
}
