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));
}
