public ActionResult DeleteConfirmed(string id)
{
SO_SalesOrderDetail sO_SalesOrderDetail = db.SO_SalesOrderDetail.Find(id);
db.SO_SalesOrderDetail.Remove(sO_SalesOrderDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SalesOrderNo,LineKey,LineSeqNo,ItemCode,ItemType,ItemCodeDesc,ExtendedDescriptionKey,Discount,Commissionable,SubjectToExemption,WarehouseCode,PriceLevel,MasterOrderLineKey,UnitOfMeasure,DropShip,PrintDropShipment,SalesKitLineKey,CostOfGoodsSoldAcctKey,SalesAcctKey,PriceOverridden,ExplodedKitItem,StandardKitBill,Revision,BillOption1,BillOption2,BillOption3,BillOption4,BillOption5,BillOption6,BillOption7,BillOption8,BillOption9,BackorderKitCompLine,SkipPrintCompLine,PromiseDate,AliasItemNo,SOHistoryDetlSeqNo,TaxClass,CustomerAction,ItemAction,WarrantyCode,ExpirationDate,ExpirationOverridden,CostOverridden,CostCode,CostType,CommentText,QuantityOrdered,QuantityShipped,QuantityBackordered,MasterOriginalQty,MasterQtyBalance,MasterQtyOrderedToDate,RepeatingQtyShippedToDate,UnitPrice,UnitCost,ExtensionAmt,UnitOfMeasureConvFactor,QuantityPerBill,LineDiscountPercent,Valuation,LotSerialFullyDistributed,APDivisionNo,VendorNo,PurchaseOrderNo,PurchaseOrderRequiredDate,LineWeight,CommodityCode,AlternateTaxIdentifier,TaxTypeApplied,NetGrossIndicator,DebitCreditIndicator,TaxAmt,TaxRate")] SO_SalesOrderDetail sO_SalesOrderDetail)
{
if (ModelState.IsValid)
{
db.Entry(sO_SalesOrderDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sO_SalesOrderDetail));
}
public SO_SalesOrderDetail GetSalesOrderDetail(string SalesOrderNo, string ItemCode)
{
SO_SalesOrderDetail returnDetail = null;
lock (_locker)
{
returnDetail = _database.Table <SO_SalesOrderDetail>().Where(so => so.SalesOrderNo == SalesOrderNo && so.ItemCode == ItemCode).FirstOrDefault();
}
return(returnDetail);
}
// GET: SO_SalesOrderDetail/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SO_SalesOrderDetail sO_SalesOrderDetail = db.SO_SalesOrderDetail.Find(id);
if (sO_SalesOrderDetail == null)
{
return(HttpNotFound());
}
return(View(sO_SalesOrderDetail));
}
// GET: SO_SalesOrderDetail/Details/5
public ActionResult Details(string SalesOrderNo, string LineKey)
{
if (SalesOrderNo == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SO_SalesOrderDetail sO_SalesOrderDetail = db.SO_SalesOrderDetail.Find(SalesOrderNo, LineKey);
if (sO_SalesOrderDetail == null)
{
return(HttpNotFound());
}
return(View(sO_SalesOrderDetail));
}
public App_RepairPart(CI_Item item, App_WorkTicket workTicket, string itemCode)
{
_ciOptions = App.Database.GetCIOptions();
quantityFormatString = String.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInQty, "}");
umFormatString = string.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInUM, "}");
costFormatString = string.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInCost, "}");
priceFormatString = string.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInPrice, "}");
_workTicket = workTicket;
_id = 0;
_parentItemCode = workTicket.DtlRepairItemCode;
// dch rkl 10/31/2016 handle nulls
if (item != null)
{
_partItemCode = item.ItemCode;
_partItemCodeDescription = item.ItemCodeDesc;
_warehouse = item.DefaultWarehouseCode;
// dch rkl 12/02/2016 Get Item Unit Cost based on JT_Options.DefaultPartsCost
_unitCost = GetItemUnitCost(item.LastTotalUnitCost, item.AverageUnitCost, item.StandardUnitCost);
//_unitCost = (double)item.StandardUnitCost;
_unitPrice = Convert.ToDouble(item.StandardUnitPrice);
// dch rkl 02/03/2017 Per Jeanne, Use the Sales Unit of Measure, not the Standard Unit of Measure
//_unitOfMeasure = item.StandardUnitOfMeasure;
_unitOfMeasure = item.SalesUnitOfMeasure;
// dch rkl 11/23/2016 Add Item Type
_itemType = item.ItemType;
// dch rkl 12/05/2016 Add Item Valuation
_valuation = item.Valuation;
}
else
{
_partItemCode = "";
_partItemCodeDescription = "";
_warehouse = "";
_unitCost = 0;
_unitPrice = 0;
_unitOfMeasure = "";
_itemType = "";
_valuation = "";
}
_problemCode = _workTicket.DtlProblemCode;
_quantity = 0.0;
_comment = string.Empty;
_isChargeable = SetIsChargeable();
_isPrintable = (_isChargeable ? true : false);
_isPurchased = false;
_isOverhead = _workTicket.PartsCalculateOverheadDefault;
//bk check existing sales order detail
//bk use workticket item instead of item in case of null
SO_SalesOrderDetail soDetail = App.Database.GetSalesOrderDetail(workTicket.SalesOrderNo, (item == null ? itemCode : item.ItemCode));
if (soDetail != null)
{
_isChargeable = soDetail.JT158_WTChargePart == "Y" ? true : false;
_isPrintable = soDetail.JT158_WTPrintPart == "Y" ? true : false;
_isPurchased = soDetail.JT158_WTPurchase == "Y" ? true : false;
_isOverhead = soDetail.JT158_WTOverhead == "Y" ? true : false;
}
// dch rkl 11/30/2016 add quantity required
_quantityReqd = 0;
// dch rkl 12/05/2016 add qty shipped
_quantityShipped = 0;
// dch rkl 01/13/2017 Add Extended Description
_itemCodeDesc = "";
// dch rkl 01/23/2017 Sales Order Line Key
_soLineKey = "";
}
public App_RepairPart(JT_ServiceEquipmentParts part, App_WorkTicket workTicket, CI_Item item)
{
_ciOptions = App.Database.GetCIOptions();
quantityFormatString = String.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInQty, "}");
umFormatString = string.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInUM, "}");
costFormatString = string.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInCost, "}");
priceFormatString = string.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInPrice, "}");
_workTicket = workTicket;
_id = 0;
_parentItemCode = workTicket.DtlRepairItemCode;
_partItemCode = part.ItemCode;
_partItemCodeDescription = item.ItemCodeDesc;
_warehouse = item.DefaultWarehouseCode;
_problemCode = part.ProblemCode;
_quantity = part.Quantity;
// dch rkl 12/02/2016 Get Item Unit Cost based on JT_Options.DefaultPartsCost
_unitCost = GetItemUnitCost(item.LastTotalUnitCost, item.AverageUnitCost, item.StandardUnitCost);
//_unitCost = (double)item.StandardUnitCost;
_unitPrice = (double)item.StandardUnitPrice;
// dch rkl 02/03/2017 Use the sales unit of measure instead of the standard unit of measure
//_unitOfMeasure = item.StandardUnitOfMeasure;
_unitOfMeasure = item.SalesUnitOfMeasure;
_comment = "";
_isChargeable = part.IsChargeable;
_isPrintable = part.IsPrintable;
_isPurchased = part.IsPurchased;
_isOverhead = part.IsOverhead;
//bk check existing sales order detail
SO_SalesOrderDetail soDetail = App.Database.GetSalesOrderDetail(workTicket.SalesOrderNo, item.ItemCode);
if (soDetail != null)
{
_isChargeable = soDetail.JT158_WTChargePart == "Y" ? true : false;
_isPrintable = soDetail.JT158_WTPrintPart == "Y" ? true : false;
_isPurchased = soDetail.JT158_WTPurchase == "Y" ? true : false;
_isOverhead = soDetail.JT158_WTOverhead == "Y" ? true : false;
}
// dch rkl 11/23/2016 Add Item Type
_itemType = item.ItemType;
// dch rkl 12/05/2016 Add Item Valuation
_valuation = item.Valuation;
// dch rkl 11/30/2016 add quantity required
_quantityReqd = 0;
// dch rkl 12/05/2016 add qty shipped
_quantityShipped = 0;
// dch rkl 01/13/2017 Add Extended Description
_itemCodeDesc = "";
// dch rkl 01/23/2017 Sales Order Line Key
_soLineKey = "";
}
protected void SetPageLayout()
{
// Set the page title.
switch (_pageMode)
{
case PageMode.Add:
_labelTitle.Content = "ADD PART";
break;
case PageMode.Edit:
_labelTitle.Content = "EDIT PART";
break;
default:
_labelTitle.Content = "ADD/EDIT PART";
break;
}
// get our ci_options first
_ciOptions = App.Database.GetCIOptions();
quantityFormatString = String.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInQty, "}");
umFormatString = string.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInUM, "}");
costFormatString = string.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInCost, "}");
priceFormatString = string.Concat("{0:F", _ciOptions.NumberOfDecimalPlacesInPrice, "}");
gridMain.DataContext = _vm.PartToEdit;
SolidColorBrush asbestos = new SolidColorBrush((Color)ColorConverter.ConvertFromString("#7f8C8d"));
// Set Bindings
_labelPartNumber.SetBinding(ContentProperty, "PartItemCode");
_labelPartNumber.Text = _vm.PartToEdit.PartItemCode;
var ciOptions = App.Database.GetCIOptions();
_labelPartDescription.SetBinding(ContentProperty, "PartItemCodeDescription");
_labelPartDescription.Text = _vm.PartToEdit.PartItemCodeDescription;
_pickerWarehouse.ItemsSource = _vm.WarehouseList;
try { _pickerWarehouse.SelectedValue = _vm.PartToEdit.Warehouse; } catch { }
if (_pageMode == PageMode.Edit)
{
_entryQuantity.Text = _vm.PartToEdit.Quantity.ToString();
}
else
{
_entryQuantity.Text = "1";
}
// dch rkl 01/23/2017 Change U/M to picklist
_pickerUnitOfMeasure.ItemsSource = _vm.UnitOfMeasureList;
try { _pickerUnitOfMeasure.SelectedValue = _vm.PartToEdit.UnitOfMeasure; }
catch (Exception ex) { }
if (_pickerUnitOfMeasure.SelectedIndex == -1 && _vm.PartToEdit.PartItemCode.Trim().Substring(0, 1) == "*" || _vm.PartToEdit.ItemType == "4" || _vm.PartToEdit.ItemType == "5")
{
AddItemToUMList(_vm.PartToEdit.UnitOfMeasure);
}
//_entryUnitOfMeasure.SetBinding(ContentProperty, "UnitOfMeasure");
//_entryUnitOfMeasure.Text = _vm.PartToEdit.UnitOfMeasure;
//_entryUnitOfMeasure.Style = (Style)this.Resources["styleUOM"];
// dch rkl 12/05/2016 if qty shipped > 0, cannot edit warehouse or u/m
if (_vm.PartToEdit.QuantityShipped > 0)
{
_pickerWarehouse.IsEnabled = false;
// dch rkl 01/23/2017 Change U/M to picklist
//_entryUnitOfMeasure.IsEnabled = false;
_pickerUnitOfMeasure.IsEnabled = false;
}
// dch rkl 11/23/2016 If Edit Mode, and a Quantity has been entered, disable U/M
if (_pageMode == PageMode.Edit && _vm.PartToEdit.Quantity != 0)
{
// dch rkl 01/23/2017 Change U/M to picklist
//_entryUnitOfMeasure.IsEnabled = false;
_pickerUnitOfMeasure.IsEnabled = false;
}
_entryUnitCost.Text = _vm.PartToEdit.UnitCost.ToString("C2");
// dch rkl 11/23/2016 if misc part, allow entry of unit cost
if (_vm.PartToEdit.PartItemCode.Trim().Substring(0, 1) == "*" || _vm.PartToEdit.ItemType == "4" || _vm.PartToEdit.ItemType == "5")
{
_entryUnitCost.IsEnabled = true;
// dch rkl 01/23/2017 if miscellaneous, allow entry of U/M
_pickerUnitOfMeasure.IsEditable = true;
}
else
{
_entryUnitCost.IsEnabled = false;
// dch rkl 01/23/2017 if miscellaneous, allow entry of U/M
_pickerUnitOfMeasure.IsEditable = false;
}
// dch rkl 01/18/2017 If not chargeable, set Unit Price and Ext Price to zero.
if (_vm.PartToEdit.IsChargeable)
{
//_entryUnitPrice.Text = _vm.PartToEdit.UnitPrice.ToString("C2");
_entryUnitPrice.Text = string.Format(priceFormatString, _vm.PartToEdit.UnitPrice);
if (_pageMode == PageMode.Edit)
{
_labelExtensionPrice.Content = string.Format(priceFormatString, (_vm.PartToEdit.UnitPrice * _vm.PartToEdit.Quantity));
//(_vm.PartToEdit.UnitPrice * _vm.PartToEdit.Quantity).ToString("C2"); }
}
else
{
_labelExtensionPrice.Content = string.Format(priceFormatString, (_vm.PartToEdit.UnitPrice * 1));
//(_vm.PartToEdit.UnitPrice * 1).ToString("C2");
}
}
else
{
_labelExtensionPrice.Content = string.Format(priceFormatString, 0);
_entryUnitPrice.Text = string.Format(priceFormatString, 0);
}
_entryComments.SetBinding(ContentProperty, "Comment");
_entryComments.Style = (Style)this.Resources["styleComments"];
_entryComments.Text = _vm.PartToEdit.Comment;
if (_pageMode == PageMode.Edit)
{
_switchIsChargeable.SetBinding(CheckBox.IsCheckedProperty, "IsChargeable");
_switchIsPrintable.SetBinding(CheckBox.IsCheckedProperty, "IsPrintable");
_switchIsPurchased.SetBinding(CheckBox.IsCheckedProperty, "IsPurchased");
_switchIsOverhead.SetBinding(CheckBox.IsCheckedProperty, "IsOverhead");
}
// dch rkl 11/21/2016 if part is purchased, do not allow editing of quantity
if (_vm.PartToEdit.IsPurchased)
{
_entryQuantity.IsEnabled = false;
}
else
{
_entryQuantity.IsEnabled = true;
}
// dch rkl 11/22/2016 if chargeable is checked, allow unit price to be updated.
// If chargeable is not checked, unit price cannot be updated.
if (_vm.PartToEdit.IsChargeable)
{
_entryUnitPrice.IsEnabled = true;
}
else
{
_entryUnitPrice.IsEnabled = false;
_entryUnitPrice.Text = string.Format(priceFormatString, 0);
}
// dch rkl 11/23/2016 if misc part, hide warehouse dropdown
bool bShowWhse = true;
if (_vm.PartToEdit.PartItemCode.Trim().Substring(0, 1) == "*" || _vm.PartToEdit.ItemType == "4" || _vm.PartToEdit.ItemType == "5")
{
bShowWhse = false;
}
if (bShowWhse)
{
_pickerWarehouse.Visibility = Visibility.Visible;
labelWarehouse.Visibility = Visibility.Visible;
}
else
{
_pickerWarehouse.Visibility = Visibility.Hidden;
labelWarehouse.Visibility = Visibility.Hidden;
}
// dch rkl 01/13/2017 if extended description exists, display button to view/edit it BEGIN
if (_vm.ExtendedDescriptionKey > 0 && _vm.ExtendedDescriptionText.Trim().Length > 0)
{
_buttonExtdDesc.Visibility = Visibility.Visible;
}
else
{
_buttonExtdDesc.Visibility = Visibility.Hidden;
}
// dch rkl 01/13/2017 if extended description exists, display button to view/edit it END
switch (_pageMode)
{
case PageMode.Add:
buttonAddPartText.Text = "ADD";
break;
case PageMode.Edit:
buttonAddPartText.Text = "UPDATE";
break;
}
if (_pageMode == PageMode.Add)
{
_buttonDeletePart.Visibility = Visibility.Hidden;
}
else
{
_buttonDeletePart.Visibility = Visibility.Visible;
}
// dch rkl 01/23/2017 If SO_SalesOrderDetail.JT158_WTBillFlag is set to "R" or "B", do not allow edit of the part
int iSOLineKey;
int.TryParse(_vm.PartToEdit.SoLineKey, out iSOLineKey);
if (_vm.PartToEdit.SoLineKey != null)
{
if (iSOLineKey > 0)
{
List <SO_SalesOrderDetail> lsSODtl = App.Database.GetSalesOrderDetails(_vm.WorkTicket.SalesOrderNo);
SO_SalesOrderDetail soDtl = lsSODtl.FirstOrDefault(s => s.LineKey == _vm.PartToEdit.SoLineKey);
if (soDtl != null && soDtl.JT158_WTBillFlag != null && (soDtl.JT158_WTBillFlag == "R" || soDtl.JT158_WTBillFlag == "B"))
{
_buttonAddPart.Visibility = Visibility.Hidden;
_buttonDeletePart.Visibility = Visibility.Hidden;
}
}
}
// dch rkl 02/03/2017 Do not allow existing parts to be deleted
if (iSOLineKey > 0)
{
_buttonDeletePart.Visibility = Visibility.Hidden;
}
}
