public static void Create(PlacePhotoDTO placePhotoDTO)
{
PlacePhoto placePhoto = MapperTransform <PlacePhoto, PlacePhotoDTO> .ToEntity(placePhotoDTO);
Database.PlacePhotos.Create(placePhoto);
Database.Save();
}
public static void Create(PointDTO pointDTO)
{
Point point = MapperTransform <Point, PointDTO> .ToEntity(pointDTO);
Database.Points.Create(point);
Database.Save();
}
public static void Create(UserDTO userDTO)
{
User user = MapperTransform <User, UserDTO> .ToEntity(userDTO);
Database.Users.Create(user);
Database.Save();
}
public static void Create(PrizeDTO prizeDTO)
{
Prize prize = MapperTransform <Prize, PrizeDTO> .ToEntity(prizeDTO);
Database.Prizes.Create(prize);
Database.Save();
}
public static void Create(PlaceDTO placeDTO)
{
Place place = MapperTransform <Place, PlaceDTO> .ToEntity(placeDTO);
Database.Places.Create(place);
Database.Save();
}
public static void Create(ReviewDTO reviewDTO)
{
Review review = MapperTransform <Review, ReviewDTO> .ToEntity(reviewDTO);
Database.Reviews.Create(review);
Database.Save();
}
protected override void Seed(ApplicationDbContext context)
{
using (IUnitOfWork unitOfWork = new EFUnitOfWork())
{
string password = "******";
unitOfWork.UserManager.Create(new ApplicationUser {
Email = "*****@*****.**", UserName = "******"
}, password);
unitOfWork.Roles.Create(new ApplicationRole {
Name = "admin"
});
unitOfWork.Roles.Create(new ApplicationRole {
Name = "client"
});
unitOfWork.Roles.Create(new ApplicationRole {
Name = "manager"
});
unitOfWork.Save();
unitOfWork.UserRoles.Create(new ApplicationUserRoles(unitOfWork.UserManager.Find("*****@*****.**", password), unitOfWork.Roles.Find(x => x.Name.Contains("admin")).ElementAt(0)));
unitOfWork.UserRoles.Create(new ApplicationUserRoles(unitOfWork.UserManager.Find("*****@*****.**", password), unitOfWork.Roles.Find(x => x.Name.Contains("client")).ElementAt(0)));
unitOfWork.UserRoles.Create(new ApplicationUserRoles(unitOfWork.UserManager.Find("*****@*****.**", password), unitOfWork.Roles.Find(x => x.Name.Contains("manager")).ElementAt(0)));
unitOfWork.Products.Create(new Product {
Name = "Product1"
});
unitOfWork.Save();
}
base.Seed(context);
}
public static void Create(UserVerificationDTO userVerificationDTO)
{
UserVerification userVerification = MapperTransform <UserVerification, UserVerificationDTO> .ToEntity(userVerificationDTO);
Database.UserVerifications.Create(userVerification);
Database.Save();
}
public void SetHandlers()
{
CancelButton.Click += (object sender, RoutedEventArgs e) => { Close(); };
WorkButton.Click += (object sender, RoutedEventArgs args) =>
{
LocalChair.ChairName = ChairBox.Text;
var localFaculty = FacultyBox.SelectedItem as Faculty;
LocalChair.Faculty = localFaculty;
LocalChair.FacultyId = localFaculty.FacultyId;
if (Action == ActionType.Create)
{
unitOfWork.Chairs.Create(LocalChair);
unitOfWork.Save();
Close();
}
else if (Action == ActionType.Edit)
{
unitOfWork.Chairs.Update(LocalChair);
unitOfWork.Save();
Close();
}
};
}
public static void Create(StatusDTO statusDTO)
{
Status status = MapperTransform <Status, StatusDTO> .ToEntity(statusDTO);
Database.Statuses.Create(status);
Database.Save();
}
public void SetButtonHandlers()
{
CancelButton.Click += (object sender, RoutedEventArgs e) => { Close(); };
WorkButton.Click += (object sender, RoutedEventArgs e) =>
{
LocalDoctor.FirstName = FirstNameBox.Text;
LocalDoctor.MiddleName = MiddleNameBox.Text;
LocalDoctor.LastName = LastNameBox.Text;
LocalDoctor.Position = PositionBox.Text;
if (Action == ActionType.Edit)
{
unitOfWork.Doctors.Update(LocalDoctor);
unitOfWork.Save();
Close();
}
else if (Action == ActionType.Create)
{
unitOfWork.Doctors.Create(LocalDoctor);
unitOfWork.Save();
Close();
}
};
}
public void TestAddOrUpdate()
{
//add
DateTime dtRegistration = DateTime.Now.Date.AddDays(-2).AddHours(12.50);
User user = new User("Jake", 27, dtRegistration);
userRepo.AddOrUpdate(user);
unitOfwork.Save();
User userInDb = userRepo.FindByName("Jake");
Assert.AreEqual(user.Name, userInDb.Name);
//update
userInDb.Age = 29;
userRepo.AddOrUpdate(userInDb);
//add categories to db
foreach (var item in categories)
{
categoryRepo.AddOrUpdate(item);
}
unitOfwork.Save();
//assign the category to products and add to db
foreach (var item in products)
{
if (item.Name.Contains("Sumsung"))
{
item.Category = categories[1];
}
else
{
item.Category = categories[0];
}
productRepo.AddOrUpdate(item);
}
unitOfwork.Save();
//add products to stores
Store rozetkaStore = stores[0];
rozetkaStore.Products.Add(products[0]);
rozetkaStore.Products.Add(products[2]);
rozetkaStore.Products.Add(products[1]);
Store mobidickStore = stores[1];
mobidickStore.Products.Add(products[0]);
mobidickStore.Products.Add(products[3]);
mobidickStore.Products.Add(products[2]);
//add stores to db
storeRepo.AddOrUpdate(rozetkaStore);
storeRepo.AddOrUpdate(mobidickStore);
unitOfwork.Save();
unitOfwork.Dispose();
}
protected override void Seed(SaleSystem.Web.MVC.Models.ApplicationDbContext context)
{
using (IUnitOfWork unitOfWork = new EFUnitOfWork())
{
string password = "******";
unitOfWork.UserManager.Create(new ApplicationUser {
Email = "*****@*****.**", UserName = "******"
}, password);
ApplicationUser user = unitOfWork.Users.Find(x => x.UserName == "*****@*****.**").ElementAt(0);
user.FirstName = "Artem";
user.SecondName = "Shumski";
unitOfWork.Users.Update(user);
unitOfWork.Roles.Create(new ApplicationRole {
Name = "admin"
});
unitOfWork.Roles.Create(new ApplicationRole {
Name = "client"
});
unitOfWork.Roles.Create(new ApplicationRole {
Name = "manager"
});
unitOfWork.Save();
unitOfWork.UserManager.AddToRole(user.Id, "admin");
unitOfWork.UserManager.AddToRole(user.Id, "client");
unitOfWork.UserManager.AddToRole(user.Id, "manager");
unitOfWork.Products.Create(new Product {
Name = "Product1"
});
unitOfWork.Save();
}
}
public void AddCar([FromBody] Car car)
{
currentUserId = User.Identity.GetUserId();
car.UserId = currentUserId;
unitOfWork.Cars.Create(car);
unitOfWork.Save();
}
protected override void Seed(SalesSystem.Entities.ApplicationDbContext context)
{
using (IUnitOfWork unitOfWork = new EFUnitOfWork())
{
string password = "******";
unitOfWork.UserManager.Create(new SalesSystem.Entities.ApplicationUser("*****@*****.**", "*****@*****.**", "Artem", "Shumski"), password);
unitOfWork.Roles.Create(new SalesSystem.Entities.ApplicationRole {
Name = "admin"
});
unitOfWork.Roles.Create(new SalesSystem.Entities.ApplicationRole {
Name = "client"
});
unitOfWork.Roles.Create(new SalesSystem.Entities.ApplicationRole {
Name = "manager"
});
unitOfWork.Save();
unitOfWork.UserRoles.Create(new SalesSystem.Entities.ApplicationUserRoles(unitOfWork.Users.GetAll().ElementAt(0), unitOfWork.Roles.Find(x => x.Name.Contains("admin")).ElementAt(0)));
unitOfWork.UserRoles.Create(new SalesSystem.Entities.ApplicationUserRoles(unitOfWork.Users.GetAll().ElementAt(0), unitOfWork.Roles.Find(x => x.Name.Contains("client")).ElementAt(0)));
unitOfWork.UserRoles.Create(new SalesSystem.Entities.ApplicationUserRoles(unitOfWork.Users.GetAll().ElementAt(0), unitOfWork.Roles.Find(x => x.Name.Contains("manager")).ElementAt(0)));
unitOfWork.Products.Create(new SalesSystem.Entities.Product {
Name = "Product1"
});
unitOfWork.Save();
}
}
public static void Create(UserPhotoDTO userPhotoDTO)
{
UserPhoto userPhoto = MapperTransform <UserPhoto, UserPhotoDTO> .ToEntity(userPhotoDTO);
Database.UserPhotos.Create(userPhoto);
Database.Save();
}
public ActionResult Create(Product product, HttpPostedFileBase ImageFile = null)
{
if (ImageFile == null)
{
ModelState.AddModelError("", "Пустой файл");
}
if (ImageFile.ContentLength > 1 * 1024 * 1024)
{
ModelState.AddModelError("", "Большой файл");
}
try
{
if (Image.FromStream(ImageFile.InputStream).RawFormat.Equals(ImageFormat.Jpeg) == false)
{
ModelState.AddModelError("", "Не JPEG");
}
}
catch { }
//ModelState.AddModelError("", "Не тот файл");
if (ModelState.IsValid)
{
//добавление фотографии для продукта
string fileName = Path.GetFileNameWithoutExtension(ImageFile.FileName);
//берем расположение файла
string extension = Path.GetExtension(ImageFile.FileName);
//создаю для файла уникальное имя
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
//куда созранять (путь для бд)
product.ImagePath = "~/Content/Images/" + fileName;
//сохранение файла в папку в проекте
fileName = Path.Combine(Server.MapPath("~/Content/Images/"), fileName);
//сохраняю как
ImageFile.SaveAs(fileName);
//byte[] imageData = null;
//// считываем переданный файл в массив байтов
//using (var binaryReader = new BinaryReader(ImageFile.InputStream))
//{
// imageData = binaryReader.ReadBytes(ImageFile.ContentLength);
//}
//// установка массива байтов
//product.Image = imageData;
unit.Products.Create(product);
unit.Save();
//чтобы передать в алерт уведомление о том, что продукт был добавлен успешно
TempData["messageCreate"] = string.Format($"{product.Name} был добавлен!");
return(RedirectToAction("Index", "Administration"));
}
ViewBag.CategoryId = new SelectList(unit.Categories.GetAll(), "CategoryId", "Name", product.CategoryId);
return(View(product));
}
public void SetHandlers()
{
CancelButton.Click += (object sender, RoutedEventArgs e) => { Close(); };
WorkButton.Click += (object sender, RoutedEventArgs args) =>
{
LocalResearcher.LastName = LastNameBox.Text;
LocalResearcher.FirstName = FirstNameBox.Text;
LocalResearcher.MiddleName = MiddleNameBox.Text;
var localChair = ChairBox.SelectedItem as Chair;
LocalResearcher.Chair = localChair;
LocalResearcher.ChairId = localChair.ChairId;
if (Action == ActionType.Create)
{
unitOfWork.Researchers.Create(LocalResearcher);
unitOfWork.Save();
Close();
}
else if (Action == ActionType.Edit)
{
unitOfWork.Researchers.Update(LocalResearcher);
unitOfWork.Save();
Close();
}
};
}
public static void Create(QuestDTO questDTO)
{
Quest quest = MapperTransform <Quest, QuestDTO> .ToEntity(questDTO);
Database.Quests.Create(quest);
Database.Save();
}
public static void Create(UserInQuestDTO userInQuestDTO)
{
UserInQuest userInQuest = MapperTransform <UserInQuest, UserInQuestDTO> .ToEntity(userInQuestDTO);
Database.UserInQuests.Create(userInQuest);
Database.Save();
}
public static void Create(AnswerDTO answerDTO)
{
Answer answer = MapperTransform <Answer, AnswerDTO> .ToEntity(answerDTO);
Database.Answers.Create(answer);
Database.Save();
}
public void TakeMovie(MovieDTO movieDto)
{
Mapper.Initialize(cfg => cfg.CreateMap <MovieDTO, Movie>());
Movie movie = Mapper.Map <MovieDTO, Movie>(movieDto);
_database.Movies.Create(movie);
_database.Save();
}
public void TakeActor(ActorDTO actorDto)
{
Mapper.Initialize(cfg => cfg.CreateMap <ActorDTO, Actor>());
Actor actor = Mapper.Map <ActorDTO, Actor>(actorDto);
_database.Actors.Create(actor);
_database.Save();
}
public void TakeShow(ShowDTO showDto)
{
Mapper.Initialize(cfg => cfg.CreateMap <ShowDTO, Show>());
Show show = Mapper.Map <ShowDTO, Show>(showDto);
_database.Shows.Create(show);
_database.Save();
}
public void SetHandlers()
{
CancelButton.Click += (object sender, RoutedEventArgs e) => { Close(); };
WorkButton.Click += (object sender, RoutedEventArgs args) =>
{
if (TypeBox.SelectedIndex == -1)
{
TypeBorder.BorderBrush = new SolidColorBrush(Colors.Red); //#FFACACAC
}
if (PatientBox.SelectedIndex == -1)
{
PatientBorder.BorderBrush = new SolidColorBrush(Colors.Red); //#FFACACAC
}
if (TypeBox.SelectedIndex == -1 || PatientBox.SelectedIndex == -1)
{
return;
}
LocalExamination.ExaminationType = TypeBox.SelectedItem as ExaminationType;
LocalExamination.ExaminationTypeId = LocalExamination.ExaminationType.Id;
LocalExamination.Patient = PatientBox.SelectedItem as Patient;
LocalExamination.PatientId = LocalExamination.Patient.Id;
if (DoctorBox.SelectedItem != null)
{
LocalExamination.Doctor = DoctorBox.SelectedItem as Doctor;
LocalExamination.DoctorId = LocalExamination.Doctor.Id;
}
LocalExamination.Descripton = DescriptionBox.Text;
LocalExamination.Diagnosis = DiagnosisBox.Text;
LocalExamination.ExaminationDate = DatePicker.SelectedDate ?? DateTime.Now;
if (Action == ActionType.Create)
{
unitOfWork.Examinations.Create(LocalExamination);
unitOfWork.Save();
Close();
}
else if (Action == ActionType.Edit)
{
unitOfWork.Examinations.Update(LocalExamination);
unitOfWork.Save();
Close();
}
};
TypeBox.SelectionChanged += (object sender, SelectionChangedEventArgs args) =>
{
TypeBorder.BorderBrush = new SolidColorBrush(Color.FromArgb(0, 255, 255, 255));
};
PatientBox.SelectionChanged += (object sender, SelectionChangedEventArgs args) =>
{
PatientBorder.BorderBrush = new SolidColorBrush(Color.FromArgb(0, 255, 255, 255));
};
}
public IActionResult CreateProduct(Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Products.Create(product);
db.Save();
return(CreatedAtRoute("DefaultApi", new { id = product.Id }, product));
}
public void AddOrUpdatePurchase(Purchase purchase)
{
var tickets = purchase.Tickets;
foreach (var item in tickets)
{
unitOfWork.Tickets.AddOrUpdate(item);
}
unitOfWork.Purchases.AddOrUpdate(purchase);
unitOfWork.Save();
}
public ActionResult Index(int articleId)
{
Article art = new Article();
art = db.Articles.Get(articleId);
art.Rating++;
db.Articles.Update(art);
db.Save();
ViewBag.Admin = IsAdmin();
return(View(db.Articles.GetAll().ToList()));
}
public IActionResult CreateDelivery(Delivery delivery)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Deliveries.Create(delivery);
db.Save();
return(CreatedAtRoute("DefaultApi", new { id = delivery.Id }, delivery));
}
public ActionResult Create(Task task)
{
if (task == null)
{
return(HttpNotFound());
}
db.Tasks.Create(task);
db.Save();
return(RedirectToAction("Get", "Topic", new { topicId = task.TopicId }));
}
