public ActionResult Create(tblTeacher tblTeacher, HttpPostedFileBase FileUpload) { if (ModelState.IsValid) { //Save image in folder string FileName = Path.GetFileName(FileUpload.FileName); string SaveLocation = Server.MapPath("~/Upload/" + FileName); FileUpload.SaveAs(SaveLocation); //save image name in database tblTeacher.teacherPicName = "~/Upload/" + FileName; // byte image Save tblTeacher.teacherPicture = new byte [FileUpload.ContentLength]; ViewBag.TeacherPicture = FileUpload.InputStream.Read(tblTeacher.teacherPicture, 0, FileUpload.ContentLength); db.tblTeachers.Add(tblTeacher); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblTeacher)); }
private static void update(TeacherContext ctx, Teacher teach) { teach.FirstName = "نیکا"; ctx.SaveChanges(); teach.LastName = "After Update"; ctx.SaveChanges(); teach.FirstName = "پریسا"; ctx.SaveChanges(); }
private static void TestChangeTracker(TeacherContext teacherContext) { var person = teacherContext.Teachers.FirstOrDefault(); //teacherContext.Teachers.Add(new // Entities.Teacher //{ // FirstName = "Alireza", // LastName = "Oroumand", //}); person.FirstName = "Ali reza"; teacherContext.SaveChanges(); person.LastName = "Oroumand AfterUpdate"; teacherContext.SaveChanges(); person.FirstName = "Alireza"; teacherContext.SaveChanges(); }
public ActionResult Edit(Teacher teacher) { Teacher newTeacher = db.Teachers.Find(teacher.ID); newTeacher.FirstName = teacher.FirstName; newTeacher.LastName = teacher.LastName; newTeacher.CathedraID = teacher.CathedraID; db.SaveChanges(); return(RedirectToAction("Index")); }
private static void Tracker() { TeacherContext teacherContext = new TeacherContext(); //teacherContext.Teachers.Add(new Entites.Teacher //{ // FirstName = "Omid", // LastName = "Khaleghi" //}); var a = teacherContext.Teachers.FirstOrDefault(); a.LastName = "nouri arejani"; teacherContext.SaveChanges(); a.FirstName = "ALi"; teacherContext.SaveChanges(); System.Console.WriteLine("W"); Console.ReadLine(); }
private static void add(TeacherContext ctx) { ctx.Teacher.Add(new Teacher { FirstName = "نیکا", LastName = "نیکا" }); ctx.Teacher.Add(new Teacher { FirstName = "پرکیا", LastName = "پریکا" }); ctx.SaveChanges(); }
public async Task <IActionResult> RequestRegister(RequestIn request) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } foreach (var item in request.items) { if (item.id_item == null) { return(BadRequest(new { errorText = "Empty item field!" })); } } // TO DO count sum of items double sum = 0; var items = await _context.Items.FromSqlRaw("SELECT id_item, cost, prov_name, name FROM Items").ToListAsync(); foreach (ItemForRequestIn item in request.items) { sum += items.Where(i => i.id_item == item.id_item).First().cost *item.amount; } Requests requests = new Requests(); requests.date = DateTime.Now; requests.sum = sum; requests.id_teacher = get_teacherId_from_TeacherEmail(User.Identity.Name); requests.id_manager = get_managerId_from_TeacherEmail(User.Identity.Name); _context.Requests.Add(requests); _context.SaveChanges(); foreach (ItemForRequestIn ifr in request.items) { await _context.Database.ExecuteSqlInterpolatedAsync($"INSERT INTO Request_items VALUES ({null}, {requests.id_request}, {ifr.id_item}, {ifr.amount} );"); } return(Ok()); }
public int Create(Teacher teacher) { _teacherContext.Teachers.Add(teacher); return(_teacherContext.SaveChanges()); }
public static void Test() { Database.SetInitializer <TestContext>(null); Database.SetInitializer <TeacherContext>(null); using (var context = new TestContext()) { context.Database.Log = Console.WriteLine; var sGuid1 = Guid.NewGuid().ToString(); var sGuid2 = Guid.NewGuid().ToString(); var tGuid1 = Guid.NewGuid().ToString(); var tGuid2 = Guid.NewGuid().ToString(); using (var transaction = context.Database.BeginTransaction()) { try { Student s1 = new Student() { ID = sGuid1, Name = "张萨姆", StudentNumber = 1, IsMale = true }; Student s2 = new Student() { ID = sGuid2, Name = "张市长", StudentNumber = 2, IsMale = false }; Teacher t1 = new Teacher() { ID = tGuid1, Name = "张巨鹿" }; Teacher t2 = new Teacher() { ID = tGuid2, Name = "老黄" }; t1.Students.Add(s1); t1.Students.Add(s2); t2.Students.Add(s1); t2.Students.Add(s2); context.Entry(s1).State = EntityState.Added; context.Entry(s2).State = EntityState.Added; context.Entry(t1).State = EntityState.Added; context.Entry(t2).State = EntityState.Added; TeacherContext thContext = new TeacherContext( context.Database.Connection, contextOwnsConnection: false); thContext.Database.UseTransaction(transaction.UnderlyingTransaction); int c = context.SaveChanges(); Console.WriteLine("SaveChanges影响的行数:{0}", c); //c = thContext.Database.ExecuteSqlCommand(" UPDATE STUDENT SET NAME=:NAME WHERE ID=:ID", new OracleParameter[]{ // new OracleParameter("@NAME","东源"), // new OracleParameter("@ID",sGuid1), //}); //Console.WriteLine("ExecuteSqlCommand影响的行数:{0}", c); t1.Name = "落月"; //thContext.Entry(t1).Property(p => p.Name).IsModified = true; thContext.Entry(t1).State = EntityState.Modified; c = thContext.SaveChanges(); Console.WriteLine("thContext的SaveChanges影响的行数:{0}", c); transaction.Commit(); try { Console.WriteLine("----------------------------学生信息-------------------------------------"); context.Entry(s1).Reload(); var studentLst = context.Students.Local; Console.WriteLine(string.Format("学生的数量:{0}", studentLst.Count)); foreach (var s in studentLst) { Console.WriteLine(string.Format("ID:{0},Name:{1},Sex:{2}", s.ID, s.Name, s.IsMale)); foreach (Teacher tc in s.Teachers) { Console.WriteLine(string.Format("学生对应的老师( -- ID:{0},姓名:{1} -- )", tc.ID, tc.Name)); } } } catch (Exception e) { Console.WriteLine(e.Message); } } catch (Exception e) { Console.WriteLine(e.Message); transaction.Rollback(); } } } }