// PUT api/MyData/5 public IHttpActionResult PutMyData(int id, MyData mydata) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != mydata.Id) { return(BadRequest()); } db.Entry(mydata).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!MyDataExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
// [EnableQuery] public IActionResult Post([FromBody] Product product, CancellationToken token) { _context.Products.Add(product); _context.SaveChanges(); return(Created(product)); }
public ActionResult Create([Bind(Include = "Id,Name")] Category category) { if (ModelState.IsValid) { db.Categories.Add(category); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
public ActionResult Index(Persona p) { if (ModelState.IsValid) { var persona = GetPersona(p.Nombre, p.Apellido); if (p.Id == 0) { ViewBag.Crud = "Registrar"; if (persona != null) { ViewBag.Message = "Ya hay una Persona con los mismos datos"; } else { db.Persona.Add(p); ViewBag.Message = "Se Registró Persona"; } } else { ViewBag.Crud = "Modificar"; if (persona != null) { ViewBag.Message = "Ya hay una Persona con los mismos datos"; } else { db.Entry(p).State = EntityState.Modified; ViewBag.Message = "Se Grabaron los cambios"; } } db.SaveChanges(); ViewBag.Listado = db.Persona.ToList(); return(View("Index", p)); } else { if (p.Id == 0) { ViewBag.Crud = "Registrar"; } else { ViewBag.Crud = "Modificar"; } ViewBag.Message = "Aún no ha terminado de llenar los campos"; ViewBag.Listado = db.Persona.ToList(); return(View("Index", p)); } }
public ActionResult Create([Bind(Include = "Id,Name")] Vendor vendor) { if (ModelState.IsValid) { db.Vendors.Add(vendor); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(vendor)); }
public ActionResult Create([Bind(Include = "Id,Enum1,Enum2,FlagsEnum")] MyData mydata) { if (ModelState.IsValid) { db.MyDatas.Add(mydata); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mydata)); }
public ActionResult Create([Bind(Include = "Dept_Id,Name")] Department department) { if (ModelState.IsValid) { db.Departments.Add(department); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(department)); }
public ActionResult Create([Bind(Include = "Admin_Id,Password")] Admin admin) { if (ModelState.IsValid) { db.Admins.Add(admin); db.SaveChanges(); return RedirectToAction("Index"); } return View(admin); }
public ActionResult Create([Bind(Include = "Id,Email,Password")] Login login) { if (ModelState.IsValid) { db.Logins.Add(login); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(login)); }
public ActionResult Create([Bind(Include = "Id,Name,Description")] Inventory inventory) { if (ModelState.IsValid) { db.Inventories.Add(inventory); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(inventory)); }
public ActionResult Create([Bind(Include = "Fact_Id,Name,Password,Dept_Id")] Faculty faculty) { if (ModelState.IsValid) { db.Faculties.Add(faculty); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Dept_Id = new SelectList(db.Departments, "Dept_Id", "Name", faculty.Dept_Id); return(View(faculty)); }
public ActionResult Create([Bind(Include = "Stud_Id,Name,Password,Dept_Id,Attendance,TotalDays")] Student student) { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Dept_Id = new SelectList(db.Departments, "Dept_Id", "Name", student.Dept_Id); return(View(student)); }
public static int UpdateEntryByProperty <T>(this MyDataContext _db, T entity, string EntityKey) where T : class { DbSet <T> dbSet = _db.Set <T>(); dbSet.Attach(entity); MemberInfo[] members = entity.GetType().GetMembers(); IEnumerable <MemberInfo> properties = members.Where(m => m.MemberType == MemberTypes.Property && m.Name != EntityKey); foreach (MemberInfo mInfo in properties) { object o = entity.GetType().InvokeMember(mInfo.Name, BindingFlags.GetProperty, null, entity, null); if (o != null) { if (o.GetType().IsPrimitive || o.GetType().IsPublic) { try { DbEntityEntry entry = _db.Entry <T>(entity); entry.Property(mInfo.Name).IsModified = true; } catch { } } } } return(_db.SaveChanges()); }
static void Main(string[] args) { using (var context = new MyDataContext()) { var cat = new Category { Name = "Gifts" }; for (var x = 0; x < 10; x++) { Console.WriteLine("Creating 'Product {0}'", x); var prod = new Product { Name = "Product " + x, Price = x * 100, Category = cat // will be created as a child record // in the same command. Scary but powerful. }; context.Products.Add(prod); context.SaveChanges(); } } Console.ReadLine(); }
private void Button_Click(object sender, RoutedEventArgs e) { Personel p = new Personel { Adi = txt1.Text, Soyadi = txt2.Text, TCKN = txt3.Text }; dataContext.Personels.Add(p); dataContext.SaveChanges(); dt1.ItemsSource = dataContext.Personels.ToList(); txt1.Text = ""; txt2.Text = ""; txt3.Text = ""; }
public void Post(Comment comment) { using (var db = new MyDataContext()) { db.Entry(comment).State = comment.CommentId == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public void Get(User newUser) { using (var db = new MyDataContext()) { db.Entry(newUser).State = newUser.UserId == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public ActionResult Create([Bind(Include = "Id,CategoryId,Name,Variety")] Item item, HttpPostedFileBase ItemImage) { if (ModelState.IsValid) { item.Category = db.Categories.Find(item.CategoryId); if (ItemImage != null) { string newFileName = Helpers.Helper.RandomString() + ".jpg"; ItemImage.SaveAs(HttpContext.Server.MapPath("~/Images/") + newFileName); item.ItemImage = newFileName; } db.Items.Add(item); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(item)); }
/// <summary> /// Writes the line. /// </summary> /// <param name="message">The message.</param> public override void WriteLine(String message) { SyncerLog log = new SyncerLog() { Guid = Guid.NewGuid(), Timestamp = DateTime.Now, Message = message }; MyDataContext tempContext = new MyDataContext(); tempContext.SyncerLogs.Add(log); tempContext.SaveChanges(); }
public void Delete(int commentId) { using (var db = new MyDataContext()) { var commentToDelete = db.Comments.Find(commentId); if (commentToDelete != null) { db.Entry(commentToDelete).State = System.Data.Entity.EntityState.Deleted; } db.SaveChanges(); } }
public ActionResult Create([Bind(Include = "Id,ItemId,VendorId")] VendorSupplyItem item) { if (ModelState.IsValid) { item.Item = db.Items.Find(item.ItemId); item.Vendor = db.Vendors.Find(item.VendorId); if (IsExistItemVendor(item.ItemId, item.VendorId, null)) { ModelState.AddModelError("ItemId", "Already exist for Item and Vendor!"); ViewBag.Items = new SelectList(db.Items.ToList().Select( x => new SelectListItem() { Text = x.Name, Value = x.Id.ToString() } ), "Value", "Text"); ViewBag.Vendors = new SelectList(db.Vendors.ToList().Select( x => new SelectListItem() { Text = x.Name, Value = x.Id.ToString() } ), "Value", "Text"); return(View(item)); } db.VendorSupplyItems.Add(item); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(item)); }
public virtual TObject Update(TObject data, int id) { if (data == null) { return(null); } TObject obj = Context.Set <TObject>().Find(id); if (obj != null) { Context.Entry(obj).CurrentValues.SetValues(data); Context.SaveChanges(); } return(obj); }
public void Post(Event @event) { //Add logic to guard against titles being too long //if(@event.Title.Length > 22) //{ // throw new InvalidOperationException("Bad title length"); //} using (var db = new MyDataContext()) { db.Entry(@event).State = @event.EventId == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public CustomersController(MyDataContext context) { _context = context; if (_context.Customers.Count() == 0) { IList <Customer> customers = GetCustomers(); foreach (var customer in customers) { _context.Customers.Add(customer); } _context.SaveChanges(); } }
public ProductsController(MyDataContext context) { _context = context; if (_context.Products.Count() == 0) { IList <Product> products = new List <Product> { new Product { Category = "Goods", Color = Color.Red, CreatedDate = new DateTimeOffset(2001, 4, 15, 16, 24, 8, TimeSpan.FromHours(-8)), UpdatedDate = new DateTimeOffset(2011, 2, 15, 16, 24, 8, TimeSpan.FromHours(-8)), Detail = new ProductDetail { Id = "3", Info = "Zhang" }, }, new Product { Category = "Magazine", Color = Color.Blue, CreatedDate = new DateTimeOffset(2021, 12, 27, 9, 12, 8, TimeSpan.FromHours(-8)), UpdatedDate = null, Detail = new ProductDetail { Id = "4", Info = "Jinchan" }, }, new Product { Category = "Fiction", Color = Color.Green, CreatedDate = new DateTimeOffset(1978, 11, 15, 9, 24, 8, TimeSpan.FromHours(-8)), UpdatedDate = new DateTimeOffset(1987, 2, 25, 5, 1, 8, TimeSpan.FromHours(-8)), Detail = new ProductDetail { Id = "5", Info = "Hollewye" }, }, }; foreach (var product in products) { _context.Products.Add(product); } _context.SaveChanges(); } }
public ProductsController(MyDataContext context) { _context = context; if (_context.Products.Count() == 0) { IList <Product> products = new List <Product> { new Product { TotoId = "1", Category = "Goods", Color = Color.Red, Detail = new ProductDetail { Id = "3", Info = "Zhang" }, }, new Product { TotoId = "2", Category = "Magazine", Color = Color.Blue, Detail = new ProductDetail { Id = "4", Info = "Jinchan" }, }, new Product { TotoId = "3", Category = "Fiction", Color = Color.Green, Detail = new ProductDetail { Id = "5", Info = "Hollewye" }, }, }; foreach (var product in products) { _context.Products.Add(product); } _context.SaveChanges(); } }
public void Create([FromBody] Post post, int?id) { if (ModelState.IsValid) { using (MyDataContext db = new MyDataContext()) { User userReciver = db.User.Find(id); var sessionId = HttpContext.Current.Session.SessionID; User userSender = db.User.First(x => x.SId == sessionId); post.Receiver = userReciver; post.Sender = userSender; userReciver.Posts.Add(post); db.SaveChanges(); } } }
public static int UpdateProjectByProperty <T>(this MyDataContext _db, T entity, string EntityKey) where T : class { DbSet <T> dbSet = _db.Set <T>(); dbSet.Attach(entity); MemberInfo[] members = entity.GetType().GetMembers(); IEnumerable <MemberInfo> properties = members.Where(m => m.MemberType == MemberTypes.Property && m.Name != EntityKey); foreach (MemberInfo mInfo in properties) { object o = entity.GetType().InvokeMember(mInfo.Name, BindingFlags.GetProperty, null, entity, null); if (o != null) { if (o.GetType().IsPrimitive || o.GetType().IsPublic) { try { DbEntityEntry entry = _db.Entry <T>(entity); entry.Property(mInfo.Name).IsModified = true; } catch { } } } else { if (mInfo.Name.ToLower() == "opening_time" || mInfo.Name.ToLower() == "checkin_time" || mInfo.Name.ToLower() == "report_effective_hours" || mInfo.Name.ToLower() == "takelook_effective_days" || mInfo.Name.ToLower() == "remarks_kind" || mInfo.Name.ToLower() == "partner_begin_time" || mInfo.Name.ToLower() == "partner_end_time" || mInfo.Name.ToLower() == "takelook_add_num" || mInfo.Name.ToLower() == "dading_add_num") { try { DbEntityEntry entry = _db.Entry <T>(entity); entry.Property(mInfo.Name).IsModified = true; } catch { } } } } return(_db.SaveChanges()); }
public OrdersController(MyDataContext context) { _context = context; if (_context.Orders.Count() == 0) { IList <Order> orders = new List <Order> { new Order { Title = "Goods", Category = new Category { }, }, new Order { Title = "Magazine", Category = new Category { }, }, new Order { Title = "Fiction", Category = new Category { }, }, }; foreach (var order in orders) { _context.Orders.Add(order); } _context.SaveChanges(); } }
public IActionResult Store(Product product) { _context.Products.Add(product); _context.SaveChanges(); return(Redirect("GetList")); }