protected bool AddAnotherProducts(RegistrationOrder regOrd, int? locationId) { bool allesHatGutGelaufen = false; string ProduktId = ""; string CostCenterId = ""; int skipFirst = 0; foreach (RadTreeNode node in DienstleistungTreeView.Nodes) { if (skipFirst > 0) { if (!String.IsNullOrEmpty(node.Value)) { string[] splited = node.Value.Split(';'); if (splited.Length == 2) { try { DataClasses1DataContext dbContext = new DataClasses1DataContext(Int32.Parse(Session["CurrentUserId"].ToString())); var orderNumber = regOrd.OrderNumber; Price newPrice; OrderItem newOrderItem1 = null; OrderItem newOrderItem2 = null; ProduktId = splited[0]; CostCenterId = splited[1]; if (!String.IsNullOrEmpty(ProduktId)) { var productId = Int32.Parse(ProduktId); int? costCenterId = null; KVSCommon.Database.Product newProduct = dbContext.Product.SingleOrDefault(q => q.Id == productId); if (RadComboBoxCustomer.SelectedIndex == 1 || locationId == null) //small { newPrice = dbContext.Price.SingleOrDefault(q => q.ProductId == newProduct.Id && q.LocationId == null); } else //large { costCenterId = Int32.Parse(CostCenterId); newPrice = dbContext.Price.SingleOrDefault(q => q.ProductId == newProduct.Id && q.LocationId == locationId); if (newPrice == null) newPrice = dbContext.Price.SingleOrDefault(q => q.ProductId == newProduct.Id && q.LocationId == null); } var orderToUpdate = dbContext.Order.SingleOrDefault(q => q.OrderNumber == orderNumber); orderToUpdate.LogDBContext = dbContext; if (orderToUpdate != null) { if (RadComboBoxCustomer.SelectedIndex == 1) { newOrderItem1 = orderToUpdate.AddOrderItem(newProduct.Id, newPrice.Amount, 1, null, null, false, dbContext); if (newPrice.AuthorativeCharge.HasValue) { orderToUpdate.AddOrderItem(newProduct.Id, newPrice.AuthorativeCharge.Value, 1, null, newOrderItem1.Id, newPrice.AuthorativeCharge.HasValue, dbContext); } } else { CostCenter costCenter = null; if (costCenterId.HasValue) { costCenter = dbContext.CostCenter.FirstOrDefault(o => o.Id == costCenterId.Value); } newOrderItem1 = orderToUpdate.AddOrderItem(newProduct.Id, newPrice.Amount, 1, costCenter, null, false, dbContext); if (newPrice.AuthorativeCharge.HasValue) { orderToUpdate.AddOrderItem(newProduct.Id, newPrice.AuthorativeCharge.Value, 1, costCenter, newOrderItem1.Id, newPrice.AuthorativeCharge.HasValue, dbContext); } } dbContext.SubmitChanges(); allesHatGutGelaufen = true; } } if (allesHatGutGelaufen) dbContext.SubmitChanges(); } catch (Exception ex) { return false; } } } } else { skipFirst = 1; } } return allesHatGutGelaufen; }
protected void MakeInvoiceForSmallCustomer(int customerId, RegistrationOrder regOrder) { try { DataClasses1DataContext dbContext = new DataClasses1DataContext(Int32.Parse(Session["CurrentUserId"].ToString())); var newOrder = dbContext.Order.Single(q => q.CustomerId == customerId && q.OrderNumber == regOrder.OrderNumber); smallCustomerOrderHiddenField.Value = regOrder.OrderNumber.ToString(); //updating order status newOrder.LogDBContext = dbContext; newOrder.Status = (int)OrderStatusTypes.Closed; //updating orderitems status foreach (OrderItem ordItem in newOrder.OrderItem) { ordItem.LogDBContext = dbContext; if (ordItem.Status != (int)OrderItemStatusTypes.Cancelled) { ordItem.Status = (int)OrderItemStatusTypes.Closed; } } dbContext.SubmitChanges(); //updating order und items status one more time to make it abgerechnet newOrder.LogDBContext = dbContext; newOrder.ExecutionDate = DateTime.Now; newOrder.Status = (int)OrderStatusTypes.Payed; dbContext.SubmitChanges(); //opening window for adress string script = "function f(){$find(\"" + AddAdressRadWindow.ClientID + "\").show(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true); SetValuesForAdressWindow(); } catch(Exception ex) { ErrorLeereTextBoxenLabel.Text = "Error: " + ex.Message; ErrorLeereTextBoxenLabel.Visible = true; } }
private void attach_RegistrationOrder(RegistrationOrder entity) { this.SendPropertyChanging(); entity.Registration = this; }
private void detach_RegistrationOrder(RegistrationOrder entity) { this.SendPropertyChanging(); entity.Vehicle = null; }
partial void DeleteRegistrationOrder(RegistrationOrder instance);
partial void UpdateRegistrationOrder(RegistrationOrder instance);
partial void InsertRegistrationOrder(RegistrationOrder instance);
//protected string CheckIfAllProduktsHavingPrice(int? locationId) //{ // string allesHatGutGelaufen = ""; // string ProduktId = ""; // string CostCenterId = ""; // foreach (RadTreeNode node in DienstleistungTreeView.Nodes) // { // if (!String.IsNullOrEmpty(node.Value)) // { // string[] splited = node.Value.Split(';'); // if (splited.Length == 2) // { // try // { // DataClasses1DataContext dbContext = new DataClasses1DataContext(Int32.Parse(Session["CurrentUserId"].ToString())); // Price newPrice; // ProduktId = splited[0]; // CostCenterId = splited[1]; // if (!String.IsNullOrEmpty(ProduktId)) // { // var productId = Int32.Parse(ProduktId); // KVSCommon.Database.Product newProduct = dbContext.Product.SingleOrDefault(q => q.Id == productId); // if (locationId == null) //small // { // newPrice = dbContext.Price.SingleOrDefault(q => q.ProductId == newProduct.Id && q.LocationId == null); // if (newPrice == null) // { // allesHatGutGelaufen += " " + node.Text + " "; // } // else // { // } // } // } // } // catch // { // return ""; // } // } // } // } // return allesHatGutGelaufen; //} protected void AddAnotherProducts(RegistrationOrder regOrd, int? locationId) { string ProduktId = ""; int itemIndexValue = 0; decimal amount = 0; decimal authCharge = 0; var nodes = this.Request.Form.AllKeys.Where(q => q.Contains("txtItemPrice_")); foreach(var node in nodes) { if (!String.IsNullOrEmpty(node)) { DataClasses1DataContext dbContext = new DataClasses1DataContext(Int32.Parse(Session["CurrentUserId"].ToString())); var orderNumber = regOrd.OrderNumber; Price newPrice = null; OrderItem newOrderItem1 = null; ProduktId = node.Split('_')[1]; if (!String.IsNullOrEmpty(ProduktId)) { var productId = Int32.Parse(ProduktId); KVSCommon.Database.Product newProduct = dbContext.Product.SingleOrDefault(q => q.Id == productId); if (locationId == null) //small { newPrice = dbContext.Price.SingleOrDefault(q => q.ProductId == newProduct.Id && q.LocationId == null); } var orderToUpdate = dbContext.Order.SingleOrDefault(q => q.OrderNumber == orderNumber); orderToUpdate.LogDBContext = dbContext; if (orderToUpdate != null) { if (this.Request.Form.GetValues(node) != null) { string itemPrice = this.Request.Form.GetValues(node)[0]; if (EmptyStringIfNull.IsNumber(itemPrice)) { amount = Convert.ToDecimal(itemPrice.Replace('.', ',')); } else if (itemPrice == "") { amount = 0; } else { amount = newPrice.Amount; } } else { amount = newPrice.Amount; } newOrderItem1 = orderToUpdate.AddOrderItem(newProduct.Id, amount, 1, null, null, false, dbContext); if (newPrice!= null && newPrice.AuthorativeCharge.HasValue) { if (this.Request.Form.GetValues(node.Replace("txtItemPrice_", "txtAuthPrice_")) != null) { string itemPrice = this.Request.Form.GetValues(node.Replace("txtItemPrice_", "txtAuthPrice_"))[0]; if (EmptyStringIfNull.IsNumber(itemPrice)) { amount = Convert.ToDecimal(itemPrice.Replace('.', ',')); } else if (itemPrice == "") { amount = 0; } else { amount = newPrice.AuthorativeCharge.Value; } } else { amount = newPrice.AuthorativeCharge.Value; } orderToUpdate.AddOrderItem(newProduct.Id, amount, 1, null, newOrderItem1.Id, newPrice.AuthorativeCharge.HasValue, dbContext); } itemIndexValue= itemIndexValue+1; dbContext.SubmitChanges(); } } } } }
private static void AddAnotherProducts(RegistrationOrder regOrd, Guid? locationId, ReadmissionWiederzulassungHeader ProductCostCenterListHeader, Guid currentUserId) { bool allesHatGutGelaufen = false; string ProduktId = ""; string CostCenterId = ""; int skipFirst = 0; foreach (var productCostCenterPair in ProductCostCenterListHeader.ProductCostCenterList) { if (skipFirst > 0) { if (!String.IsNullOrEmpty(productCostCenterPair.ProductId) && !String.IsNullOrEmpty(productCostCenterPair.CostCenterId)) { try { DataClasses1DataContext dbContext = new DataClasses1DataContext(currentUserId); Guid orderId = regOrd.OrderId; Price newPrice; OrderItem newOrderItem1 = null; ProduktId = productCostCenterPair.ProductId; CostCenterId = productCostCenterPair.CostCenterId; if (!String.IsNullOrEmpty(ProduktId)) { Guid productId = new Guid(ProduktId); Guid costCenterId = Guid.Empty; KVSCommon.Database.Product newProduct = dbContext.Product.SingleOrDefault(q => q.Id == productId); if (locationId == null) //small { newPrice = dbContext.Price.SingleOrDefault(q => q.ProductId == newProduct.Id && q.LocationId == null); } else //large { costCenterId = new Guid(CostCenterId); newPrice = dbContext.Price.SingleOrDefault(q => q.ProductId == newProduct.Id && q.LocationId == locationId); if (newPrice == null) newPrice = dbContext.Price.SingleOrDefault(q => q.ProductId == newProduct.Id && q.LocationId == null); } var orderToUpdate = dbContext.Order.SingleOrDefault(q => q.Id == orderId); orderToUpdate.LogDBContext = dbContext; if (orderToUpdate != null) { newOrderItem1 = orderToUpdate.AddOrderItem(newProduct.Id, newPrice.Amount, 1, costCenterId, null, false, dbContext); if (newPrice.AuthorativeCharge.HasValue) { orderToUpdate.AddOrderItem(newProduct.Id, newPrice.AuthorativeCharge.Value, 1, costCenterId, newOrderItem1.Id, newPrice.AuthorativeCharge.HasValue, dbContext); } dbContext.SubmitChanges(); allesHatGutGelaufen = true; } } if (allesHatGutGelaufen) dbContext.SubmitChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } } } else { skipFirst = 1; } } }