public bool Insert(ProductionLine productionLine) { _context.ProductionLine.Add(productionLine); _context.SaveChanges(); //_context.Entry(machineType).Reference(name => machineType.Name).Load(); return(true); }
public bool Insert(Operations operations) { _context.Operations.Add(operations); _context.SaveChanges(); return(true); //_context.Entry(operations).Reference(name => machineType.Name).Load(); }
public bootstrap(MasterContext context) { _context = context; if (_context.Operations.Count() == 0) { OperationsMDP op = new OperationsMDP("desc1", "name1", 10, 1); OperationsMDP op2 = new OperationsMDP("desc2", "name2", 150, 2); _context.Operations.Add(op); _context.Operations.Add(op2); _context.SaveChanges(); } if (_context.ManufacturingPlans.Count() == 0) { List <OperationsMDP> lista1 = new List <OperationsMDP>(); List <OperationsMDP> lista2 = new List <OperationsMDP>(); lista1.Add(_context.Operations.Find(1)); lista2.Add(_context.Operations.Find(2)); _context.ManufacturingPlans.Add(new ManufacturingPlan(DateTime.Today, lista1)); _context.ManufacturingPlans.Add(new ManufacturingPlan(DateTime.Today, lista2)); _context.SaveChanges(); } if (_context.Products.Count() == 0) { _context.Products.Add(new Product(new Name("Product1"), _context.ManufacturingPlans.Find(1))); _context.Products.Add(new Product(new Name("Product2"), _context.ManufacturingPlans.Find(2))); _context.SaveChanges(); } }
public bool Insert(MachineType machineType) { _context.MachineType.Add(machineType); _context.SaveChanges(); return(true); //_context.Entry(machineType).Reference(name => machineType.Name).Load(); }
public void Delete(int id) { var item = _context.Masters.First(x => x.Id == id); _context.Masters.Remove(item); _context.SaveChanges(); }
public IActionResult AddCustomer(string Customer_Name) { List <string> errors = new List <string>(); if (Customer_Name != null) { Customer checkForCustomer = _context.Customer.SingleOrDefault(customer => customer.Customer_Name == Customer_Name); if (checkForCustomer == null) { Customer newCutomer = new Customer { Customer_Name = Customer_Name, }; _context.Add(newCutomer); _context.SaveChanges(); return(RedirectToAction("Customers")); } errors.Add("Customer already exists."); } else { errors.Add("You need to enter a customers name."); } TempData["Errors"] = errors; return(RedirectToAction("Customers")); }
public IActionResult CreateWedding(WeddingViewModel model) { if (ModelState.IsValid) { Wedding newWedding = new Wedding { Groom_Name = model.Groom_Name, Bride_Name = model.Bride_Name, Wedding_Date = model.Wedding_Date, user_id = (int)HttpContext.Session.GetInt32("CurrUserId"), created_at = DateTime.Now, updated_at = DateTime.Now }; _context.Wedding.Add(newWedding); _context.SaveChanges(); return(RedirectToAction("weddingPage")); } List <string> errors = ModelState.Select(x => x.Value.Errors) .Where(y => y.Count > 0) .Select(z => z[0].ErrorMessage.ToString()) .ToList(); TempData["error_list"] = errors; return(RedirectToAction("weddingPage")); }
public TEntity Insert(TEntity entity) { //entitatea poate sa fie nula sau poate sa fie formatata gresit dbSet.Add(entity); _context.SaveChanges(); //sys errors //string =! entity return(entity); }
public bool Insert(OperationsMDP op) { if (op != null) { _context.Operations.Add(op); _context.SaveChanges(); } return(true); }
public static void AddPlantsDetails() { using (var db = new MasterContext()) { var plant = new Plants(); { Console.WriteLine("Enter PlantName!!"); plant.PlantName = Console.ReadLine(); Console.WriteLine("Enter PlantLocation!!"); plant.PlantLocation = Console.ReadLine(); Console.WriteLine("Enter CompanyId!!"); plant.CompanyId = Convert.ToInt32(Console.ReadLine()); var check = db.Plants.Where(t => t.PlantName == plant.PlantName); if (check != null) { Console.WriteLine("Plant Name is Existing"); } else { db.Plants.Add(plant); db.SaveChanges(); Console.WriteLine("Plants Information is added Successfully!!"); } } } }
protected void bttnSign_Click(object sender, EventArgs e) { if (Page.IsValid) { try { using (MasterContext context = new MasterContext()) { Hasta yeniKayit = new Hasta(); yeniKayit.Isim = txtBoxName.Text; yeniKayit.Soyisim = txtBoxSurrname.Text; yeniKayit.TckNo = txtBoxTckNo.Text; yeniKayit.Adres = txtBoxAdress.Text; yeniKayit.Telefon = txtBoxPhoneNum.Text; yeniKayit.Mail = txtBoxMail.Text; yeniKayit.Sifre = txtBoxUserPass.Text; context.Hasta.Add(yeniKayit); context.SaveChanges(); } Response.Redirect("Anasayfa.aspx"); } catch { Response.Write("Kayıt başarısız!"); } } }
public static void AddProjectInfo() { using (var db = new MasterContext()) { var project = new ProjectList(); { Console.WriteLine("Enter Project Title"); project.ProjectTitle = Console.ReadLine(); Console.WriteLine("Enter Project Definition"); project.ProjectDefinition = Console.ReadLine(); var check = db.ProjectList.Where(t => t.ProjectTitle == project.ProjectTitle); if (check != null) { Console.WriteLine("This Project Info is Existing!!"); } else { db.ProjectList.Add(project); db.SaveChanges(); Console.WriteLine("Project Information is Successfully added!!"); } } } }
public void chageDate(int artistID, int EventID, DateTime data) { var ArtistTMP = _contx.Artist.Where(e => e.IdArtist == artistID).FirstOrDefault(); if (ArtistTMP == null) { throw new Exc_SthMissing("Artist with this ID is not existing"); } var EventTMP = _contx.Event.Where(e => e.IdEvent == EventID).FirstOrDefault(); if (EventTMP == null) { throw new Exc_SthMissing("Event with this ID is not existing"); } Console.WriteLine(EventTMP.Name + " " + data); if (EventTMP.StartDate >= data && EventTMP.EndDate <= data) { throw new Exc_BadRequest("Date is not fitting the schedule xD"); } var Res = _contx.ArtistEvent.Where(e => e.IdArtist == artistID && e.IdEvent == EventID).FirstOrDefault(); Res.PerformanceDate = data; _contx.SaveChanges(); }
public static void AddToysDetails() { using (var db = new MasterContext()) { var toy = new Toys(); { Console.WriteLine("Enter ToyName!!"); toy.ToyName = Console.ReadLine(); Console.WriteLine("Enter ToyDescription!!"); toy.ToyDescription = Console.ReadLine(); Console.WriteLine("Enter ToyPrice!!"); toy.ToyPrice = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter ToyBrand!!"); toy.ToyBrand = Console.ReadLine(); Console.WriteLine("Enter ToysCategoryId!!"); toy.ToysCategoryId = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter PlantsId!!"); toy.PlantId = Convert.ToInt32(Console.ReadLine()); var check = db.Toys.Where(t => t.ToyName == toy.ToyName); if (check != null) { Console.WriteLine("Toy Name is Existing"); } else { db.Toys.Add(toy); db.SaveChanges(); Console.WriteLine("Toys Information is added Successfully!!"); } } } }
public IActionResult Register(RegistrationViewModel model, User newUser) { List <string> errors = new List <string>(); if (ModelState.IsValid) { List <User> allUsers = _context.User.Where(users => users.Email == model.Email).ToList(); PasswordHasher <User> Hasher = new PasswordHasher <User>(); if (allUsers.Count < 1) { newUser.Password = Hasher.HashPassword(newUser, newUser.Password); _context.User.Add(newUser); _context.SaveChanges(); User currentUser = _context.User.SingleOrDefault(user => user.Email == model.Email); HttpContext.Session.SetInt32("CurrUserId", (int)currentUser.id); return(RedirectToAction("Index", "New")); } else { errors.Add("Email already exists in the Database."); } } else { errors = ModelState.Select(x => x.Value.Errors) .Where(y => y.Count > 0) .Select(z => z[0].ErrorMessage.ToString()) .ToList(); } TempData["error_list"] = errors; return(RedirectToAction("Index")); }
public ActionResult DynamicAddOrEdit(owl_DynamicPage model) { try { if (model.Id == 0) { MasterContext dynamicadd = new MasterContext(); owl_DynamicPage dynamicPages = new owl_DynamicPage() { Name = model.Name, Info = model.Info, }; dynamicadd.DynamicPage.Add(dynamicPages); dynamicadd.SaveChanges(); ViewBag.message = "Dynamic Sayfa Eklendi"; ModelState.Clear(); return(Redirect("/Dynamic/DynamicList")); } else { MasterContext synamicadd = new MasterContext(); synamicadd.Entry(model).State = System.Data.Entity.EntityState.Modified; synamicadd.SaveChanges(); return(Redirect("/Dynamic/DynamicList")); } } catch (Exception) { throw; } }
public static void AddCompanyDetails() { using (var db = new MasterContext()) { var company = new Companies(); { Console.WriteLine("Enter CompanyName!!"); company.CompanyName = Console.ReadLine(); Console.WriteLine("Enter CompanyLocation!!"); company.CompanyLocation = Console.ReadLine(); Console.WriteLine("Enter CompanyEmailId!!"); company.CompanyEmailId = Console.ReadLine(); var check = db.Companies.Where(t => t.CompanyName == company.CompanyName); if (check != null) { Console.WriteLine("Company Name is Existing"); } else { db.Companies.Add(company); db.SaveChanges(); Console.WriteLine("Company Information is added Successfully!!"); } } } }
protected void bttnSign_Click(object sender, EventArgs e) { if (Page.IsValid) { try { using (MasterContext context = new MasterContext()) { Models.EFCore.Hekim yeniKayit = new Models.EFCore.Hekim(); yeniKayit.Isim = txtBoxName.Text; yeniKayit.Soyisim = txtBoxSurrname.Text; yeniKayit.TckNo = txtBoxTckNo.Text; yeniKayit.Adres = txtBoxAdress.Text; yeniKayit.Telefon = txtBoxPhoneNum.Text; yeniKayit.Mail = txtBoxMail.Text; yeniKayit.Sifre = txtBoxUserPass.Text; yeniKayit.PolikinlikId = Convert.ToInt32(polikinlikDDL.SelectedValue); context.Hekim.Add(yeniKayit); context.SaveChanges(); } Response.Redirect("Goruntule.aspx"); } catch { Response.Write("Kayıt başarısız!"); } } }
public void DeleteCollege(int id) { AddToKeylessTable.DeleteFromTable_Departments(id); _context.Colleges.Remove(_context.Colleges.SingleOrDefault(c => c.IdCollege == id)); _context.SaveChanges(); }
public void DeleteClient(Punct4 punct) { using (var context = new MasterContext()) { context.Entry(punct).State = EntityState.Deleted; context.SaveChanges(); } }
public void Update(Punct4 punct) { using (var context = new MasterContext()) { context.Entry(punct).State = EntityState.Modified; context.SaveChanges(); } }
public void AddPunct4(Punct4 punct) { using (var context = new MasterContext()) { context.Set <Punct4>().Add(punct); context.SaveChanges(); } }
public void AddClient(Client client) { using (var context = new MasterContext()) { context.Set <Client>().Add(client); context.SaveChanges(); } }
public void AddProduct(Product product) { using (var context = new MasterContext()) { context.Set <Product>().Add(product); context.SaveChanges(); } }
public IActionResult Update(UserModel model) { using (MasterContext context = new MasterContext()) { context.UserModels.Update(model); context.SaveChanges(); } return(RedirectToAction("UserDetails")); }
public IActionResult JobsApplied(Models.JobsApplied model) { var jerbId = 0; //Add New Jerb to Database if it doesnt exist var newJerbQuery = _db.JobsApplied.FirstOrDefault(x => x.Company == model.Company && x.Position == model.Position); if (newJerbQuery != null) { jerbId = newJerbQuery.Id; } else { var addNewJerb = new Models.JobsApplied { Company = model.Company, DateApplied = model.DateApplied, Interview = model.Interview, Position = model.Position }; _db.JobsApplied.Add(addNewJerb); _db.SaveChanges(); } var userJobQuery = _db.UserJobs.FirstOrDefault(o => o.Email == _userManager.GetUserName(User) && o.JobId == jerbId); if (userJobQuery != null) { return(View()); } var addUserJerb = new UserJobs { Email = _userManager.GetUserName(User), JobId = jerbId }; _db.UserJobs.Add(addUserJerb); _db.SaveChanges(); return(View()); }
public ActionResult NewsDelete(int id = 0) { MasterContext dbContext = new MasterContext(); var DeleteVal = dbContext.News.Where(q => q.Id == id).FirstOrDefault(); dbContext.News.Remove(DeleteVal); dbContext.SaveChanges(); return(Redirect("/Media/NewsList")); }
//Kullanıcı Tabolusunda Kullanıcıyı Silen Methot public IActionResult Delete(int id) { using (MasterContext context = new MasterContext()) { context.UserModels.Remove(context.UserModels.Find(id)); context.SaveChanges(); return(RedirectToAction("UserDetails")); } }
public IActionResult RegisterUser(RegisterViewModel model) { model.Password = Md5Helper.Instance.GetMd5Hash(model.Password); using (MasterContext context = new MasterContext()) { context.UserModels.Add(model); context.SaveChanges(); } return(RedirectToAction("Login")); }
public ActionResult Product_Group_Delete(int id = 0) { MasterContext dbContext = new MasterContext(); var DeleteVal = dbContext.Product_Gruop.Where(q => q.Id == id).FirstOrDefault(); dbContext.Product_Gruop.Remove(DeleteVal); dbContext.SaveChanges(); return(Redirect("/Product/Product_Group_List")); }