public void EndEdit() { DataSource.VatRate lUpdateItem = lDataContext.VatRates.SingleOrDefault(p => p.Id == this.Id); if (lUpdateItem == null) { DataSource.VatRate lNewItem = new DataSource.VatRate { Name = this.Name, Rate = this.Rate }; // Add the new object to the Orders collection. lDataContext.VatRates.InsertOnSubmit(lNewItem); // Submit the change to the database. try { lDataContext.SubmitChanges(); this.Id = lNewItem.Id; } catch (Exception e) { Console.WriteLine(e); } } else { lUpdateItem.Name = this.Name; lUpdateItem.Rate = this.Rate; lDataContext.SubmitChanges(); } }
private Boolean SavingEnded() { //System.Threading.Thread.Sleep(2000); DataSource.Invoice lInvoice = lDataContext.Invoices.SingleOrDefault(p => p.Id == this.Invoice.Id); if (lInvoice == null) { this.Invoice.InvoiceNo = GetInvoiceNo(); DataSource.Invoice newInvoice = new DataSource.Invoice { CustomerId = this.CustomerId, InvoiceNo = this.Invoice.InvoiceNo, InvoiceDate = this.Invoice.InvoiceDate, DeliveryDate = this.Invoice.DeliveryDate, Description = this.Invoice.Description, Status = this.Invoice.InvoiceStatusId, EmpDeliveryId = this.DelivererId }; lDataContext.Invoices.InsertOnSubmit(newInvoice); try { lDataContext.SubmitChanges(); this.Invoice.Id = newInvoice.Id; } catch (SqlException ex) { if (ex.Number == 2627) { MessageBox.Show("Cannot insert duplicate Invoice No [" + this.Invoice.InvoiceNo + "] Please save again."); } else { MessageBox.Show("SqlException : " + ex.Message); } ChangeSet pendingChanges = lDataContext.GetChangeSet(); foreach (object obj in pendingChanges.Inserts) { var tableToDeleteFrom = lDataContext.GetTable(obj.GetType()); //(tableToDeleteFrom as DataSource.Invoice).InvoiceNo = GetInvoiceNo(); //lDataContext.SubmitChanges(); //this.Invoice.Id = newInvoice.Id; tableToDeleteFrom.DeleteOnSubmit(obj); } return(false); } catch (Exception ex) { this.Message = "Faled to Save - Invoice Detail"; return(false); } } else { lInvoice.CustomerId = this.CustomerId; lInvoice.InvoiceNo = this.Invoice.InvoiceNo; lInvoice.InvoiceDate = this.Invoice.InvoiceDate; lInvoice.DeliveryDate = this.Invoice.DeliveryDate; lInvoice.Description = this.Invoice.Description; lInvoice.EmpDeliveryId = this.DelivererId; lInvoice.Status = this.Invoice.InvoiceStatusId; try { lDataContext.SubmitChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); this.Message = "Faled to Update - Invoice Detail"; return(false); } } DataSource.Order lOrder = lDataContext.Orders.SingleOrDefault(p => p.Id == this.Id); if (lOrder == null) { DataSource.Order lnewOrder = new DataSource.Order { CustomerId = this.CustomerId, OrderDate = this.OrderDate.Value, InvoiceId = (this.Invoice == null) ? null : this.Invoice.Id, EmpDeliveryId = this.DelivererId, EmployeeId = this.SellerId, RequiredDate = DateTime.Now, ShippedDate = DateTime.Now, Description = this.Description }; lDataContext.Orders.InsertOnSubmit(lnewOrder); try { lDataContext.SubmitChanges(); this.Id = lnewOrder.Id; } catch (Exception ex) { MessageBox.Show(ex.Message); this.Message = "Faled to Save - Order Detail"; return(false); } } else { lOrder.CustomerId = this.CustomerId; lOrder.OrderDate = this.OrderDate.Value; lOrder.InvoiceId = this.Invoice.Id; lOrder.EmpDeliveryId = this.DelivererId; lOrder.EmployeeId = this.SellerId; lOrder.RequiredDate = DateTime.Now; lOrder.ShippedDate = DateTime.Now; lOrder.Description = this.Description; try { lDataContext.SubmitChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); this.Message = "Faled to Update - Order Detail"; return(false); } } foreach (HSSupplyItem l in this.SupplyItems) { if (l.Id == -1 || l.Id == null) { DataSource.OrderItem lDSOrderItem = new OrderItem(); lDSOrderItem.OrderId = this.Id.Value; lDSOrderItem.SalesStatusId = l.SalesStatusId; lDSOrderItem.ProductId = l.ProductId; lDSOrderItem.VatId = l.VatId; lDSOrderItem.UnitPrice = l.UnitPrice; lDSOrderItem.Quantity = l.Quantity; lDSOrderItem.SellingUnitId = (l.SellingUnitId == null) ? 0 : l.SellingUnitId; lDSOrderItem.Description = l.Description; lDataContext.OrderItems.InsertOnSubmit(lDSOrderItem); try { lDataContext.SubmitChanges(); l.Id = lDSOrderItem.Id; } catch (Exception ex) { MessageBox.Show(ex.Message); this.Message = "Faled to Save - OrderItem Detail"; return(false); } } else { DataSource.OrderItem lItem = lDataContext.OrderItems.SingleOrDefault(p => p.Id == l.Id); lItem.OrderId = this.Id.Value; lItem.SalesStatusId = l.SalesStatusId; lItem.ProductId = l.ProductId; lItem.VatId = l.VatId; lItem.UnitPrice = l.UnitPrice; lItem.Quantity = l.Quantity; lItem.SellingUnitId = (l.SellingUnitId == null) ? 0 : l.SellingUnitId; lItem.Description = l.Description; try { lDataContext.SubmitChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); this.Message = "Faled to Update - OrderItem Detail"; return(false); } } } this.Message = "Saved Successfully..."; return(false); }
public void EndEdit() { Boolean lChanged = false; DataSource.Employee lUpdate = lDataContext.Employees.SingleOrDefault(p => p.Id == this.Id); if (lUpdate == null) { DataSource.Employee newItem = new DataSource.Employee { PersonId = this.PersonId, DateIn = this.DateIn, DateOut = this.DateOut, }; // Add the new object to the Orders collection. lDataContext.Employees.InsertOnSubmit(newItem); // Submit the change to the database. try { lDataContext.SubmitChanges(); this.Id = newItem.Id; } catch (Exception e) { Console.WriteLine(e); } } else { lUpdate.PersonId = this.PersonId; lUpdate.DateIn = this.DateIn; lUpdate.DateOut = this.DateOut; lDataContext.SubmitChanges(); } DataSource.Emp_Dept lEmpDept; foreach (HSDepartment l in this.Departments) { lEmpDept = lDataContext.Emp_Depts.SingleOrDefault(p => p.EmployeeId == this.Id && p.DepartmentId == l.Id); if (lEmpDept == null) { if (l.IsSelected) { DataSource.Emp_Dept newEmpDept = new DataSource.Emp_Dept { EmployeeId = this.Id, DepartmentId = l.Id }; // Add the new object to the Orders collection. lDataContext.Emp_Depts.InsertOnSubmit(newEmpDept); lChanged = true; } } else { if (l.IsSelected) { lEmpDept.EmployeeId = this.Id; lEmpDept.DepartmentId = l.Id; } else { lDataContext.Emp_Depts.DeleteOnSubmit(lEmpDept); } lChanged = true; } try { if (lChanged) { lDataContext.SubmitChanges(); } } catch (Exception e) { Console.WriteLine(e); } } }