public CompanySite() { Site = ApplicationDataContext.Instance.SystemEntityContext.SYS_Site.Include("SYS_Entity").FirstOrDefault(n => n.SYS_Entity.Id == ApplicationDataContext.Instance.LoggedInUser.DefaultSiteId); Entity = Site.SYS_Entity; billingAddress = Site.SYS_Address_BillingAddress; //dataContext.EntitySystemContext.SYS_Address.FirstOrDefault(n => n.Id == Site.BillingAddress); shippingAddress = Site.SYS_Address_ShippingAddress; //dataContext.EntitySystemContext.SYS_Address.FirstOrDefault(n => n.Id == Site.ShippingAddress); printerBarcode = Site.SYS_Printer_Barcode; //dataContext.EntitySystemContext.SYS_Printer.FirstOrDefault(n => n.Id == Site.PrinterBarcode); printerPicker = Site.SYS_Printer_Picker; //dataContext.EntitySystemContext.SYS_Printer.FirstOrDefault(n => n.Id == Site.PrinterPicker); printerReceipt = Site.SYS_Printer_Receipt; //dataContext.EntitySystemContext.SYS_Printer.FirstOrDefault(n => n.Id == Site.PrinterReceipt); }
public void OpenRecord(DB.SYS_Site siteCopy) { try { BindingSource.DataSource = siteCopy; } catch (Exception ex) { if (CDS.Shared.Exception.UserInterfaceExceptionHandler.HandleException(ref ex)) { throw ex; } } }
public SiteAccounts() { Site = ApplicationDataContext.Instance.SystemEntityContext.SYS_Site.Include("SYS_Entity").FirstOrDefault(n => n.SYS_Entity.Id == ApplicationDataContext.Instance.LoggedInUser.DefaultSiteId); SiteEntity = Site.SYS_Entity; List <int> siteTypes = Enum.GetValues(typeof(GLX.GLX_SystemAccountType)).Cast <int>().ToList(); //SEAN: //removed && n.SystemDefaultAccount == true here List <DB.GLX_SiteAccount> siteAccounts = ApplicationDataContext.Instance.AccountingEntityContext.GLX_SiteAccount.Where(n => siteTypes.Contains(n.TypeId) && n.SiteId == Site.EntityId).ToList(); bank = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.Bank); cardControl = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.CardControl); cashControl = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.CashControl); chequeControl = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.ChequeControl); costDifference = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.CostDifference); costOfSales = costOfSales = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.CostofSales); creditControl = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.CreditControl); creditors = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.Creditors); if (creditors != null) { creditorsEntity = ApplicationDataContext.Instance.SystemEntityContext.SYS_Entity.FirstOrDefault(n => n.Id == creditors.EntityId); } debtors = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.Debtors); if (debtors != null) { debtorsEntity = ApplicationDataContext.Instance.SystemEntityContext.SYS_Entity.FirstOrDefault(n => n.Id == debtors.EntityId); } distributedReserves = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.Distributedreserves); eftControl = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.Eftcontrol); interestCharged = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.InterestCharged); inventory = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.Inventory); profit = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.Profit); rounding = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.Rounding); sales = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.Sales); settlemetnDiscountAllowed = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.SettlementDiscountAllowed); settlemetnDiscountRecieved = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.SettlementDiscountReceived); stockAdjustment = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.StockAdjustment); vatControl = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.VatControl); vatInput = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.VatInput); vatOutput = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.VatOutput); inventoryBuyout = siteAccounts.FirstOrDefault(n => n.TypeId == (byte)GLX.GLX_SystemAccountType.InventoryBuyout); }
internal static String Save(DB.SYS_Site entry, DataContext dataContext) { try { if (dataContext.EntitySystemContext.GetEntityState(entry) == System.Data.Entity.EntityState.Detached) { dataContext.EntitySystemContext.SYS_Site.Add(entry); //TODO : Generate Stock items and history for this site } } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { return(dataContext.PackageValidationException()); } return("Success"); }
/// <summary> /// Loads and opens the next Role record. The current record is not saved. /// </summary> /// <remarks>Created: Theo Crous 23/07/2012</remarks> protected override void OnNextRecord() { try { base.OnNextRecord(); DB.SYS_Site sysSite = BL.SYS.SYS_Site.GetNextItem((DB.SYS_Site)BindingSource.DataSource, DataContext); if (sysSite != null) { BindingSource.DataSource = sysSite; } } catch (Exception ex) { if (CDS.Shared.Exception.UserInterfaceExceptionHandler.HandleException(ref ex)) { throw ex; } } }
public override void OpenRecord(Int64 Id) { try { //DB.SYS_Site sysSite = Context.SYS_Site.FirstOrDefault(n => n.Id == (int)Id); DB.SYS_Site sysSite = BL.SYS.SYS_Site.LoadByEntityId(Id, DataContext, new List <String>() { "SYS_Entity", "SYS_Address_BillingAddress", "SYS_Address_ShippingAddress", "SYS_Printer_Barcode", "SYS_Printer_Picker", "SYS_Printer_Receipt" }); BindingSource.DataSource = sysSite; BindingSourcePaymentAccounts.DataSource = BL.GLX.PaymentAccountSerializer.DeSerializePaymentAccounts(((DB.SYS_Site)BindingSource.DataSource).PaymentAccounts, typeof(List <BL.GLX.PaymentAccount>)); ddlSafetyStockPeriod.EditValue = Enum.GetName(typeof(BL.SYS.SYS_SafetyStockPeriod), ((DB.SYS_Site)BindingSource.DataSource).SafetyStockPeriod); } catch (Exception ex) { if (CDS.Shared.Exception.UserInterfaceExceptionHandler.HandleException(ref ex)) { throw ex; } } }
/*protected override void OnShown(EventArgs e) * { * * base.OnShown(e); * * OnOpenRecord(DataContext.EntitySystemContext.SYS_Site.FirstOrDefault().EntityId); * this.Close(); * }*/ private void btnCopySite_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { DB.SYS_Site copySite = BL.ApplicationDataContext.DeepClone <DB.SYS_Site>(BL.SYS.SYS_Site.LoadByEntityId(SelectedRowId, DataContext), BL.SYS.SYS_Site.New); DB.SYS_Entity copyEntity = BL.ApplicationDataContext.DeepClone <DB.SYS_Entity>((BL.SYS.SYS_Site.LoadByEntityId(SelectedRowId, DataContext, new List <String>() { "SYS_Entity" })).SYS_Entity, BL.SYS.SYS_Entity.NewSite); copySite.SYS_Entity = copyEntity; SiteForm childForm = new SiteForm(); childForm.OpenRecord(copySite); ShowForm(childForm); } catch (Exception ex) { if (CDS.Shared.Exception.UserInterfaceExceptionHandler.HandleException(ref ex)) { throw ex; } } }
public static DB.SYS_Site GetPreviousItem(DB.SYS_Site SYS_Site, DataContext dataContext) { return(dataContext.EntitySystemContext.SYS_Site.OrderByDescending(o => o.SYS_Entity.Name).FirstOrDefault(n => n.SYS_Entity.Name.CompareTo(SYS_Site.SYS_Entity.Name) < 0 && n.SYS_Entity.Name.CompareTo(SYS_Site.SYS_Entity.Name) != 0)); }
public static DB.SYS_Site GetNextItem(DB.SYS_Site SYS_Site, DataContext dataContext) { return(dataContext.EntitySystemContext.SYS_Site.OrderBy(o => o.SYS_Entity.Name).FirstOrDefault(n => n.SYS_Entity.Name.CompareTo(SYS_Site.SYS_Entity.Name) > 0 && n.SYS_Entity.Name.CompareTo(SYS_Site.SYS_Entity.Name) != 0)); }