public static ResponseQueryPopUp GetDataPopUp(string vdr, int?sku) { if (string.IsNullOrEmpty(vdr) && sku == null) { return(null); } var result = new ResponseQueryPopUp(); var list = Data.Management.APPLE_SP_ARTICULOS.GetData(vdr, sku); if (list.Count == 0) { return(null); } result.VDR_PARTNB = list[0].VDR_PARTNB; result.SKU = list[0].SKU; result.SKU_DESC = list[0].SKU_DESC; result.VDR_NAME = list[0].VDR_NAME; result.STOCK = list[0].STOCK; result.NET_AMOUNT = list[0].NET_AMOUNT; result.TAX_AMOUNT = list[0].TAX_AMOUNT; result.TOTAL_AMOUNT = list[0].TOTAL_AMOUNT; if (list[0].TIMESTAMP != null) { result.TIMESTAMP = list[0].TIMESTAMP.Value.AddHours(int.Parse(Utilities.Parameter.GetValue("TIMESTAMP_CAB"))); } else { result.TIMESTAMP = null; } var resultList = Data.Management.TBL_DATA_ARTICLES.GetQueryHistory(result.VDR_PARTNB, result.SKU); result.Result = new List <Domain.TBL_DATA_ARTICLES>(); foreach (var r in resultList) { var nr = new Domain.TBL_DATA_ARTICLES(); nr.CDG_ID = r.CDG_ID; nr.LAST = r.LAST; nr.NET_AMOUNT = r.NET_AMOUNT; nr.SKU = r.SKU; nr.STOCK = r.STOCK; nr.TAX_AMOUNT = r.TAX_AMOUNT; nr.TIMESTAMP = r.TIMESTAMP.AddHours(int.Parse(Utilities.Parameter.GetValue("TIMESTAMP"))); nr.TOTAL_AMOUNT = r.TOTAL_AMOUNT; nr.USER_CDG_ID = r.USER_CDG_ID; nr.USER_NAME = r.USER_NAME; nr.VDR_PARTNB = r.VDR_PARTNB; result.Result.Add(nr); } return(result); }
public static string[] RefreshData(string vdr, int sku, int usuarioId, string userName) { var response = Services.LoadData.QueryStock(vdr, sku); var update = Data.Management.TBL_DATA_ARTICLES.GetDetail(vdr, sku); if (update != null) { Data.Management.TBL_DATA_ARTICLES.UpdateLast(update.CDG_ID); } var dataNew = new Domain.TBL_DATA_ARTICLES(); dataNew.SKU = sku.ToString(); dataNew.VDR_PARTNB = vdr; dataNew.NET_AMOUNT = response.NetAmount; dataNew.TAX_AMOUNT = response.TaxAmount; dataNew.TOTAL_AMOUNT = response.TotalAmount; dataNew.STOCK = response.Stock; dataNew.USER_CDG_ID = usuarioId; dataNew.USER_NAME = userName; int dataId = Data.Management.TBL_DATA_ARTICLES.Save(dataNew); var estado = ""; if (response.Error == (byte)Services.Response.ErrorType.CORRECTO) { Data.Management.TBL_LOG.Create(dataId, usuarioId, "Consulta producto: vdr(" + vdr + ") sku(" + sku + ") Resultado: " + Services.Response.ErrorType.CORRECTO.ToString(), ""); estado = Services.Response.ErrorType.CORRECTO.ToString(); } else if (response.Error == (byte)Services.Response.ErrorType.EXCEPCION) { Data.Management.TBL_LOG.Create(dataId, usuarioId, "Consulta producto: vdr(" + vdr + ") sku(" + sku + ") Resultado: " + Services.Response.ErrorType.EXCEPCION.ToString(), response.Message); estado = Services.Response.ErrorType.EXCEPCION.ToString(); } else if (response.Error == (byte)Services.Response.ErrorType.ERROR) { Data.Management.TBL_LOG.Create(dataId, usuarioId, "Consulta producto: vdr(" + vdr + ") sku(" + sku + ") Resultado: " + Services.Response.ErrorType.ERROR.ToString(), response.Message); estado = Services.Response.ErrorType.ERROR.ToString(); } return(new string[2] { estado, response.Message }); }
public static int Save(Domain.TBL_DATA_ARTICLES detail) { try { var db = new Data.Access.Context(); detail.LAST = (byte)Domain.Enums.LAST_REGISTER.ENABLED; detail.TIMESTAMP = DateTime.Now; db.TBL_DATA_ARTICLES.Add(detail); db.SaveChanges(); var id = db.TBL_DATA_ARTICLES.OrderByDescending(d => d.CDG_ID).First().CDG_ID; return(id); } catch (Exception ex) { TBL_ERROR.Create(ex, Utilities.Basic.GetCurrentMethod(), "Inventory.Data.Management.TBL_DATA_ARTICLES"); return(0); } }