public ActionResult Add(int photoId)
{
string cartId;
if (HttpContext.Request.Cookies.AllKeys.Length > 0 &&
HttpContext.Request.Cookies.AllKeys.Contains("CartId"))
{
cartId = HttpContext.Request.Cookies["CartId"].Value;
}
else
{
cartId = Guid.NewGuid().ToString();
HttpCookie c = new HttpCookie("CartId", cartId);
HttpContext.Response.Cookies.Add(c);
}
var b = db.ShoppingCarts.Where(c => c.CartId.CompareTo(cartId) == 0 && c.PhotoId == photoId);
if (!b.Any())
{
var item = new CartItem
{
CartId = cartId,
PhotoId = photoId,
};
db.ShoppingCarts.Add(item);
}
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public ActionResult Create([Bind(Include = "Id,Name,Price,CategoryId")] Photo photo)
{
if (ModelState.IsValid)
{
db.Photos.Add(photo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(photo));
}
public async Task <IActionResult> CreateImageAsync(Photo photo)
{
if (ModelState.IsValid)
{
photo.CreatedDate = DateTime.Today;
if (photo.PhotoAvatar != null && photo.PhotoAvatar.Length > 0)
{
photo.ImageMimeType = photo.PhotoAvatar.ContentType;
photo.ImageName = Path.GetFileName(photo.PhotoAvatar.FileName);
using (var memoryStream = new MemoryStream())
{
photo.PhotoAvatar.CopyTo(memoryStream);
photo.PhotoFile = memoryStream.ToArray();
}
await UploadAsync(photo.PhotoAvatar);
_dbContext.Add(photo);
_dbContext.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(View(photo));
}
return(View(photo));
}
public ActionResult Crear(Photo p)
{
PhotoContext c = new PhotoContext();
c.Photos.Add(p);
c.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult CreatePhoto(Photo photo, HttpPostedFileBase uploadImage)
{
if (ModelState.IsValid && uploadImage != null)
{
byte[] imageData = null;
using (var binaryReader = new BinaryReader(uploadImage.InputStream))
{
imageData = binaryReader.ReadBytes(uploadImage.ContentLength);
}
photo.PhotoSource = imageData;
db.Photos.Add(photo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(photo));
}
public void SaveUserPhoto(Puzzle.Core.Model.Photo photo)
{
Photo dbPhoto = new Photo()
{
UserId = photo.UserId,
StorageId = "1234",
CreateDate = DateTime.Now
};
photoContext.Add(dbPhoto);
photoContext.SaveChanges();
}
public ActionResult Create([Bind(Include = "Id,Name,LastName,TotalPrice,Date")] Order orderR)
{
if (ModelState.IsValid)
{
string cartId;
if (HttpContext.Request.Cookies.AllKeys.Length > 0 &&
HttpContext.Request.Cookies.AllKeys.First(c => c.Contains("CartId")) != null)
{
cartId = HttpContext.Request.Cookies["CartId"].Value;
var items = db.ShoppingCarts.Where(c => c.CartId.CompareTo(cartId) == 0);
List <Item> goods = new List <Item>();
foreach (var i in items)
{
var p = db.Photos.Find(i.PhotoId);
if (p == null)
{
continue;
}
var tm = new Item()
{
PhotoId = i.PhotoId, ThePhoto = p
};
goods.Add(tm);
}
orderR.Items = goods;
db.Orders.Add(orderR);
var carts = db.ShoppingCarts.Where(x => x.CartId == cartId);
db.ShoppingCarts.RemoveRange(carts);
db.SaveChanges();
HttpContext.Request.Cookies.Remove("CartId");
}
return(RedirectToAction("Index", "Home"));
}
return(View());
}
public void AddPhoto(PhotoViewModel viewmodel)
{
//vm -> m
byte[] picturedata = new byte[viewmodel.PhotoToUpload.Length];
using (var stream = viewmodel.PhotoToUpload.OpenReadStream())
{
stream.Read(picturedata, 0, (int)viewmodel.PhotoToUpload.Length);
}
PhotoModel model = new PhotoModel()
{
PhotoName = viewmodel.PhotoName,
PhotoData = picturedata,
ContentType = viewmodel.PhotoToUpload.ContentType
};
adatbazis.Photos.Add(model);
adatbazis.SaveChanges();
}
public void Create(Comment item)
{
db.Comments.Add(item);
db.SaveChanges();
}
public void Update(Album item)
{
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
public static void Initialize(PhotoContext context)
{
context.Database.EnsureCreated();
// If DB contains already labels ==> nothing need to be done
if (context.Labels.Any())
{
return;
}
// Initialize labels
var labels = new Label[]
{
new Label {
Name = "Daily", Color = "red"
},
new Label {
Name = "Travel", Color = "blue"
},
new Label {
Name = "Pet", Color = "green"
},
new Label {
Name = "Foods", Color = "orange"
},
new Label {
Name = "Nature", Color = "cyan"
}
};
// Add labels into DB
foreach (var label in labels)
{
context.Labels.Add(label);
}
context.SaveChanges();
// Initialize users
var users = new User[]
{
new User {
Username = "******", Password = "******", Role = Role.Admin
},
new User {
Username = "******", Password = "******", Role = Role.Friend
},
new User {
Username = "******", Password = "******", Role = Role.Admin
},
new User {
Username = "******", Password = "******", Role = Role.Visitor
}
};
// Add users into DB
foreach (var user in users)
{
context.Users.Add(user);
}
context.SaveChanges();
}
public void Update(ClientProfile item)
{
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
public static void Seed(PhotoContext db)
{
Photographer photographer = new Photographer()
{
Username = "******",
Email = "*****@*****.**",
Password = "******",
BirthDate = new DateTime(1990, 10, 02),
RegisteredDate = new DateTime(2017, 10, 10)
};
Photographer photographerTwo = new Photographer()
{
Username = "******",
Email = "*****@*****.**",
Password = "******",
BirthDate = new DateTime(1989, 09, 02),
RegisteredDate = new DateTime(2016, 10, 10)
};
Photographer photographerThree = new Photographer()
{
Username = "******",
Email = "*****@*****.**",
Password = "******",
BirthDate = new DateTime(1977, 09, 02),
RegisteredDate = new DateTime(2016, 01, 10)
};
Album album = new Album()
{
BackgroundColor = "Black",
IsPublic = true
};
Album albumTwo = new Album()
{
BackgroundColor = "White",
IsPublic = false
};
PhotographerAlbum photographerAlbum = new PhotographerAlbum()
{
Album = album,
Photographer = photographer
};
PhotographerAlbum photographerAlbumTwo = new PhotographerAlbum()
{
Album = album,
Photographer = photographerTwo
};
PhotographerAlbum photographerAlbumThree = new PhotographerAlbum()
{
Album = albumTwo,
Photographer = photographerTwo
};
PhotographerAlbum photographerAlbumFour = new PhotographerAlbum()
{
Album = albumTwo,
Photographer = photographerThree
};
Picture picture = new Picture()
{
Caption = "Nature",
Path = @"C:\Users\Admin\Desktop\Pictures",
Title = "SummerView"
};
Picture pictureOne = new Picture()
{
Caption = "Animals",
Path = @"C:\Users\Admin\Desktop\Pictures",
Title = "Zoo"
};
Picture pictureTwo = new Picture()
{
Caption = "Forest",
Path = @"C:\Users\Admin\Desktop\Pictures",
Title = "Tree"
};
db.PictureAlbums.Add(new PictureAlbum()
{
Album = album,
Picture = picture
});
db.PictureAlbums.Add(new PictureAlbum()
{
Album = album,
Picture = pictureOne
});
db.PictureAlbums.Add(new PictureAlbum()
{
Album = albumTwo,
Picture = pictureTwo
});
db.SaveChanges();
}
public void Save()
{
_dbContext.SaveChanges();
}
static void Main(string[] args)
{
//Problema 1
using (var context = new ModelSelfReferences())
{
SelfReference selfReference = new SelfReference()
{
Name = "TRK"
};
context.SelfReferences.Add(selfReference);
context.SaveChanges();
var items = context.SelfReferences;
foreach (var x in items)
{
Console.WriteLine(x.Name);
}
}
//Problema 2
using (var context = new ProductContext())
{
var product = new Product
{
SKU = 150,
Description = "Expandable Hydration Pack",
Price = 19.97M,
ImageURL = "/pack147.jpg"
};
context.Products.Add(product);
product = new Product
{
SKU = 181,
Description = "Rugged Ranger Duffel Bag",
Price = 39.97M,
ImageURL = "/pack178.jpg"
};
context.Products.Add(product);
product = new Product
{
SKU = 189,
Description = "Range Field Pack",
Price = 98.97M,
ImageURL = "/noimage.jp"
};
context.Products.Add(product);
product = new Product
{
SKU = 205,
Description = "Small Deployment Back Pack",
Price = 29.97M,
ImageURL = "/pack202.jpg"
};
context.Products.Add(product);
context.SaveChanges();
}
using (var context = new ProductContext())
{
foreach (var p in context.Products)
{
Console.WriteLine("{0} {1} {2} {3}", p.SKU, p.Description,
p.Price.ToString("C"), p.ImageURL);
}
}
//Problema 3
byte[] thumbBits = new byte[100];
byte[] fullBits = new byte[2000];
using (var context = new PhotoContext())
{
var photo = new Photograph
{
Title = "No more corona beer",
ThumbnailBits = thumbBits
};
var fullImage = new PhotographFullImage
{
HighResolutionBits = fullBits
};
photo.PhotographFullImage = fullImage;
context.Photographs.Add(photo);
context.SaveChanges();
}
using (var context = new PhotoContext())
{
foreach (var photo in context.Photographs)
{
Console.WriteLine("Photo: {0}, ThumbnailSize {1} bytes",
photo.Title, photo.ThumbnailBits.Length);
// explicitly load the "expensive" entity,
context.Entry(photo)
.Reference(p => p.PhotographFullImage).Load();
Console.WriteLine("Full Image Size: {0} bytes",
photo.PhotographFullImage.HighResolutionBits.Length);
}
}
//Problema 4
using (var context = new BusinessContext())
{
var business = new Business
{
Name = "Corner Dry Cleaning",
LicenseNumber = "100x1"
};
context.Businesses.Add(business);
var retail = new Retail
{
Name = "Shop and Save",
LicenseNumber = "200C",
Address = "101 Main",
City = "Anytown",
State = "TX",
ZIPCode = "76106"
};
context.Businesses.Add(retail);
var web = new eCommerce
{
Name = "BuyNow.com",
LicenseNumber = "300AB",
URL = "www.buynow.com"
};
context.Businesses.Add(web);
context.SaveChanges();
}
using (var context = new BusinessContext())
{
Console.WriteLine("\n--- All Businesses ---");
foreach (var b in context.Businesses)
{
Console.WriteLine("{0} (#{1})", b.Name, b.LicenseNumber);
}
Console.WriteLine("\n--- Retail Businesses ---");
foreach (var r in context.Businesses.OfType <Retail>())
{
Console.WriteLine("{0} (#{1})", r.Name, r.LicenseNumber);
Console.WriteLine("{0}", r.Address);
Console.WriteLine("{0}, {1} {2}", r.City, r.State, r.ZIPCode);
}
Console.WriteLine("\n--- eCommerce Businesses ---");
foreach (var e in context.Businesses.OfType <eCommerce>())
{
Console.WriteLine("{0} (#{1})", e.Name, e.LicenseNumber);
Console.WriteLine("Online address is: {0}", e.URL);
}
}
//Problema 5
using (var context = new EmployeeContext())
{
var fte = new FullTimeEmployee
{
FirstName = "Jane",
LastName =
"Doe",
Salary = 71500M
};
context.Employees.Add(fte);
fte = new FullTimeEmployee
{
FirstName = "John",
LastName = "Smith",
Salary = 62500M
};
context.Employees.Add(fte);
var hourly = new HourlyEmployee
{
FirstName = "Tom",
LastName =
"Jones",
Wage = 8.75M
};
context.Employees.Add(hourly);
context.SaveChanges();
}
using (var context = new EmployeeContext())
{
Console.WriteLine("--- All Employees ---");
foreach (var emp in context.Employees)
{
bool fullTime = emp is HourlyEmployee ? false : true;
Console.WriteLine("{0} {1} ({2})", emp.FirstName, emp.LastName,
fullTime ? "Full Time" : "Hourly");
}
Console.WriteLine("--- Full Time ---");
foreach (var fte in context.Employees.OfType <FullTimeEmployee>())
{
Console.WriteLine("{0} {1}", fte.FirstName, fte.LastName);
}
Console.WriteLine("--- Hourly ---");
foreach (var hourly in context.Employees.OfType <HourlyEmployee>())
{
Console.WriteLine("{0} {1}", hourly.FirstName,
hourly.LastName);
}
}
}
public JsonResult AddPhoto(string shortName, HttpPostedFileBase photo)
{
try
{
var b = new Bitmap(Image.FromStream(photo.InputStream));
var img = new Image <Rgb, byte>(b);
var gray = img.Convert <Gray, Byte>();
FaceClassifier =
new CascadeClassifier(Server.MapPath("~/App_Data/") + "haarcascade_frontalface_default.xml");
var faces = FaceClassifier.DetectMultiScale(gray, 1.1, 2, Size.Empty, new Size(b.Width, b.Height));
b = CropImage(b, faces.First());
b = new Bitmap(b, new Size(FaceLenght, FaceLenght));
var s = new MemoryStream();
b.Save(s, ImageFormat.Bmp);
var p = new Photo()
{
Face = new Picture()
{
Image = s.ToArray()
}
};
var owner = PhotoContext.People.FirstOrDefault(x => x.ShortName == shortName);
if (owner == null)
{
int i = PhotoContext.People.Max(x => x.CommonPhotoNumber) + 1;
owner = new Person()
{
ShortName = shortName, CommonPhotoNumber = i
};
PhotoContext.People.Add(owner);
PhotoContext.SaveChanges();
p.IsTheBest = true;
}
p.OwnerId = owner.Id;
owner.Faces.Add(p);
PhotoContext.Photos.Add(p);
PhotoContext.Pictures.Add(p.Face);
PhotoContext.SaveChanges();
if (PhotoContext.Photos.Count(x => true) > 2)
{
Update(p);
}
else
{
Train();
}
owner = PhotoContext.People.First(x => x.ShortName == shortName);
var Id = PhotoContext.Photos.Where(x => x.OwnerId == owner.Id).Max(x => x.Id);
return(Json(Id));
}
catch (Exception e)
{
return(Json("Лицо не было найдено"));
}
}