//Determina si el documento existe //params Objeto tipo documento(propiedad Nombre) public bool ExisteDocumento(string nombre, Proyecto p) { using (var db = new Model.Context()) { try { List <Documento> lDocs = new List <Documento>(); lDocs = db.DocumentoSet. Where(b => b.ProyectoId. Equals(p.Id) && b.Nombre.Equals(nombre)) .ToList(); if (lDocs.Count > 0) { return(true); } else { return(false); } } catch (Exception e) { throw new Exception("Hubo un error en base de datos.", e); } } }
public Documento GetDocumentoUbicacion(string ubicacion) { using (var db = new Model.Context()) { return(db.DocumentoSet.Single(b => b.Ubicacion.Equals(ubicacion))); } }
public void addProjToUser(ConectionData data, ScaffoldedModel models) { Model.Context context = new Model.Context(); Model.User user = context.User.Where(c => c.LoginName == User.Identity.Name).FirstOrDefault(); Model.Projects project = new Model.Projects(); project.Owner = user; project.OwnerId = user.Id; project.ProjectName = data.ProjName; project.ContextName = data.ContextName; project.ConnectionString = data.ConnectionString; context.Add(project); foreach (var file in models.AdditionalFiles) { Model.Model model = new Model.Model(); model.Project = project; model.Projectid = project.Id; model.Model1 = file.Code; model.Filename = Path.GetFileName(file.Path); context.Add(model); } Model.Model ContextModel = new Model.Model(); ContextModel.Project = project; ContextModel.Projectid = project.Id; ContextModel.Model1 = models.ContextFile.Code; ContextModel.Filename = Path.GetFileName(models.ContextFile.Path); context.Add(ContextModel); context.SaveChanges(); context.Dispose(); }
// Function to delect a result of simulation public void delectSimulaion(Simulation Sim) { using (var context = new Model.Context()) { int SimId = Sim.Id; Cursor.Current = Cursors.WaitCursor; // waiting animation cursor //context.Database.Initialize(force: true); // connect to db, it takes time context.Database.Initialize(force: true); // connect to db, it takes time Model.Simulation SimToRemove = context.Simulations.Where(u => u.Id == SimId).First(); if (SimToRemove != null) { context.Simulations.Attach(SimToRemove); context.Simulations.Remove(SimToRemove); context.SaveChanges(); VMMain.UIMainForm.genMsgBox("Simulation deleted.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } Cursor.Current = Cursors.Arrow; // get back to normal cursor SimulationForBinding = new List <Simulation>(Simulations); blSimulation = new BindingList <Simulation>(SimulationForBinding); this.View.getLboxSim().DataSource = blSimulation; this.View.getLboxSim().DisplayMember = "LbInformation"; } }
/// <summary> /// Speichert eine neue Tätigkeit im Model /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, RoutedEventArgs e) { Model.TR_ARBEIT currentArbeit = this.gridArbeitsDaten.DataContext as Model.TR_ARBEIT; if (currentArbeit != null) { using (Model.Context context = new Model.Context()) { Model.TR_ARBEIT arbeitToSave; if (!currentArbeit.isNew) { arbeitToSave = context.TR_ARBEIT.Where(q => q.ARB_ID == currentArbeit.ARB_ID).First(); if (arbeitToSave != null) { context.ApplyCurrentValues<Model.TR_ARBEIT>("TR_ARBEIT", currentArbeit); context.SaveChanges(); } } else { context.AddToTR_ARBEIT(currentArbeit); context.SaveChanges(); } } this.dataGridArbeitsDaten.DataContext = getArbeit(); } }
public IActionResult ProjectLoad([FromBody] string ProjectID) { if (ProjectID != null) { var context = new Model.Context(); var projectdb = context.Projects.Where(c => c.Id == Convert.ToInt32(ProjectID)).FirstOrDefault(); var Project = new Tempproj(); Project.Data = new ConectionData() { ConnectionString = projectdb.ConnectionString, ContextName = projectdb.ContextName, ProjName = projectdb.ProjectName }; Project.Id = projectdb.Id; Project.FileNames = context.Model.Where(c => c.Projectid == projectdb.Id).Select(e => e.Filename).ToList(); Project.Models = context.Model.Where(c => c.Projectid == projectdb.Id).Select(e => e.Model1).ToList(); Project.RandomEnding = randomEndingForFolder; context.Dispose(); return(Ok(Project)); } else { return(BadRequest()); } }
/// <summary> /// Speichert Änderungen eines Nutzerdatensatzes im Model /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, RoutedEventArgs e) { Model.T_NUTZER currentNutzer = this.gridNutzerDaten.DataContext as Model.T_NUTZER; if (currentNutzer != null) { using (Model.Context context = new Model.Context()) { Model.T_NUTZER nutzerToSave; if (!currentNutzer.isNew) { nutzerToSave = context.T_NUTZER.Where(q => q.NUT_ID == currentNutzer.NUT_ID).First(); if (nutzerToSave != null) { context.ApplyCurrentValues<Model.T_NUTZER>("T_NUTZER", currentNutzer); context.SaveChanges(); } } else { context.AddToT_NUTZER(currentNutzer); context.SaveChanges(); } } this.dataGridNutzerDaten.DataContext = getNutzer(); } }
// Function to save the result of simulation public void saveSimulation(Model.Simulation simulation) { if (this.View.isSimulate == true) { using (var context = new Model.Context()) { Cursor.Current = Cursors.WaitCursor; // waiting animation cursor context.Database.Initialize(force: false); // connect to db context.Simulations.Add(simulation); try { context.SaveChanges(); // save change VMMain.UIMainForm.genMsgBox("Simulation saved!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception e) { VMMain.HandleException(e, this.VMMain.UIMainForm); VMMain.UIMainForm.genMsgBox("Fail to save the simulation", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); Cursor.Current = Cursors.Arrow; // get back to normal cursor } } } else { VMMain.UIMainForm.genMsgBox("You haven't simulated yet.", "error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public override void BeforeEachTest() { FieldInfo fieldInfo = typeof(ExampleC.InExampleC_1).GetField("is_spec_1", BindingFlags.Instance | BindingFlags.NonPublic); context = Target.FindContexts(fieldInfo); }
/** * Connect database and get Client list */ public void getDataFromDb() { Cursor.Current = Cursors.WaitCursor; // waiting animation cursor using (var context = new Model.Context()) { context.Database.Initialize(force: false); // connect to db, it takes time Clients = context.Clients .Include(c => c.AccountList) // get related entities .Include(bpl => bpl.BoughtProductList) .Include("BoughtProductList.Product") .Include("BoughtProductList.Product.TimeInterests") .Include("BoughtProductList.Product.SillInterests") .ToList(); } Cursor.Current = Cursors.Arrow; // get back to normal cursor ClientsForBinding = new List <Client>(Clients); // clone for binding list ProductsForBinding = new List <BoughtProduct>(); // bind list to listBoxes blClients = new BindingList <Client>(ClientsForBinding); blProducts = new BindingList <BoughtProduct>(ProductsForBinding); View.getLBoxClient().DataSource = blClients; View.getLBoxClient().DisplayMember = "FullName"; View.getLBoxProduct().DataSource = blProducts; View.getLBoxProduct().DisplayMember = "Name"; }
public void Execute(object parameter) { if ( MessageBox.Show( "Ao realizar esta ação, todas as informações armazenadas sobre o conteúdo que você possui serão apagadas (entretanto todos os arquivos de vídeo que você possui permanecerá intacto). Você realmente deseja realizar esta ação?", Properties.Settings.Default.AppName, MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { using (var db = new Model.Context()) { db.Database.ExecuteSqlCommand(@"/*Disable Constraints & Triggers*/ exec sp_MSforeachtable 'IF OBJECT_ID(''?'') NOT IN (ISNULL(OBJECT_ID(''[dbo].[__MigrationHistory]''),0)) ALTER TABLE ? NOCHECK CONSTRAINT ALL' exec sp_MSforeachtable 'IF OBJECT_ID(''?'') NOT IN (ISNULL(OBJECT_ID(''[dbo].[__MigrationHistory]''),0)) ALTER TABLE ? DISABLE TRIGGER ALL' /*Perform delete operation on all table for cleanup*/ exec sp_MSforeachtable 'IF OBJECT_ID(''?'') NOT IN (ISNULL(OBJECT_ID(''[dbo].[__MigrationHistory]''),0)) DELETE ?' /*Enable Constraints & Triggers again*/ exec sp_MSforeachtable 'IF OBJECT_ID(''?'') NOT IN (ISNULL(OBJECT_ID(''[dbo].[__MigrationHistory]''),0)) ALTER TABLE ? CHECK CONSTRAINT ALL' exec sp_MSforeachtable 'IF OBJECT_ID(''?'') NOT IN (ISNULL(OBJECT_ID(''[dbo].[__MigrationHistory]''),0)) ALTER TABLE ? ENABLE TRIGGER ALL' /*Reset Identity on tables with identity column*/ exec sp_MSforeachtable 'IF OBJECT_ID(''?'') NOT IN (ISNULL(OBJECT_ID(''[dbo].[__MigrationHistory]''),0)) AND OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasIdentity'') = 1 BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'"); } frmMain.MainVM.AtualizarPosters(Enums.TipoConteudo.AnimeFilmeSérie); } }
public override void BeforeEachTest() { descriptions = Target.FindContextsIn(typeof(Account).Assembly); context = descriptions.Where(x => x.Name == "when transferring between two accounts").FirstOrDefault(); context.ShouldNotBeNull(); }
/// <summary> /// Speichert ein neues Material im Model /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, RoutedEventArgs e) { Model.TR_MATERIAL currentMaterial = this.gridMaterialDaten.DataContext as Model.TR_MATERIAL; if (currentMaterial != null) { using (Model.Context context = new Model.Context()) { Model.TR_MATERIAL materialToSave; if (!currentMaterial.isNew) { materialToSave = context.TR_MATERIAL.Where(q => q.MAT_ID == currentMaterial.MAT_ID).First(); if (materialToSave != null) { context.ApplyCurrentValues<Model.TR_MATERIAL>("TR_MATERIAL", currentMaterial); context.SaveChanges(); } } else { context.AddToTR_MATERIAL(currentMaterial); context.SaveChanges(); } } this.dataGridMaterialDaten.DataContext = getMaterial(); } }
public IActionResult EditModel([FromBody] EditModel tempproj) { Model.Context context = new Model.Context(); Model.Model model = context.Model.Where(c => c.Projectid == tempproj.Id).Where(c => c.Filename == tempproj.Filename).FirstOrDefault(); model.Model1 = tempproj.Model; context.SaveChanges(); return(Ok()); }
private void SaveScript(Model.Script script) { using (var context = new Model.Context()) { context.Scripts.Add(script); context.SaveChanges(); } }
/// <summary> /// Gibt alle Nutzer zurück /// </summary> /// <returns>Liste der Nutzer</returns> private List<Model.T_NUTZER> getNutzer() { List<Model.T_NUTZER> nutzer = new List<Model.T_NUTZER>(); using(Model.Context context = new Model.Context()) { nutzer = context.T_NUTZER.ToList(); } return nutzer; }
/** * Sell the selected product */ public void SellProduct() { if (View.getLBoxClient().SelectedValue != null) { if (View.getLBoxProduct().SelectedValue != null) { Client selectedClt = (Client)View.getLBoxClient().SelectedValue; BoughtProduct selectedPdt = (BoughtProduct)View.getLBoxProduct().SelectedValue; List <TimeInterest> TimeInterest = selectedPdt.Product.TimeInterests; int periode = (int)(DateTime.Today.Date - selectedPdt.StartDate).TotalDays / 30; Decimal TimeInterestPdt = Utils.FindTimeInterestSection(selectedPdt.StartDate, DateTime.Today, selectedPdt.Product.TimeInterests).Interest; Decimal SillInterestPdt = Utils.FindSillInterestSection(selectedPdt.Price, selectedPdt.Product.SillInterests).Interest; Decimal InterestRate = 0; Decimal InterestPdt = 0; if (TimeInterestPdt != 0) { InterestRate = (TimeInterestPdt + 100) * (SillInterestPdt + 100) / 100 - 100; InterestPdt = InterestRate / 100 * selectedPdt.Price; } DialogResult d = MessageBox.Show("You will have an interest rate : " + InterestRate.ToString("0.##") + " % and amount : " + InterestPdt.ToString("0.##") + ", are you sure to sell them now?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (d == DialogResult.Yes) { selectedClt.BoughtProductList.Remove(selectedPdt); selectedClt.AccountList[0].Balance = selectedClt.AccountList[0].Balance + InterestPdt; using (var context = new Model.Context()) { Cursor.Current = Cursors.WaitCursor; // waiting animation cursor context.Database.Initialize(force: false); // connect to db List <Client> clients = context.Clients .Include(c => c.AccountList) // get related entities .Include(bpl => bpl.BoughtProductList) .Include("BoughtProductList.Product") .ToList(); Client clientInDb = clients.Where(c => c.Id == selectedClt.Id).SingleOrDefault(); BoughtProduct productS = context.BoughtProducts.Where(c => c.Id == selectedPdt.Id).SingleOrDefault(); context.BoughtProducts.Remove(productS); clientInDb.BoughtProductList.Remove(selectedPdt); clientInDb.AccountList[0].Balance = clientInDb.AccountList[0].Balance + InterestPdt; //Console.Write(context.Clients.Find(VMMain.Client.Id).FirstName); context.SaveChanges(); } this.loadClientDetail(selectedClt); } } else { this.VMMain.UIMainForm.genMsgBox("You haven't chosen a product yet.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { this.VMMain.UIMainForm.genMsgBox("You haven't chosen a client yet.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public Documento GetDocumento(string nombre, Proyecto p) { using (var db = new Model.Context()) { return(db.DocumentoSet .Single(b => b.Nombre .Equals(nombre) && b.ProyectoId.Equals(p.Id))); } }
/** * Functions for 3 buttons, add, modify and choose client */ public bool addClient(string firstName, string lastName, string idCardNumber) { bool isSuccess = true; if (firstName == "" || lastName == "" || idCardNumber == "") { VMMain.UIMainForm.genMsgBox("Please enter all 3 textboxes.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); isSuccess = false; } else if (firstName.Length > 20 || lastName.Length > 20) { VMMain.UIMainForm.genMsgBox("First name and last name should less than 20 characters", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); isSuccess = false; } else if (idCardNumber.Length > 20) { VMMain.UIMainForm.genMsgBox("ID card number should less than 20 characters", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); isSuccess = false; } else { // creaete a client by input Client clt = new Client(firstName, lastName, idCardNumber); // create a default account Account acc = new Account(); acc.Client = clt; acc.Number = DateTime.Now.ToString("yyyyMMddHHmmssf"); // use time of now , a unique number acc.status = 1; acc.Balance = 0M; clt.AccountList = new List <Account>(); clt.AccountList.Add(acc); using (var context = new Model.Context()) { Cursor.Current = Cursors.WaitCursor; // waiting animation cursor context.Database.Initialize(force: false); // connect to db context.Clients.Add(clt); try { context.SaveChanges(); // save change getDataFromDb(); // refresh the list } catch (Exception e) { VMMain.HandleException(e, this.VMMain.UIMainForm); isSuccess = false; } Cursor.Current = Cursors.Arrow; // get back to normal cursor } } return(isSuccess); }
/// <summary> /// Gibt alle Nutzer zurück /// </summary> /// <param name="sender"></param> /// <param name="e">Liste aller Nutzer</param> private void dataGridNutzerDaten_SelectionChanged(object sender, SelectionChangedEventArgs e) { Model.T_NUTZER selectedItem = this.dataGridNutzerDaten.SelectedItem as Model.T_NUTZER; if (selectedItem != null) { using (Model.Context context = new Model.Context()) { this.gridNutzerDaten.DataContext = context.T_NUTZER.Where(q => q.NUT_ID == selectedItem.NUT_ID).First(); } } }
public void generateChart() { Dictionary <DateTime, decimal> chartData = new Dictionary <DateTime, decimal>(); // get list of bought product using (var context = new Model.Context()) { Cursor.Current = Cursors.WaitCursor; // waiting animation cursor context.Database.Initialize(force: false); // connect to db /*List<BoughtProduct> bpList = context.BoughtProducts.ToList(); * foreach (BoughtProduct bp in bpList) * { * chartData.Add(bp.BuyingDate, bp.Price); * }*/ DateTime last3Day = DateTime.Today.AddMonths(-3).AddDays(-3); foreach (DateTime day in EachDay(DateTime.Today.AddMonths(-3), DateTime.Today)) { List <BoughtProduct> bps = context.BoughtProducts .Where(bp => bp.BuyingDate > last3Day && bp.BuyingDate < day).ToList(); decimal sum = 0; foreach (BoughtProduct bp in bps) { sum = sum + bp.Price; } chartData.Add(day, sum); Console.WriteLine("day = " + day + "sum = " + sum); last3Day = day; } Cursor.Current = Cursors.Arrow; // get back to normal cursor } // sort dictionary by date // ref: http://stackoverflow.com/questions/289/how-do-you-sort-a-dictionary-by-value var sortedDict = from entry in chartData orderby entry.Key ascending select entry; // convert IEnumerable to dictionary // ref: http://stackoverflow.com/questions/3066182/convert-an-iorderedenumerablekeyvaluepairstring-int-into-a-dictionarystrin Dictionary <DateTime, decimal> sortedChartData = sortedDict.ToDictionary(pair => pair.Key, pair => pair.Value); System.Windows.Forms.DataVisualization.Charting.Chart chartTA = View.getChartTA(); // binding data chartTA.Series[0].Points.DataBindXY(sortedChartData.Keys, sortedChartData.Values); // reset linetension property to make line not too smooth // ref: http://stackoverflow.com/questions/38080022/spline-chart-smooth-corners chartTA.Series[0].SetCustomProperty("LineTension", "0.3"); }
// Agregar una etiqueta a la lista // params: objeto de la clase AccesoDatos.Model.Etiqueta public void AgregarEtiqueta(Model.Etiqueta etiqueta) { using (var db = new Model.Context()) { try { db.EtiquetaSet.Add(etiqueta); db.SaveChanges(); } catch (Exception e) { throw new Exception("No se ha podido agregar la etiqueta ", e); } } }
// Obtener una Palabra de la lista según filtro aplicado (propiedad nombre) // params: objeto de la clase AccesoDatos.Model.Palabra public Model.Palabra ListaPalabrasFiltro(Palabra palabra) { using (var db = new Model.Context()) { try { var pal = db.PalabraSet.Single(b => b.Nombre.Equals(palabra.Nombre)); return(pal); } catch (Exception e) { throw new Exception("No hay palabras guardados.", e); } } }
// Agregar un proyecto a la lista // params: objeto de la clase AccesoDatos.Model.Proyecto public void AgregarProyecto(Proyecto proyecto) { using (var db = new Model.Context()) { try { db.ProyectoSet.Add(proyecto); db.SaveChanges(); } catch (Exception e) { throw new Exception("No se ha podido agregar el proyecto ", e); } } }
public IActionResult Newproject(Project project) { var context = new Model.Context(); var newproject = new Model.Projects(); newproject.ConnectionString = project.ConnectionString; newproject.ContextName = project.Context; newproject.ProjectName = project.Name; newproject.OwnerId = context.User.Where(c => c.LoginName == User.Identity.Name).FirstOrDefault().Id; context.Add(newproject); context.SaveChanges(); return(Ok()); }
// Agregar un documento a la lista // params: objeto de la clase AccesoDatos.Model.Documento public void AgregarDocumento(Documento documento) { using (var db = new Model.Context()) { try { db.DocumentoSet.Add(documento); db.SaveChanges(); } catch (Exception e) { throw new Exception("No se ha podido agregar el documento", e); } } }
// Agregar una palabra a la lista // params: objeto de la clase AccesoDatos.Model.Palabra public void AgregarPalabra(Palabra palabra) { using (var db = new Model.Context()) { try { db.PalabraSet.Add(palabra); db.SaveChanges(); } catch (Exception e) { throw new Exception("No se ha podido agregar la palabra ", e); } } }
public Control (string rootPackageName , string projectName , string outputDirectory , Model.Context ctx = null ) { _RootPackageNameField = rootPackageName; _ProjectNameField = projectName; _OutputDirectoryField = outputDirectory; if (ctx != null) { Context = ctx; } }
// Elimina una cita de la lista // params: objeto de la clase AccesoDatos.Model.Cita public void EliminarCita(Model.Cita cita) { using (var db = new Model.Context()) { try { var citaTmp = db.CitaSet.FirstOrDefault(x => x.Id == cita.Id); db.CitaSet.Remove(citaTmp); db.SaveChanges(); } catch (Exception e) { throw new Exception("No se ha podido eliminar la cita ", e); } } }
// Elimina un proyecto de la lista // params: objeto de la clase AccesoDatos.Model.Proyecto public void EliminarProyecto(Proyecto proyecto) { using (var db = new Model.Context()) { try { var proy = db.ProyectoSet.FirstOrDefault(x => x.Id == proyecto.Id); db.ProyectoSet.Remove(proy); db.SaveChanges(); } catch (Exception e) { throw new Exception("No se ha podido eliminar el proyecto ", e); } } }
// Elimina un etiqueta de la lista // params: objeto de la clase AccesoDatos.Model.Etiqueta public void EliminarEtiqueta(Model.Etiqueta etiqueta) { using (var db = new Model.Context()) { try { var etiq = db.EtiquetaSet.FirstOrDefault(x => x.Id == etiqueta.Id); db.EtiquetaSet.Remove(etiq); db.SaveChanges(); } catch (Exception e) { throw new Exception("No se ha podido eliminar la etiqueta ", e); } } }
public List <Model.Context> GetSelectedItems() { List <Model.Context> result = new List <Model.Context>(); uint i = _resultView.SelectedRowIndexes.FirstIndex; while (i != NSRange.NSNotFoundRange.location) { Model.Context context = _results.Items[(int)i]; result.Add(context); i = _resultView.SelectedRowIndexes.IndexGreaterThanIndex(i); } return(result); }
// Agregar una nube a la lista // params: objeto de la clase AccesoDatos.Model.Nube public void AgregarNube(Model.Nube nube) { using (var db = new Model.Context()) { try { db.NubeSet.Add(nube); db.SaveChanges(); } catch (Exception e) { throw new Exception("No se ha podido agregar la nube ", e); } } }
public Model.Nube NubeFiltro(Documento d, Proyecto proyecto) { using (var db = new Model.Context()) { ObservableCollection<Model.Nube> nubes = new ObservableCollection<Nube>(); try { return db.NubeSet.Single(b => b.ProyectoId.Equals(proyecto.Id) && b.DocumentoId.Equals(d.Id)); } catch (Exception e) { throw new Exception("No hay nubes guardadas.", e); } } }
public List <Model.Etiqueta> ListaEtiquetasList() { ObservableCollection <Etiqueta> etiquetas = new ObservableCollection <Etiqueta>(); using (var db = new Model.Context()) { try { return(db.EtiquetaSet.OrderBy(b => b.Id).ToList()); } catch (Exception e) { throw new Exception("No hay etiquetas guardadas.", e); } } }
private void btnSave_Click(object sender, RoutedEventArgs e) { Model.T_REPARATUR currentReparatur = this.gridReparaturDaten.DataContext as Model.T_REPARATUR; List<Model.TZ_ARBEITLISTE> al = this.dataGridArbeit.DataContext as List<Model.TZ_ARBEITLISTE>; if (currentReparatur != null) { using (Model.Context context = new Model.Context()) { Model.T_REPARATUR reparaturToSave; if (!currentReparatur.isNew) { reparaturToSave = context.T_REPARATUR.Where(q => q.REP_ID == currentReparatur.REP_ID).FirstOrDefault(); if (reparaturToSave != null) { foreach (Model.TZ_ARBEITLISTE arbl in al) { if (arbl.ABL_ID > 0) { context.ApplyCurrentValues<Model.TZ_ARBEITLISTE>("TZ_ARBEITLISTE", arbl); } else { context.AddToTZ_ARBEITLISTE(arbl); } } context.ApplyCurrentValues<Model.T_REPARATUR>("T_REPARATUR", currentReparatur); context.SaveChanges(); } } else { context.AddToT_REPARATUR(currentReparatur); context.SaveChanges(); } } this.dataGridReparaturDaten.DataContext = getReparaturen(); } }
/// <summary> /// Löscht ein Fahrzeug aus dem Model /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, RoutedEventArgs e) { Model.T_FAHRZEUG currentFahrzeug = this.gridFahrzeug.DataContext as Model.T_FAHRZEUG; if (currentFahrzeug != null) { using (Model.Context context = new Model.Context()) { Model.T_FAHRZEUG fahrzeugToDelete = context.T_FAHRZEUG.Where(q => q.FZG_ID == currentFahrzeug.FZG_ID).FirstOrDefault(); if (fahrzeugToDelete != null) { context.T_FAHRZEUG.DeleteObject(context.T_FAHRZEUG.Where(q => q.FZG_ID == fahrzeugToDelete.FZG_ID).FirstOrDefault()); context.SaveChanges(); } } this.gridFahrzeug.DataContext = new Model.T_FAHRZEUG(); this.datagridFahrzeugDaten.DataContext = getFahrzeuge(); } }
/// <summary> /// Löscht einen Nutzer aus dem Model /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, RoutedEventArgs e) { Model.T_NUTZER currentNutzer = this.gridNutzerDaten.DataContext as Model.T_NUTZER; if (currentNutzer != null) { using (Model.Context context = new Model.Context()) { Model.T_NUTZER nutzerToDelete = context.T_NUTZER.Where(q => q.NUT_ID == currentNutzer.NUT_ID).First(); if (nutzerToDelete != null) { context.T_NUTZER.DeleteObject(context.T_NUTZER.Where(q => q.NUT_ID == nutzerToDelete.NUT_ID).First()); context.SaveChanges(); } } this.gridNutzerDaten.DataContext = new Model.T_NUTZER(); this.dataGridNutzerDaten.DataContext = getNutzer(); } }
/// <summary> /// Löscht eine Tätigkeit aus dem Model /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, RoutedEventArgs e) { Model.TR_ARBEIT currentArbeit = this.gridArbeitsDaten.DataContext as Model.TR_ARBEIT; if (currentArbeit != null) { using (Model.Context context = new Model.Context()) { Model.TR_ARBEIT arbeitToDelete = context.TR_ARBEIT.Where(q => q.ARB_ID == currentArbeit.ARB_ID).First(); if (arbeitToDelete != null) { context.TR_ARBEIT.DeleteObject(context.TR_ARBEIT.Where(q => q.ARB_ID == arbeitToDelete.ARB_ID).First()); context.SaveChanges(); } } this.gridArbeitsDaten.DataContext = new Model.TR_MATERIAL(); this.dataGridArbeitsDaten.DataContext = getArbeit(); } }
/// <summary> /// Löscht ein Material aus dem Model /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, RoutedEventArgs e) { Model.TR_MATERIAL currentMaterial = this.gridMaterialDaten.DataContext as Model.TR_MATERIAL; if (currentMaterial != null) { using (Model.Context context = new Model.Context()) { Model.TR_MATERIAL materialToDelete = context.TR_MATERIAL.Where(q => q.MAT_ID == currentMaterial.MAT_ID).First(); if (materialToDelete != null) { context.TR_MATERIAL.DeleteObject(context.TR_MATERIAL.Where(q => q.MAT_ID == materialToDelete.MAT_ID).First()); context.SaveChanges(); } } this.gridMaterialDaten.DataContext = new Model.TR_MATERIAL(); this.dataGridMaterialDaten.DataContext = getMaterial(); } }
/// <summary> /// Gibt alle Fahrzeugmarken zurück /// </summary> /// <returns>Liste der Fahrzeugmarken</returns> private List<Model.TR_FAHRZEUGMARKE> getFahrzeugmarkeCombo() { List<Model.TR_FAHRZEUGMARKE> marken = new List<Model.TR_FAHRZEUGMARKE>(); using (Model.Context context = new Model.Context()) { marken.AddRange(context.TR_FAHRZEUGMARKE.Distinct().ToList()); } return marken; }
/// <summary> /// Gibt alle Tätigkeiten zurück /// </summary> /// <returns>Liste der Tätigkeiten</returns> private List<Model.TR_ARBEIT> getArbeit() { List<Model.TR_ARBEIT> arbeit = new List<Model.TR_ARBEIT>(); using(Model.Context context = new Model.Context()) { arbeit = context.TR_ARBEIT.ToList(); } return arbeit; }
/// <summary> /// Gibt alle Tätigkeiten zurück /// </summary> /// <param name="sender"></param> /// <param name="e">Liste aller Tätigkeiten</param> private void dataGridArbeitsDaten_SelectionChanged(object sender, SelectionChangedEventArgs e) { Model.TR_ARBEIT selectedItem = this.dataGridArbeitsDaten.SelectedItem as Model.TR_ARBEIT; if (selectedItem != null) { using (Model.Context context = new Model.Context()) { this.gridArbeitsDaten.DataContext = context.TR_ARBEIT.Where(q => q.ARB_ID == selectedItem.ARB_ID).First(); } } }
/// <summary> /// Liefert alle Reparaturen /// </summary> /// <returns>Reparaturenliste</returns> private List<Model.T_REPARATUR> getReparaturen() { List<Model.T_REPARATUR> reparaturen; // = new List<Model.T_FAHRZEUG>(); using (Model.Context context = new Model.Context()) { // Fahrzeuge holen reparaturen = context.T_REPARATUR.ToList(); // ... deren Entitäten laden reparaturen.Where(q => q.T_FAHRZEUGReference != null).ToList().ForEach(q => q.T_FAHRZEUGReference.Load()); } return reparaturen.ToList(); }
/// <summary> /// Speichert Änderungen eines Fahrzeugdatensatzes im Model /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, RoutedEventArgs e) { Model.T_FAHRZEUG currentFahrzeug = this.gridFahrzeug.DataContext as Model.T_FAHRZEUG; if (currentFahrzeug != null) { using (Model.Context context = new Model.Context()) { Model.T_FAHRZEUG fahrzeugToSave; if (!currentFahrzeug.isNew) { fahrzeugToSave = context.T_FAHRZEUG.Where(q => q.FZG_ID == currentFahrzeug.FZG_ID).FirstOrDefault(); if (fahrzeugToSave != null) { context.ApplyCurrentValues<Model.T_FAHRZEUG>("T_FAHRZEUG", currentFahrzeug); context.SaveChanges(); } } else { context.AddToT_FAHRZEUG(currentFahrzeug); context.SaveChanges(); } } this.datagridFahrzeugDaten.DataContext = getFahrzeuge(); } }
/// <summary> /// Gibt alles Material zurück /// </summary> /// <returns>Liste des Materials</returns> private List<Model.TR_MATERIAL> getMaterial() { List<Model.TR_MATERIAL> material = new List<Model.TR_MATERIAL>(); using(Model.Context context = new Model.Context()) { material = context.TR_MATERIAL.ToList(); } return material; }
/// <summary> /// Gibt alle Fahrzeugarten zurück /// </summary> /// <returns>Liste der Fahrzeugarten</returns> private List<Model.TR_FAHRZEUGART> getFahrzeugarten() { List<Model.TR_FAHRZEUGART> arten = new List<Model.TR_FAHRZEUGART>(); using (Model.Context context = new Model.Context()) { arten.AddRange(context.TR_FAHRZEUGART.Distinct().ToList()); } return arten; }
/// <summary> /// Lädt die Detailansicht anhand der Datagridauswahl /// </summary> /// <param name="sender">Senderobjekt Datagrid</param> /// <param name="e">Argument des Senderobjekts</param> private void gridFahrzeugDaten_SelectionChanged(object sender, SelectionChangedEventArgs e) { Model.T_FAHRZEUG selectedItem = this.datagridFahrzeugDaten.SelectedItem as Model.T_FAHRZEUG; if (selectedItem != null) { using (Model.Context context = new Model.Context()) { this.gridFahrzeug.DataContext = context.T_FAHRZEUG.Where(q => q.FZG_ID == selectedItem.FZG_ID).FirstOrDefault(); } } }
/// <summary> /// Gibt alle Materialien zurück /// </summary> /// <param name="sender"></param> /// <param name="e">Liste aller Materialien</param> private void dataGridMaterialDaten_SelectionChanged(object sender, SelectionChangedEventArgs e) { Model.TR_MATERIAL selectedItem = this.dataGridMaterialDaten.SelectedItem as Model.TR_MATERIAL; if (selectedItem != null) { using (Model.Context context = new Model.Context()) { this.gridMaterialDaten.DataContext = context.TR_MATERIAL.Where(q => q.MAT_ID == selectedItem.MAT_ID).First(); } } }
/// <summary> /// Gibt alle Fahrzeugnutzer zurück /// </summary> /// <returns>Liste der Fahrzeugnutzer</returns> private List<Model.T_NUTZER> getFahrzeugnutzerCombo() { List<Model.T_NUTZER> nutzer = new List<Model.T_NUTZER>(); using (Model.Context context = new Model.Context()) { nutzer.AddRange(context.T_NUTZER.ToList()); } return nutzer; }
/// <summary> /// Gibt alle Fahrzeugtypen zurück /// </summary> /// <returns>Liste der Fahrzeugtypen</returns> private List<Model.TZ_FAHRZEUGTYP> getFahrzeugtypCombo() { List<Model.TZ_FAHRZEUGTYP> typen = new List<Model.TZ_FAHRZEUGTYP>(); using (Model.Context context = new Model.Context()) { typen.AddRange(context.TZ_FAHRZEUGTYP.Distinct().ToList()); } return typen; }
/// <summary> /// Gibt alle Fahrzeuge zurück /// </summary> /// <returns>Liste der Fahrzeuge</returns> private List<Model.T_FAHRZEUG> getFahrzeuge() { List<Model.T_FAHRZEUG> fahrzeuge; // = new List<Model.T_FAHRZEUG>(); using (Model.Context context = new Model.Context()) { // Fahrzeuge holen fahrzeuge = context.T_FAHRZEUG.ToList(); // ... deren Entitäten laden fahrzeuge.Where(q => q.TZ_FAHRZEUGTYPReference != null).ToList().ForEach(q => q.TZ_FAHRZEUGTYPReference.Load()); fahrzeuge.Where(q => q.TR_FAHRZEUGARTReference != null).ToList().ForEach(q => q.TR_FAHRZEUGARTReference.Load()); fahrzeuge.Where(q => q.T_NUTZERReference != null).ToList().ForEach(q => q.T_NUTZERReference.Load()); fahrzeuge.Where(q => q.TZ_FAHRZEUGTYP != null && q.TZ_FAHRZEUGTYP.TR_FAHRZEUGMARKEReference != null).ToList() .ForEach(q => q.TZ_FAHRZEUGTYP.TR_FAHRZEUGMARKEReference.Load()); } return fahrzeuge.ToList(); }
/// <summary> /// Liefert alle Arbeitslisten /// </summary> /// <returns>Arbeitsliste</returns> private List<Model.TZ_ARBEITLISTE> getArbeitliste() { List<Model.TZ_ARBEITLISTE> arbeitliste; // = new List<Model.T_FAHRZEUG>(); using (Model.Context context = new Model.Context()) { // Fahrzeuge holen arbeitliste = context.TZ_ARBEITLISTE.ToList(); // Entitäten laden arbeitliste.Where(q => q.TR_ARBEITReference != null).ToList().ForEach(q => q.TR_ARBEITReference.Load()); } return arbeitliste.ToList(); }