public PrinterDTO Adicionar(PrinterDTO dto) { try { BaseDados.ComandText = "stp_SIS_PRINTERS_ADICIONAR"; BaseDados.AddParameter("@CODIGO", dto.Codigo); BaseDados.AddParameter("@NOME", dto.Sigla); BaseDados.AddParameter("@DESCRICAO", dto.Descricao); BaseDados.AddParameter("@IP", dto.AddressIP); BaseDados.AddParameter("@PATH", dto.NetworkPath); BaseDados.AddParameter("@UTILIZADOR", dto.Utilizador); BaseDados.ExecuteNonQuery(); dto.Sucesso = true; } catch (Exception ex) { dto.Sucesso = false; dto.MensagemErro = ex.Message.Replace("'", ""); } finally { BaseDados.FecharConexao(); } return(dto); }
public ActionResult Edit(PrinterDTO req) { Response res = new Response(); if (ModelState.IsValid) { try { if (req.Id > 0) { res.Data = _printerRepository.Update(req); } else { res.Data = _printerRepository.Create(req); } } catch (Exception ex) { res.Message = ex.Message; } } else { res.Data = false; res.Message = string.Join(",", ModelState .SelectMany(ms => ms.Value.Errors) .Select(e => e.ErrorMessage)); } return(Json(res, JsonRequestBehavior.AllowGet)); }
public ActionResult UpdatePrinter(PrinterDTO Prnt) { int cnt = posMasters.UpdatePrinter(Prnt); return(new JsonResult { Data = cnt, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult DeletePrinter(PrinterDTO Prnt) { var c = posMasters.DeletePrinter(Prnt.PrinterId); return(new JsonResult { Data = c, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
private Printer ConvertToModel(PrinterDTO info) { if (info == null) { return(null); } return(AutoMapper.Mapper.Map <Printer>(info)); }
public ActionResult SavePrinter(PrinterDTO Prnt) { Prnt.statusid = 1; Prnt.createdby = Convert.ToInt64(Session["UserId"]); int Cnt = posMasters.SavePrinter(Prnt); return(new JsonResult { Data = Cnt, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public PrinterDTO GetModel(int id) { using (var db = new SqlSugarClient(Connection)) { PrinterDTO result = null; if (id == 0) { return(result); } var data = db.Queryable <Printer>().InSingle(id); result = ConvertToInfo(data); return(result); } }
public bool Create(PrinterDTO printer) { using (var db = new SqlSugarClient(Connection)) { bool result = true; Printer model = ConvertToModel(printer); model.RealStatus = PrintStatus.正常; model.RealStatusRemark = ""; if (db.Insert(model) == null) { result = false; } return(result); } }
public bool Update(PrinterDTO dto) { using (var db = new SqlSugarClient(Connection)) { bool result = false; result = db.Update <Printer>( new { Name = dto.Name, Code = dto.Code, Remark = dto.Remark, PcName = dto.PcName, PrintPort = dto.PrintPort, IpAddress = dto.IpAddress, IsDelete = dto.IsDelete }, x => x.Id == dto.Id); return(result); } }
private PrinterDTO Map(tblEquipment tbl) { var dto = new PrinterDTO { MasterId = tbl.Id, DateCreated = tbl.IM_DateCreated, DateLastUpdated = tbl.IM_DateLastUpdated, StatusId = tbl.IM_Status, Name = tbl.Name, Code = tbl.Code, Description = tbl.Description, EquipmentNumber = tbl.EquipmentNumber, EquipmentTypeId = tbl.EquipmentType, HubId = tbl.CostCentreId, Make = tbl.Make, Model = tbl.Model }; return dto; }
public List <PrinterDTO> ObterPorFiltro() { List <PrinterDTO> lista = new List <PrinterDTO>(); try { BaseDados.ComandText = "stp_SIS_PRINTERS_OBTERTODAS"; MySqlDataReader dr = BaseDados.ExecuteReader(); while (dr.Read()) { PrinterDTO dto = new PrinterDTO { Codigo = int.Parse(dr[0].ToString()), Sigla = dr[1].ToString(), Descricao = dr[2].ToString(), AddressIP = dr[3].ToString(), NetworkPath = dr[2].ToString() }; lista.Add(dto); } } catch (Exception ex) { var orint = new PrinterDTO { Sucesso = false, MensagemErro = ex.Message.Replace("'", "") }; } finally { BaseDados.FecharConexao(); } return(lista); }
public Printer Map(PrinterDTO dto) { if (dto == null) return null; var printer = Mapper.Map<PrinterDTO, Printer>(dto); printer.CostCentre = _hubRepository.GetById(dto.HubId) as Hub; return printer; }
public PrinterDTO ObterPorPK(PrinterDTO dto) { return(ObterPorFiltro(dto).Where(t => t.Codigo == dto.Codigo).ToList().SingleOrDefault()); }
public List <PrinterDTO> ObterPorFiltro(PrinterDTO dto) { return(dao.ObterPorFiltro()); }
public void Remover(PrinterDTO dto) { }
public PrinterDTO Salvar(PrinterDTO dto) { return(dao.Adicionar(dto)); }