public static ImagesTable FindLastAddedImage() { LinqToSqlDataContext db = DatabaseSetup.Database; ImagesTable last = (from l in db.ImagesTables select l).OrderByDescending(l => l.id).First(); return(last); }
public ActionResult DeleteConfirmed(int id) { ImagesTable imagesTable = db.ImagesTable.Find(id); db.ImagesTable.Remove(imagesTable); db.SaveChanges(); return(RedirectToAction("Index")); }
public static ImagesTable GetImageById(int id) { LinqToSqlDataContext db = DatabaseSetup.Database; ImagesTable image = (from i in db.ImagesTables where i.id == id select i).Single(); return(image); }
public static void RemoveImage(int imageId) { LinqToSqlDataContext db = DatabaseSetup.Database; ImagesTable imgGoner = (from goner in db.ImagesTables where goner.id == imageId select goner).Single(); db.ImagesTables.DeleteOnSubmit(imgGoner); db.SubmitChanges(); }
public ActionResult Edit([Bind(Include = "ID,ErrorNo,Name,AddedPlace,ImagePath")] ImagesTable imagesTable) { if (ModelState.IsValid) { db.Entry(imagesTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", imagesTable.ErrorNo); return(View(imagesTable)); }
public static void AddImage(ImageStruct imageStruct) { LinqToSqlDataContext db = DatabaseSetup.Database; ImagesTable img = new ImagesTable(); byte[] array = ImageToByte(imageStruct.image); img.name = imageStruct.imgName; img.img = array; db.ImagesTables.InsertOnSubmit(img); db.SubmitChanges(); }
// GET: ImagesTables/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ImagesTable imagesTable = db.ImagesTable.Find(id); if (imagesTable == null) { return(HttpNotFound()); } return(View(imagesTable)); }
private void BtnRemoveImage_Click(object sender, RoutedEventArgs e) { int gonerId = gallery.GetSelectedImageDatabaseID(); ImagesTable gonerImage = Images.GetImageById(gonerId); // odstranit propojení Images.RemoveRelationship(gonerId, _id); // odstranit obrázek z databáze Images.RemoveImage(gonerId); //Refresh gallery gallery.Images = Images.GetImages(StorageSetup.GetProductById(_id)); gallery.Update(); }
// GET: ImagesTables/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ImagesTable imagesTable = db.ImagesTable.Find(id); if (imagesTable == null) { return(HttpNotFound()); } ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", imagesTable.ErrorNo); return(View(imagesTable)); }
private void BtnAddImage_Click(object sender, RoutedEventArgs e) { // Nahrání obrázků do databáze System.Windows.Forms.OpenFileDialog ofd = new System.Windows.Forms.OpenFileDialog(); ofd.Multiselect = true; ofd.Filter = "Obrázky|*.jpg;*.bmp;*.png;*.gif"; if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string[] paths = ofd.FileNames; Uri[] uris = new Uri[paths.Count()]; for (int i = 0; i <= paths.Count() - 1; i++) { uris[i] = new Uri(paths[i]); } List <ImageStruct> imagesAdded = new List <ImageStruct>(); for (int u = 0; u <= uris.Count() - 1; u++) { ImageStruct s = new ImageStruct() { imgName = System.IO.Path.GetFileNameWithoutExtension(paths[u]), image = new BitmapImage(uris[u]) }; imagesAdded.Add(s); } foreach (ImageStruct istr in imagesAdded) { // Práce s databází Images.AddImage(istr); Product p = StorageSetup.GetProductById(_id); ImagesTable imt = Images.FindLastAddedImage(); Images.AssignImageToProduct(p, imt); } // Získání obrázků z databáze - i s ID's gallery.Images = Images.GetImages(StorageSetup.GetProductById(_id)); gallery.Update(); } }
public static bool AssignImageToProduct(Product product, ImagesTable image) { LinqToSqlDataContext db = DatabaseSetup.Database; ProductImage assignTable = new ProductImage(); try { assignTable.idImage = image.id; assignTable.idProduct = product.id; db.ProductImages.InsertOnSubmit(assignTable); db.SubmitChanges(); return(true); } catch { return(false); } }
public static void AddImage(string resourceName, string imageName) { LinqToSqlDataContext db = DatabaseSetup.Database; ImagesTable img = new ImagesTable(); var assembly = Assembly.GetExecutingAssembly(); byte[] imageBinary = null; using (BinaryReader br = new BinaryReader(assembly.GetManifestResourceStream(resourceName))) { imageBinary = br.ReadBytes((int)br.BaseStream.Length); } img.name = imageName; img.img = imageBinary; db.ImagesTables.InsertOnSubmit(img); db.SubmitChanges(); }
public void saveImagesDB(HttpPostedFileBase[] imageFiles, string addedStep, string errorNo) { var userModel = common.getCurrentUserModel(); System.IO.Directory.CreateDirectory(HttpContext.Current.Server.MapPath("~/images/" + userModel.Company)); // geçerli şirket resimlerine ait klasör yaratılır // Add image flie to db------------------ int counter = 0; foreach (var image in imageFiles) { try { counter++; ImagesTable imageTable = new ImagesTable(); imageTable.ErrorNo = errorNo; imageTable.AddedPlace = addedStep; var fileNameWithOutExtension = Path.GetFileNameWithoutExtension(image.FileName); // uzantısız adı alınır var extension = Path.GetExtension(image.FileName); // uzantısı alınır // uzantısız dosya adı illegal karakterlerden arındırıldı fileNameWithOutExtension = Regex.Replace(fileNameWithOutExtension, "[^a-zA-Z0-9_]+", "_", RegexOptions.Compiled); // dosya adı uzantısız olarak değiştirildi imageTable.Name = fileNameWithOutExtension; string filePath = "~/images/" + userModel.Company + "/" + "(" + addedStep + ")" + errorNo + "_" + counter.ToString() + "_" + fileNameWithOutExtension + extension; imageTable.ImagePath = filePath; db.ImagesTable.Add(imageTable); db.SaveChanges(); //Save the Image File in Folder. image.SaveAs(HttpContext.Current.Server.MapPath(filePath)); } catch (Exception ex) { } } }
private void btnSubmit_Click(object sender, RoutedEventArgs e) { try { string name = ValidateProduct.Name(tbName.Text); int quantity = ValidateProduct.Quantity(tbQuantity.Text); string unitName = cbUnit.Text; decimal unitQuantity = ValidateProduct.UnitQuantity(tbUnitQuantity.Text); DateTime?date = ValidateProduct.Date(dpExpirationDate.SelectedDate); int code = ValidateProduct.Code(tbCode.Text); decimal price = ValidateProduct.Price(tbPrice.Text); price = Convert.ToDecimal(Math.Round(Convert.ToDouble(price), 1, MidpointRounding.AwayFromZero)); // cena se zaokrouhlí na jedno desetinné místo bool priceForUnit = cbPriceForUnit.Text == "Ano" ? true : false; char VAT = cbVAT.SelectedItem.ToString()[0]; LinqToSqlDataContext db = DatabaseSetup.Database; int i = (from u in db.Units where u.name == unitName select u.id).Single(); int unitId = i; if (StorageSetup.AddProduct(name, quantity, unitId, unitQuantity, date, code, price, priceForUnit, VAT)) { // ještě je potřeba uložit do databáze obrázky a asociovat je s produktem Product lastAddedProduct = StorageSetup.GetLastAddedProduct(); if (gallery.lbContainer.HasItems) { foreach (ImageStruct istr in gallery.Images) { Images.AddImage(istr); ImagesTable lastAddedImage = Images.FindLastAddedImage(); Images.AssignImageToProduct(lastAddedProduct, lastAddedImage); } } DialogHelper.ShowInfo("Produkt přidán."); this.Close(); } else { throw new NotImplementedException(); } } catch (InvalidNameException ex) { DialogHelper.ShowWarning(ex.Message); } catch (InvalidQuantityException ex) { DialogHelper.ShowWarning(ex.Message); } catch (InvalidUnitQuantityException ex) { DialogHelper.ShowWarning(ex.Message); } catch (ExistingCodeException ex) { DialogHelper.ShowWarning(ex.Message); } catch (InvalidCodeException ex) { DialogHelper.ShowWarning(ex.Message); } catch (InvalidPriceException ex) { DialogHelper.ShowWarning(ex.Message); } catch (NullDateTimeException ex) { DialogHelper.ShowWarning(ex.Message); } catch { DialogHelper.ShowError("Produkt nebylo možné přidat."); } }