Ejemplo n.º 1
0
        public void UpdateDetail(DetailDTO detailDTO)
        {
            Mapper.Initialize(cfg => cfg.CreateMap <DetailDTO, Detail>());
            Detail newdetail = Mapper.Map <DetailDTO, Detail>(detailDTO);

            if (detailDTO.DetailId == 0)
            {
                Database.Details.Create(newdetail);
            }
            else
            {
                Detail detail = Database.Details.Get(newdetail.DetailId);
                if (detail != null)
                {
                    detail.DetailId         = newdetail.DetailId;
                    detail.NomenclativeCode = newdetail.NomenclativeCode;
                    detail.DetailName       = newdetail.DetailName;
                    detail.SpecialConside   = newdetail.SpecialConside;
                    detail.DetailCount      = newdetail.DetailCount;
                    detail.DateAdded        = newdetail.DateAdded;
                    detail.StockmanId       = newdetail.StockmanId;
                    detail.Stockman         = newdetail.Stockman;
                    Database.Details.Update(detail);
                }
            }
        }
Ejemplo n.º 2
0
        public async Task <bool> AddAsync(DetailDTO detailDTO)
        {
            var detail = _mapper.Map <DetailDTO, Detail>(detailDTO);
            var result = await _detailRepository.Add(detail);

            return(result);
        }
        public ActionResult <Detail> PostDetail(DetailDTO detailDTO)
        {
            Detail detailToCreate = new Detail(detailDTO.LangeBeschrijving, detailDTO.BewoonbareOppervlakte, detailDTO.TotaleOppervlakte, detailDTO.EPCWaarde, detailDTO.KadastraalInkomen);

            _detailRepository.Add(detailToCreate);
            _detailRepository.SaveChanges();

            return(CreatedAtAction(nameof(GetDetail), new { id = detailToCreate.DetailID }, detailToCreate));
        }
Ejemplo n.º 4
0
        //[HttpGet]
        public ActionResult DeleteDetail(int id)
        {
            DetailDTO deletedDTO = detailService.GetDetailById(id);

            if (deletedDTO != null)
            {
                return(PartialView("DeleteDetail", deletedDTO));
            }
            return(View("Index"));
        }
Ejemplo n.º 5
0
        public async Task <ActionResult <DetailDTO> > Put(DetailDTO detailDTO)
        {
            if (detailDTO == null)
            {
                return(BadRequest());
            }

            await _detailService.UpDateAsync(detailDTO);

            return(Ok(detailDTO));
        }
Ejemplo n.º 6
0
 public async Task <IActionResult> Post([FromBody] DetailDTO value)
 {
     try
     {
         return(Ok(await _iEFDetail.AddDetails(value)));
     }
     catch
     {
         return(StatusCode(404));
     }
 }
Ejemplo n.º 7
0
        public async Task <IActionResult> Put([FromBody] DetailDTO value)
        {
            try
            {
                await _iEFDetail.UpdateDetails(value);

                return(StatusCode(204));
            }
            catch
            {
                return(StatusCode(404));
            }
        }
Ejemplo n.º 8
0
        public ActionResult Edit(int id)
        {
            DetailDTO det = detailService.GetDetailById(id);

            Mapper.Initialize(cfg => cfg.CreateMap <DetailDTO, DetailViewModel>());
            var detailview = Mapper.Map <DetailDTO, DetailViewModel>(det);

            if (detailview != null)
            {
                GetSelectListStockmen();
                return(PartialView(detailview));
            }
            return(View("Index"));
        }
Ejemplo n.º 9
0
        public ActionResult DeleteConfirmed(int id)
        {
            DetailDTO deletedDTO = detailService.GetDetailById(id);

            if (deletedDTO == null)
            {
                return(HttpNotFound());
            }
            if (deletedDTO != null)
            {
                DetailDTO deleted = detailService.DeleteDetail(id);
            }
            return(RedirectToAction("Index"));
        }
