public void RestoreDetail()
{
GridOrderDetails.Add(backupdetail);
PartNum = null;
PriceListPart = null;
Reference = "0";
Quantity = 1;
TotalLineas = GridOrderDetails.Sum(god => god.Value);
}
public void PartEdited(GridOrderDetail edited)
{
GridOrderDetails.Add(edited);
PartNum = null;
PriceListPart = null;
Reference = "0";
Quantity = 1;
TotalLineas = GridOrderDetails.Sum(god => god.Value);
}
protected void GridOrderDetails_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
Itemdetails.Visible = true;
GridViewRow gv = GridOrderDetails.SelectedRow;
//order,material,code,name,QTy,height,Width,Type,customer,store,
int orderid = int.Parse(gv.Cells[1].Text);
int materialid = int.Parse(gv.Cells[2].Text);
string code = gv.Cells[3].Text;
string name = gv.Cells[4].Text;
decimal QTY = decimal.Parse(gv.Cells[5].Text);
decimal Height = decimal.Parse(gv.Cells[6].Text);
decimal Width = decimal.Parse(gv.Cells[7].Text);
string storename = gv.Cells[10].Text;
string type = gv.Cells[8].Text;
if (type == "CuttingList")
{
CuttingItemReturn(materialid, name, orderid, QTY, Height, Width, storename);
}
else if (type == "Material")
{
MaterialReturn(materialid, name, orderid, QTY, Height, Width, storename);
}
else if (type == "DeadMaterial")
{
DeadMaterialReturn(materialid, name, orderid, QTY, Height, Width, storename);
}
var orderdetail = db.OrderDetails.Where(x => x.OrderID == orderid && x.MaterialID == materialid && x.Quantity == QTY).FirstOrDefault();
orderdetail.IsActive = false;
db.SaveChanges();
GridOrderDetails.DataBind();
if (GridOrderDetails.Rows.Count == 0)
{
dvOrderDetails.Visible = false;
}
Itemdetails.Visible = false;
GridData.DataBind();
}
catch (Exception ex)
{
LblAddNewItem.Text = "Error in Material Return " + ex.Message;
LblAddNewItem.Visible = true;
LblAddNewItem.ForeColor = Color.Red;
}
}
async void AddProductToOrder()
{
if (PriceListPart == null)
{
await dialogService.ShowMessage(
"Error",
"Debe ingresar una parte.");
return;
}
if (Quantity <= 0)
{
await dialogService.ShowMessage(
"Error",
"Debe ingresar una cantidad mayor a cero.");
return;
}
if (Reference == string.Empty || Reference == null)
{
Reference = "0";
}
GridOrderDetails.Add(new GridOrderDetail
{
BasePrice = PriceListPart.BasePrice,
PartDescription = PriceListPart.PartDescription,
PartNum = PriceListPart.PartNum,
PartId = PriceListPart.PartId,
PriceListPartId = PriceListPart.PriceListPartId,
Reference = Reference,
Quantity = Quantity,
});
PartNum = null;
PriceListPart = null;
Quantity = 1;
Reference = "0";
TotalLineas = GridOrderDetails.Sum(god => god.Value);
}
public void DeleteOrderReceipt(OrderHeader OrderToDelete)
{
//Encabezado
SalesOrderHeaderId = OrderToDelete.SalesOrderHeaderId;
SalesOrderHeaderInterId = OrderToDelete.SalesOrderHeaderInterId;
OrderNum = OrderToDelete.OrderNum;
SincronizadoEpicor = OrderToDelete.SincronizadoEpicor;
IsSync = OrderToDelete.IsSync;
NeedBy = OrderToDelete.NeedByDate;
Observations = OrderToDelete.Observations;
//Cargo cliente
Customer = OrderToDelete.Customer;
//Cargo shipto
this.ShipTo = dataService
.Find <ShipTo>(OrderToDelete.ShipToId, false);
//Cargo detalle
var editdetaillist = OrderToDelete.OrderDetails;
foreach (var item in editdetaillist)
{
GridOrderDetails.Add(new GridOrderDetail
{
SalesOrderDetaliId = item.SalesOrderDetaliId,
BasePrice = item.UnitPrice,
PartDescription = item.PartNum,
PartNum = item.PartNum,
PartId = item.PartId,
PriceListPartId = item.PriceListPartId,
Quantity = item.OrderQty,
Reference = item.Reference,
});
}
//Calculo total
TotalLineas = GridOrderDetails.Sum(god => god.Value);
}
async void AddProductToOrder()
{
if (PriceListPart == null)
{
await dialogService.ShowMessage(
"Error",
"Debe ingresar un producto.");
return;
}
if (Quantity <= 0)
{
await dialogService.ShowMessage(
"Error",
"Debe ingresar una cantidad mayor a cero.");
return;
}
GridOrderDetails.Add(new GridOrderDetail
{
BasePrice = PriceListPart.BasePrice,
Discount = Discount / 100,
PartDescription = PriceListPart.PartDescription,
PartNum = PriceListPart.PartNum,
PartId = PriceListPart.PartId,
PriceListPartId = PriceListPart.PriceListPartId,
Quantity = Quantity,
});
PartNum = null;
PriceListPart = null;
Quantity = 1;
Discount = 0;
Total = GridOrderDetails.Sum(god => god.Value);
}
public void BeginEdit(GridOrderDetail detail)
{
backupdetail = detail;
GridOrderDetails.Remove(detail);
}
public void EditOrderReceipt(OrderHeader OrderToEdit)
{
//Encabezado
SalesOrderHeaderId = OrderToEdit.SalesOrderHeaderId;
SalesOrderHeaderInterId = OrderToEdit.SalesOrderHeaderInterId;
OrderNum = OrderToEdit.OrderNum;
SincronizadoEpicor = OrderToEdit.SincronizadoEpicor;
IsSync = OrderToEdit.IsSync;
NeedBy = OrderToEdit.NeedByDate;
Date = OrderToEdit.Date;
Observations = OrderToEdit.Observations;
//Cargo cliente
Customer = OrderToEdit.Customer;
//Cargo shipto
this.ShipTo = dataService
.Find <ShipTo>(OrderToEdit.ShipToId, false);
//Cargo detalle
var editdetaillist = OrderToEdit.OrderDetails;
foreach (var item in editdetaillist)
{
GridOrderDetails.Add(new GridOrderDetail
{
SalesOrderDetaliId = item.SalesOrderDetaliId,
BasePrice = item.UnitPrice,
PartDescription = item.PartNum,
PartNum = item.PartNum,
PartId = item.PartId,
PriceListPartId = item.PriceListPartId,
Quantity = item.OrderQty,
Reference = item.Reference,
});
}
//try
//{
// var DetailTemp = OrderToEdit.OrderDetails;
// dataService.Delete(DetailTemp);
//}
//catch (Exception)
//{
// throw;
//}
//Detalle Temporal
//int i = 0;
//foreach (var detail in OrderToEdit.OrderDetails)
//{
// var orderDetail = new OrderDetail
// {
// OrderLine = ++i,
// SalesOrderDetaliId = detail.SalesOrderDetaliId,
// SalesOrderHeaderId = OrderToEdit.SalesOrderHeaderId,
// PriceListPartId = detail.PriceListPartId,
// PartId = detail.PartId,
// OrderQty = detail.OrderQty,
// Reference = detail.Reference,
// PartNum = detail.PartNum,
// UnitPrice = detail.UnitPrice,
// };
//Cargo lista de precios
LoadPriceLists();
PartNum = null;
PriceListPart = null;
Quantity = 1;
TotalLineas = GridOrderDetails.Sum(god => god.Value);
}
protected void btnAddNewItem_Click(object sender, EventArgs e)
{
try
{
var availableQTY = Convert.ToDecimal(txtCurrentStock.Value);
var requestedQTY = Convert.ToDecimal(txtRequestedStock.Value.ToString());
if (String.IsNullOrEmpty(txtRequestedStock.Value.ToString()))
{
LblAddNewItem.Text = "برجاء أدخال الكمية المطلوبة";
LblAddNewItem.Visible = true;
LblAddNewItem.ForeColor = Color.Red;
}
else if (requestedQTY > availableQTY)
{
LblAddNewItem.Text = "الكمية المطلوبة أكبر من الكمية المتاحة فى المخزن";
LblAddNewItem.Visible = true;
LblAddNewItem.ForeColor = Color.Red;
}
else
{
selectitem.Enabled = false;
Store.Enabled = false;
SettleStock();
OrderDetail d = new OrderDetail();
d.IsActive = true;
d.MaterialID = Convert.ToInt32(selectitem.SelectedValue);
d.OrderID = Convert.ToInt32(LblOrderID.Text.ToString());
d.Quantity = Convert.ToDecimal(txtRequestedStock.Value.ToString());
d.StoreID = Convert.ToInt32(Store.SelectedValue.ToString());
if (txtNote.Value == null || txtNote.Value == String.Empty)
{
txtNote.Value = "";
}
d.Notes = txtNote.Value.ToString();
if (String.IsNullOrWhiteSpace(txtitemHieght.Value.ToString()) || txtitemHieght.Value.ToString() == " ")
{
d.Height = 0;
}
else
{
d.Height = Convert.ToDecimal(txtitemHieght.Value.ToString());
}
if (String.IsNullOrWhiteSpace(txtItemWidth.Value.ToString()) || txtItemWidth.Value.ToString() == " ")
{
d.Width = 0;
}
else
{
d.Width = Convert.ToDecimal(txtItemWidth.Value.ToString());
}
d.MaterialType = txtItemType.Value.ToString();
db.OrderDetails.Add(d);
db.SaveChanges();
GridOrderDetails.DataBind();
dvOrderDetails.Visible = true;
ClearData();
selectitem.Enabled = true;
Store.Enabled = true;
}
}
catch (Exception ex)
{
lblOrderErr.Text = "Error in Order Items " + ex.InnerException.InnerException.Message;
lblOrderErr.Visible = true;
lblOrderErr.ForeColor = Color.Red;
Logger log = new Logger();
log.Action = "Error in Order items Addition " + ex.InnerException.InnerException.Message;
log.ActionDate = DateTime.Now;
log.ActionType = "Order Details";
log.UserName = User.Identity.Name;
db.Loggers.Add(log);
db.SaveChanges();
}
}
