private void SaveDbButton_Click(object sender, EventArgs e) { var logger = NLog.LogManager.GetCurrentClassLogger(); try { //String str = "Data Source=ESBA9336;Initial Catalog=ImageDataBase;Persist Security Info=True;User ID=sa;Password=Sunshine123"; //SqlConnection con = new SqlConnection(str); var imageDto = new ImagesLicence { dateAdded = DateTime.Now, active = true, carLicence = nameB.Text, localRoute = inputB.Text, name = MyGlobal.imageClassList[int.Parse(indiceB.Text)].ImageName }; using (var context = new ImageDataBaseEntities()) { IQueryable <ImagesLicence> imageSelected = GetImageDetails(imageDto.name, context); if (imageSelected.Any()) { imageSelected.FirstOrDefault().carLicence = nameB.Text; } else { context.ImagesLicences.Add(imageDto); } context.SaveChanges(); logger.Trace("New car licence saved name: {0}, car licence: {1}", imageDto.name, imageDto.carLicence); } } catch (Exception es) { MessageBox.Show(es.Message); } }
public void CheckLicenceDataBase(int index) { var first = MyGlobal.imageClassList[index]; try { using (var context = new ImageDataBaseEntities()) { IQueryable <ImagesLicence> imageSelected = GetImageDetails(first, context); if (imageSelected.Any()) { nameB.Text = imageSelected.FirstOrDefault().carLicence; } } } catch (Exception es) { MessageBox.Show(es.Message); } }
public void DeleteLicenceDataBase(int index) { var first = MyGlobal.imageClassList[index]; try { using (var context = new ImageDataBaseEntities()) { IQueryable <ImagesLicence> imageSelected = GetImageDetails(first, context); if (imageSelected.Any()) { imageSelected.FirstOrDefault().active = false; context.ImagesLicences.Remove(imageSelected.FirstOrDefault()); context.SaveChanges(); } } } catch (Exception es) { MessageBox.Show(es.Message); } }
private static IQueryable <ImagesLicence> GetImageDetails(string name, ImageDataBaseEntities context) { return(from img in context.ImagesLicences where img.name == name select img); }
private static IQueryable <ImagesLicence> GetImageDetails(ImageStructure first, ImageDataBaseEntities context) { return(from img in context.ImagesLicences where img.name == first.ImageName select img); }