Ejemplo n.º 10
0
        public async Task <IActionResult> OnGetAsync(int?id)
        {
            if (id == null)
            {
                return(NotFound());
            }

            DetailDTO = await _context.DetailDTO.FirstOrDefaultAsync(m => m.Id == id);

            if (DetailDTO == null)
            {
                return(NotFound());
            }
            return(Page());
        }
Ejemplo n.º 11
0
        public async Task <IActionResult> OnPostAsync(int?id)
        {
            if (id == null)
            {
                return(NotFound());
            }

            DetailDTO = await _context.DetailDTO.FindAsync(id);

            if (DetailDTO != null)
            {
                _context.DetailDTO.Remove(DetailDTO);
                await _context.SaveChangesAsync();
            }

            return(RedirectToPage("./Index"));
        }
Ejemplo n.º 12
0
        public void InsertDetail(DetailDTO detailDTO)
        {
            Stockman stockman = Database.Stockmen.Get(detailDTO.StockmanId);

            // валидация
            if (stockman == null)
            {
                throw new ValidationException("Кладовщик не найден", "");
            }
            if (detailDTO.NomenclativeCode != null)
            {
                String input = @"^[a-zA-Z]{3}-\d{6}$";
                if (Regex.IsMatch(detailDTO.NomenclativeCode, input))
                {
                    Detail detail = new Detail
                    {
                        DetailId         = detailDTO.DetailId,
                        NomenclativeCode = detailDTO.NomenclativeCode,
                        DetailName       = detailDTO.DetailName,
                        SpecialConside   = detailDTO.SpecialConside,
                        DetailCount      = detailDTO.DetailCount,
                        DateAdded        = detailDTO.DateAdded,
                        StockmanId       = stockman.StockmanId,
                        Stockman         = stockman
                    };
                    Database.Details.Create(detail);
                    Database.Save();
                }
                else
                {
                    throw new ValidationException("Номенклатурный код не соответствует шаблону", "");
                }
            }
            else
            {
                throw new ValidationException("Заполните номенклатурный код", "");
            }
        }
        public async Task <string> AddDetails(DetailDTO detail)
        {
            DetailValidator  validator = new DetailValidator();
            ValidationResult results   = validator.Validate(detail);

            var x = _mapper.Map <DetailDTO, Detail>(detail);

            if (!results.IsValid)
            {
                foreach (var failure in results.Errors)
                {
                    string error = ("Property " + failure.PropertyName + " failed validation. Error was: " + failure.ErrorMessage);
                    return(error);
                }
                return("Error");
            }
            else
            {
                await _eFUnitOfWork.EFDetailRepository.Add(x);

                return("Деталь успішно добавлено!");
            }
        }
        public static Detail FromDTO(DetailDTO dto)
        {
            var detail = Mapper.Map <Detail>(dto);

            return(detail);
        }
Ejemplo n.º 15
0
        public async Task <ActionResult <DetailDTO> > Post([FromBody] DetailDTO detailDTO)
        {
            await _detailService.UpDateAsync(detailDTO);

            return(Ok(detailDTO));
        }
Ejemplo n.º 16
0
 public static Detail Map(DetailDTO dto) => new Detail(dto);
