public bool UpdateOrder(OrderReqExtend items)
{
bool result = true;
try
{
if (items != null)
{
var getforUpdate = context.OrderReqs.FirstOrDefault(a => a.Code == items.Code);
if (getforUpdate != null)
{
getforUpdate.Status = items.Status;
getforUpdate.Observation = items.Observation;
context.Entry(getforUpdate).State = EntityState.Modified;
context.SaveChanges();
}
}
else
{
result = false;
}
}
catch (Exception ex)
{
result = false;
Debug.Write("Error " + ex.Message);
}
return(result);
}
public async Task <bool> UpdateOrder(OrderReqExtend codes)
{
bool result = false;
string url = "http://" + PATHSERVER + "/tshirt/productchange/SaveOrder";
try
{
var json = JsonConvert.SerializeObject(codes);
var content = new StringContent(json, Encoding.UTF8, "application/json");
HttpResponseMessage request = null;
request = await client.PostAsync(url, content);
if (request.IsSuccessStatusCode)
{
var x = await request.Content.ReadAsStringAsync();
result = JsonConvert.DeserializeObject <bool>(x);
}
}
catch (Exception ex)
{
Debug.WriteLine(@" ERROR {0}", ex.Message);
}
return(result);
}
private async void Save()
{
bool result = false;
var items = new OrderReqExtend();
items.Code = Pedido;
items.Status = "1";
items.Observation = Observation;
var answer = await App.Current.MainPage.DisplayAlert("TSHIRT", "Desea Guardar Cambio de Productos?", "SI", "NO");
if (answer)
{
result = await services.UpdateOrder(items);
if (result)
{
await Xamarin.Forms.Application.Current.MainPage.Navigation.PushAsync(new Result());
}
else
{
App.Current.MainPage.DisplayAlert("TSHIRT", "Error guardando registro", "OK");
}
}
}
public bool Save(OrderReqExtend items)
{
XmlChange xml = new XmlChange();
var order = new OrderReqExtend();
var detail = new OrderReqDetailExtend();
bool isUpdated = true;
try
{
//delete Order
OrderReq ordertoDelete = context.OrderReqs.FirstOrDefault(a => a.Code == items.Code);
context.Entry(ordertoDelete).State = EntityState.Deleted;
context.SaveChanges();
//delete OrderDetail
List <OrderReqDetail> listOrderDetailToDelete = context.OrderReqDetails.Where(a => a.OrderReqCode == items.Code).ToList();
context.OrderReqDetails.RemoveRange(listOrderDetailToDelete);
context.SaveChanges();
//Update status OrderReqDetailProduct
var detailforUpdate = context.OrderReqDetailProducts.Where(a => a.OrderReqCode == items.Code && a.Status == 0).ToList();
detailforUpdate.ForEach(a =>
{
a.Status = 1;
});
context.SaveChanges();
bool resultCreatexml = xml.Create(items.Code); //Crea XML
//if (result)
//{
// var detailforUpdate = context.OrderReqDetailProducts.Where(a=> a.OrderReqCode == items.Code && a.Status == 0).ToList();
// detailforUpdate.ForEach(a =>
// {
// a.Status = 1;
// });
// foreach (OrderReqDetailProduct row in detailforUpdate)
// {
// row.Status = 1;
// context.Entry(row).State = EntityState.Modified;
// context.SaveChanges();
// }
// // context.SaveChanges();
// bool resultCreatexml = xml.Create(items.Code); //Crea XML
//}
}
catch (Exception)
{
isUpdated = false;
throw;
}
return(isUpdated);
}
public async Task <ActionResult> Add(OrderReqExtend aModel)
{
_services = new ProductChangeServices();
var order = new OrderReqExtend();
if (aModel != null)
{
var result = await _services.Save(aModel);
if (result)
{
return(RedirectToAction("Index"));
}
}
return(View("Index"));
}
public async Task <ActionResult> Add(string code)
{
_services = new ProductChangeServices();
var order = new OrderReqExtend();
if (!string.IsNullOrEmpty(code))
{
order = await _services.GetDetailByCode(code);
}
else
{
return(View("Index"));
}
return(View(order));
}
private async void SearchImage()
{
var result = new OrderReqExtend();
result = await services.GetOrderByCode(NroPedido);
if (result.Id > 0)
{
Visible = true;
ClientName = result.ClientName;
}
else
{
Visible = false;
ClientName = "Pedido NO encontrado";
}
OnPropertyChanged("SearchImage");
}
public async Task <ActionResult> OrderDetails(List <OrderReqDetailExtend> aModel, string order, string prod, string prodChan, string prodChanNam, int?qty)
{
if (!string.IsNullOrEmpty(order))
{
_services = new ProductChangeServices();
var result = new OrderReqExtend();
var list = new List <OrderReqDetailExtend>();
result = await _services.GetDetailByCode(order);
if (result != null)
{
var op = Session["OptionCRUD"].ToString();
if (op == "INS")
{
result.Detail.Where(a => a.ProductCode == prod).ForEach(p =>
{
p.ProductCodeChanged = prodChan;
p.ProductNameChanged = prodChanNam;
if (qty != null)
{
p.Quantity = (int)qty;
}
});
}
else if (op == "DEL")
{
result.Detail.Where(a => a.ProductCode == prod).ForEach(p =>
{
p.ProductCodeChanged = null;
p.ProductNameChanged = null;
p.Quantity = null;
});
}
//return PartialView("_Details", (IEnumerable<OrderReqDetailExtend>)result.Detail);
return(PartialView("_Details", result.Detail));
}
}
//return PartialView("_Details", (IEnumerable<OrderReqDetailExtend>)aModel);
return(PartialView("_Details", aModel));
}
public async Task <OrderReqExtend> GetOrderByCode(string code)
{
var items = new OrderReqExtend();
string url = "http://" + PATHSERVER + "/tshirt/productchange/GetOrderByCode?code=";
string uri = string.Concat(url, code);
try
{
var result = await client.GetAsync(uri);
if (result.IsSuccessStatusCode)
{
var content = await result.Content.ReadAsStringAsync();
items = JsonConvert.DeserializeObject <OrderReqExtend>(content);
}
}
catch (Exception ex)
{
Debug.WriteLine(@" ERROR {0}", ex.Message);
}
return(items);
}
public OrderReqExtend GetOrderByCode(string code)
{
var order = new OrderReqExtend();
try
{
order = (from or in context.OrderReqs
where or.Code == code
select new OrderReqExtend()
{
Id = or.Id,
Code = or.Code,
Description = or.Description,
Status = or.Status,
ClientCode = or.ClientCode,
DateCreated = or.DateCreated,
Value1 = or.Value1,
Value2 = or.Value2,
Value3 = or.Value3,
Value4 = or.Value4,
Value5 = or.Value5,
Observation = or.Observation,
ClientName = or.ClientCode
}).FirstOrDefault();
if (order == null) //si no se encuentra en la bd intermedia busca en GP
{
using (TSGVLEntities db = new TSGVLEntities())
{
var _sop10100 = db.SOP10100.FirstOrDefault(a => a.SOPNUMBE.Trim().Equals(code));
if (_sop10100 == null)
{
var _sop30200 = db.SOP30200.FirstOrDefault(a => a.SOPNUMBE.Trim() == code);
order = new OrderReqExtend
{
Id = 1,
ClientCode = _sop30200.CUSTNAME.Trim().Replace("'", "''"),
Code = _sop30200.SOPNUMBE.Trim(),
ClientName = _sop30200.CUSTNAME.Trim().Replace("'", "''"),
DateCreated = _sop30200.DOCDATE.ToString("dd/MM/yyyy"),
Status = _sop30200.SOPSTATUS.ToString()
};
}
else
{
order = new OrderReqExtend
{
Id = 1,
ClientCode = _sop10100.CUSTNAME.Trim().Replace("'", "''"),
Code = _sop10100.SOPNUMBE.Trim(),
ClientName = _sop10100.CUSTNAME.Trim().Replace("'", "''"),
DateCreated = _sop10100.DOCDATE.ToString("dd/MM/yyyy"),
Status = _sop10100.SOPSTATUS.ToString()
};
}
}
}
}
catch (Exception ex)
{
Debug.Write("Error " + ex.InnerException.Message);
return(null);
}
return(order);
}
public OrderReqExtend GetDetailByCode(string code)
{
try
{
var order = new OrderReqExtend();
List <OrderReqDetailExtend> list = new List <OrderReqDetailExtend>();
List <OrderReqDetail> detailInsert = new List <OrderReqDetail>();
using (TSGVLEntities db = new TSGVLEntities())
{
var anyOrder = context.OrderReqs.Any(a => a.Code == code);
if (!anyOrder)
{
var master = db.SOP10100.FirstOrDefault(p => p.SOPNUMBE.Trim().Equals(code));
if (master != null)
{
var _master = new OrderReq()
{
Code = master.SOPNUMBE.Trim(),
ClientCode = master.CUSTNAME.Trim().Replace("'", "''"),
DateCreated = master.DOCDATE.ToString("dd/MM/yyyy"),
Status = master.SOPSTATUS.ToString(),
};
context.OrderReqs.Add(_master);
context.SaveChanges();
order.Id = _master.Id;
order.Code = _master.Code;
order.DateCreated = _master.DateCreated;
order.Status = _master.Status;
order.ClientCode = _master.ClientCode;
order.ClientName = _master.ClientCode;
var detail = db.SOP10200.Where(p => p.SOPNUMBE.Trim().Equals(code)).ToList();
if (detail.Any())
{
foreach (var row in detail)
{
var _detail = new OrderReqDetail()
{
OrderReqCode = row.SOPNUMBE.Trim(),
Observation = row.ITEMDESC.Trim(),
ProductCode = row.ITEMNMBR.Trim().Replace("'", "''"),
Quantity = Convert.ToInt32(row.QUANTITY),
Warehouse = row.LOCNCODE.Trim()
};
detailInsert.Add(_detail);
context.OrderReqDetails.Add(_detail);
context.SaveChanges();
}
list.AddRange(detailInsert.Select(items => new OrderReqDetailExtend()
{
OrderReqCode = items.OrderReqCode,
Observation = string.Empty,
ProductCode = items.ProductCode,
ProductCodeChanged = string.Empty,
Quantity = items.Quantity,
DateProductChanged = string.Empty,
UserUpdated = string.Empty,
ProductName = items.Observation,
ProductNameChanged = string.Empty,
QuantityChanged = 0,
Warehouse = items.Warehouse
}));
order.Detail = list;
}
}
else
{
var master30200 = db.SOP30200.FirstOrDefault(p => p.SOPNUMBE.Trim().Equals(code));
var _master2 = new OrderReq()
{
Code = master30200.SOPNUMBE.Trim(),
ClientCode = master30200.CUSTNAME.Trim().Replace("'", "''"),
DateCreated = master30200.DOCDATE.ToString("dd/MM/yyyy"),
Status = master30200.SOPSTATUS.ToString(),
};
context.OrderReqs.Add(_master2);
context.SaveChanges();
order.Id = _master2.Id;
order.Code = _master2.Code;
order.DateCreated = _master2.DateCreated;
order.Status = _master2.Status;
order.ClientCode = _master2.ClientCode;
order.ClientName = _master2.ClientCode;
var detail = db.SOP30300.Where(p => p.SOPNUMBE.Trim().Equals(code)).ToList();
if (detail.Any())
{
foreach (var row in detail)
{
var _detail = new OrderReqDetail()
{
OrderReqCode = row.SOPNUMBE.Trim(),
Observation = row.ITEMDESC.Trim(),
ProductCode = row.ITEMNMBR.Trim().Replace("'", "''"),
Quantity = Convert.ToInt32(row.QUANTITY),
Warehouse = row.LOCNCODE.Trim()
};
detailInsert.Add(_detail);
context.OrderReqDetails.Add(_detail);
context.SaveChanges();
}
list.AddRange(detailInsert.Select(items => new OrderReqDetailExtend()
{
OrderReqCode = items.OrderReqCode,
Observation = string.Empty,
ProductCode = items.ProductCode,
ProductCodeChanged = string.Empty,
Quantity = items.Quantity,
DateProductChanged = string.Empty,
UserUpdated = string.Empty,
ProductName = items.Observation,
ProductNameChanged = string.Empty,
QuantityChanged = 0,
Warehouse = items.Warehouse
}));
order.Detail = list;
}
}
}
else
{
order = GetOrderByCode(code);
var qyDetail = (from or in context.OrderReqDetails
join orp in context.OrderReqDetailProducts on new { or.OrderReqCode, or.ProductCode } equals new { orp.OrderReqCode, orp.ProductCode }
into rel
from relleft in rel.DefaultIfEmpty()
where or.OrderReqCode.Trim() == code
select new OrderReqDetailExtend
{
Id = or.Id,
OrderReqCode = or.OrderReqCode.Trim(),
Observation = or.Observation,
ProductCode = or.ProductCode,
ProductName = or.Observation,
ProductCodeChanged = relleft.ProductCodeChanged,
Quantity = or.Quantity,
DateProductChanged = relleft.DateProductChanged,
UserUpdated = relleft.UserUpdated,
QuantityChanged = relleft.Quantity == null ? 0 : relleft.Quantity,
Warehouse = or.Warehouse
}).ToList();
list.AddRange(qyDetail.Select(item => new OrderReqDetailExtend
{
Id = item.Id,
OrderReqCode = item.OrderReqCode.Trim(),
Observation = item.Observation,
ProductCode = item.ProductCode,
ProductCodeChanged = item.ProductCodeChanged,
Quantity = item.Quantity,
DateProductChanged = item.DateProductChanged,
UserUpdated = item.UserUpdated,
ProductName = item.ProductName, //db.IV00101.FirstOrDefault(a => a.ITEMNMBR.Trim() == item.ProductCode).ITEMDESC.Trim(),
ProductNameChanged = (item.ProductCodeChanged != null) ? db.IV00101.FirstOrDefault(a => a.ITEMNMBR.Trim() == item.ProductCodeChanged.ToString()).ITEMDESC.Trim() : string.Empty,
QuantityChanged = item.QuantityChanged,
Warehouse = item.Warehouse
}));
order.Detail = list;
}
}
return(order);
}
catch (Exception ex)
{
return(null);
Debug.Write("Error " + ex.InnerException.Message);
}
}
public bool Save(OrderReqExtend items)
{
return(_productRepository.Save(items));
}