Ejemplo n.º 17
0
        public DetailDTO insertSaleNote(Note note, List <Detail> details)
        {
            using (var sqlConnection = new SqlConnection(conexion))
            {
                sqlConnection.Open();
                DetailDTO detailDTO = new DetailDTO();
                using (var transaction = sqlConnection.BeginTransaction())
                {
                    try
                    {
                        note.typeNote = 2;
                        string sqlInsertNote = "insert into tblNotes (nroNote,dateNote,description,total,typeNote,idCompany,idUser,idVoucher) values (@nroNote,@dateNote," +
                                               "@description,@total,@typeNote,@idCompany,@idUser,@idVoucher)SELECT SCOPE_IDENTITY()";
                        var    idRes   = sqlConnection.ExecuteScalar(sqlInsertNote, note, transaction: transaction);
                        int    idNote  = Convert.ToInt32(idRes);
                        string getNote = "select * from tblNotes where idNote = " + idNote;
                        Note   noteGet = sqlConnection.Query <Note>(getNote, commandType: System.Data.CommandType.Text, transaction: transaction).FirstOrDefault();
                        detailDTO.note = noteGet;
                        if (details.Count > 0)
                        {
                            var dateEntry = DateTime.Now;
                            foreach (var detail in details)
                            {
                                detail.dateEntry = dateEntry;
                                detail.idNote    = idNote;
                                detail.idVoucher = 1;
                                string sqlInsertLote = "insert into tblDetail (idArticle,nroLote,idNote,quantityDetail,priceSale,idVoucher)" +
                                                       " values (@IdArticle,@nroLote,@idNote,@quantityDetail,@priceSale,@idVoucher)";
                                sqlConnection.Execute(sqlInsertLote, detail, transaction: transaction);
                                ////Edit Article
                                string updateArticle = "update tblArticles set quantity = quantity -" + detail.quantityDetail + " where idArticle = " + detail.idArticle;
                                sqlConnection.Execute(updateArticle, transaction: transaction);
                            }
                            detailDTO.details = details;
                        }
                        //Obtengo la configuracion de las cuentas para generar el comprobante
                        string getConfiguration = "select * from tblConIntegration where idCompany = " + note.idCompany + " and isIntegration = 1";
                        ConfigurationIntegration configurationIntegration = sqlConnection.Query <ConfigurationIntegration>(getConfiguration, transaction: transaction).FirstOrDefault();

                        //Obtengo la moneda actual
                        string getCurrencyMain = "select * from tblCompanyCurrency where idCompany = " + note.idCompany + " and active = 1 ";
                        var    currency        = sqlConnection.Query <CompanyCurrency>(getCurrencyMain, commandType: System.Data.CommandType.Text, transaction: transaction).FirstOrDefault();

                        if (configurationIntegration == null)
                        {
                            transaction.Commit();
                            detailDTO.response = new Response {
                                Done = true, Message = "Creado exitosamente", Value = 0
                            };
                            return(detailDTO);
                        }
                        Voucher voucher = new Voucher();
                        voucher.dateVoucher  = note.dateNote;
                        voucher.gloss        = "Venta de Mercaderias";
                        voucher.typeVoucher  = 1;
                        voucher.tc           = currency.exchange;
                        voucher.idUser       = 1;
                        voucher.idCompany    = note.idCompany;
                        voucher.idCurrency   = currency.idCurrencyMain;
                        voucher.serieVoucher = getIdNext(note.idCompany);
                        List <VoucherDetail> listVoucher = new List <VoucherDetail>();

                        VoucherDTO voucherDTO = _voucher.sendAll(voucher, makeListVoucherSale(configurationIntegration, note.total, voucher.idVoucher));
                        if (voucherDTO.response.Done == true)
                        {
                            transaction.Commit();
                            detailDTO.details  = details;
                            detailDTO.response = new Response {
                                Done = true, Message = "Creado exitosamente", Value = 0
                            };
                            return(detailDTO);
                        }
                        else
                        {
                            transaction.Rollback();
                            detailDTO.response = new Response {
                                Done = false, Message = voucherDTO.response.Message, Value = 0
                            };
                            return(detailDTO);
                        }
                    }catch (Exception e)
                    {
                        transaction.Rollback();
                        detailDTO.response = new Response {
                            Done = false, Message = "Error", Value = 0
                        };
                        return(detailDTO);
                    }
                }
            }
        }
 public async Task UpdateDetails(DetailDTO detail)
 {
     var x = _mapper.Map <DetailDTO, Detail>(detail);
     await _eFUnitOfWork.EFDetailRepository.Update(x);
 }