public bool Insert(Shoe newShoe) { try { db.Shoes.InsertOnSubmit(newShoe); db.SubmitChanges(); return(true); } catch { return(false); } }
public Book Insert(Book newBook) { try { db.Books.InsertOnSubmit(newBook); db.SubmitChanges(); return(newBook); } catch { return(null); } }
public ActionResult Edit(int?id, LearningMVC.Models.User userDetails) { TempData["TempData Name"] = "Akhil"; try { var dbContext = new MyDBDataContext(); var user = dbContext.Users.FirstOrDefault(userId => userId.UserId == id); if (user != null) { user.FirstName = userDetails.FirstName; user.LastName = userDetails.LastName; user.Address = userDetails.Address; user.PhoneNo = userDetails.PhoneNo; user.EMail = userDetails.EMail; user.Company = userDetails.Company; user.Designation = userDetails.Designation; dbContext.SubmitChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Add(Task task) { if (String.IsNullOrEmpty(task.name)) ModelState.AddModelError("Name", "Введите свое name"); if (String.IsNullOrEmpty(task.text)) ModelState.AddModelError("Text", "Введите свое text"); if (ModelState.IsValid) { MyDBDataContext db = new MyDBDataContext(); MyTable125 item = new MyTable125 { name = task.name, text = task.text, TaskAdded = DateTime.Now, TaskBegin = task.TaskBegin, TaskEnd = task.TaskEnd, delete = false }; //item.done = !flagDone; db.MyTable125.InsertOnSubmit(item); db.SubmitChanges(); return RedirectPermanent("/Home/Index"); } else // Обнаружена ошибка проверки достоверности return RedirectPermanent("/Home/Index"); return RedirectPermanent("/Home/Index"); //return View(); }
public int DoConfirmRegisMember(Entities.User e) { try { using (MyDBDataContext db = new MyDBDataContext()) { DataLayer.User user = (from u in db.Users where u.Id == e.Id select u).FirstOrDefault(); if (user == null) { return((int)Enums.Errors.NOT_EXIST); } user.Status = e.Status; db.UserInRoles .Where(u => u.UserId == e.Id) .ToList() .ForEach(u => u.State = true); db.SubmitChanges(); } return(e.Id); } catch (Exception ex) { string data = className + " " + ex.Message.ToString(); Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data)); return((int)Enums.Errors.UPDATE_ERROR); } }
static void ModifyItem(int itemId) { ObjCtx = new MyDBDataContext(); Console.WriteLine("Enter new title"); string name = Console.ReadLine(); Console.WriteLine("Enter the modified price"); int pce = Console.Read(); var mResult = from item in ObjCtx.Items where item.ItemCode == itemId select item; foreach (var bk in mResult) { //bk.bookId = bk.bk bk.ItemName = name; bk.Price = pce; } try { ObjCtx.SubmitChanges(); Console.WriteLine("updated..."); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
static void AddItem() { ObjCtx = new MyDBDataContext(); //Console.WriteLine("enter Item code"); //int id = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("enter Item Name"); string name = Console.ReadLine(); Console.WriteLine("enter price"); int pce = Convert.ToInt32(Console.ReadLine()); Item itemObj = new Item(); //itemObj.ItemCode = id; itemObj.ItemName = name; itemObj.Price = pce; ObjCtx.Items.InsertOnSubmit(itemObj); try { ObjCtx.SubmitChanges(); Console.WriteLine("inserted..."); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public bool Insert(Shoe newShoe) { //String strCon = "SERVER=den1.mssql8.gear.host;DATABASE=hungnguyen;USER=hungnguyen;PASSWORD=hungnguyen@571999!"; //SqlConnection con = new SqlConnection(strCon); //con.Open(); //String strCom = "INSERT INTO Shoe VALUES(@Name,@Type,@Size,@Price)"; //SqlCommand com = new SqlCommand(strCom, con); //com.Parameters.Add(new SqlParameter("@Name", newShoe.Name)); //com.Parameters.Add(new SqlParameter("@Type", newShoe.Type)); //com.Parameters.Add(new SqlParameter("@Size", newShoe.Size)); //com.Parameters.Add(new SqlParameter("@Price", newShoe.Price)); //try { return com.ExecuteNonQuery() > 0; } //catch { return false; } try { db.Shoes.InsertOnSubmit(newShoe); db.SubmitChanges(); return(true); } catch { return(false); } }
public ActionResult Hide(int dd, bool flagDelete) { MyDBDataContext db = new MyDBDataContext(); MyTable125 item = db.MyTable125.Single(e => e.Id == dd); item.delete = !flagDelete; db.SubmitChanges(); return RedirectPermanent("/Home/Index"); //return View("Index"); //return View(); }
public ActionResult Create(LearningMVC.Models.User userDetails) { try { Mapper.CreateMap <LearningMVC.Models.User, LearningMVC.User>(); var dbContext = new MyDBDataContext(); var user = Mapper.Map <LearningMVC.Models.User, LearningMVC.User>(userDetails); dbContext.Users.InsertOnSubmit(user); dbContext.SubmitChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(LearningMVC.Models.User userDetails) { try { Mapper.CreateMap<LearningMVC.Models.User, LearningMVC.User>(); var dbContext = new MyDBDataContext(); var user = Mapper.Map<LearningMVC.Models.User, LearningMVC.User>(userDetails); dbContext.Users.InsertOnSubmit(user); dbContext.SubmitChanges(); return RedirectToAction("Index"); } catch { return View(); } }
public int InsertMemberRole(MyDBDataContext db, Entities.UserInRole e) { try { DataLayer.UserInRole u = new DataLayer.UserInRole(); u.RolesId = e.RolesId; u.UserId = e.UserId; u.State = e.State; db.UserInRoles.InsertOnSubmit(u); db.SubmitChanges(); return(u.Id); } catch (Exception ex) { string data = className + " " + ex.Message.ToString(); Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data)); return((int)Enums.Errors.INSERT_ERROR); } }
public ActionResult Delete(int?id, LearningMVC.Models.User userDetails) { try { var dbContext = new MyDBDataContext(); var user = dbContext.Users.FirstOrDefault(userId => userId.UserId == id); if (user != null) { dbContext.Users.DeleteOnSubmit(user); dbContext.SubmitChanges(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult OnInput([Bind(Include = "name, text, TaskBegin, taskEnd")] Task task) { task.TaskAdded = DateTime.Now; //Валидация вводных данных if (ModelState.IsValid) { //Корректные MyDBDataContext db = new MyDBDataContext(); MyTable125 item = new MyTable125 { name = task.name, text = task.text, TaskAdded = DateTime.Now, TaskBegin = task.TaskBegin, TaskEnd = task.TaskEnd, delete = false }; { } //item.done = !flagDone; db.MyTable125.InsertOnSubmit(item); db.SubmitChanges(); ViewBag.Sussed = "Успешно добвлен!"; //return RedirectToAction("Index", "Home"); //return RedirectPermanent("~/Home/Index"); //return RedirectPermanent("~/Add/Add"); return View(); } else { //Некорректные //return RedirectPermanent("~/Home/Index"); return View("Input"); } //return View(); }
static void DeleteItem(int itemid) { ObjCtx = new MyDBDataContext(); var mResult = from item in ObjCtx.Items where item.ItemCode == itemid select item; foreach (var bk in mResult) { ObjCtx.Items.DeleteOnSubmit(bk); } try { ObjCtx.SubmitChanges(); Console.WriteLine("deleted..."); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public int DeleteMultiple(int[] usersDelete) { try { using (MyDBDataContext db = new MyDBDataContext()) { db.Users .Where(u => usersDelete.Contains(u.Id)) .ToList() .ForEach(u => { u.Delete = true; u.DateUpdate = DateTime.Now; }); db.SubmitChanges(); } return(1); } catch (Exception ex) { string data = className + " " + ex.Message.ToString(); Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data)); return((int)Enums.Errors.DELETE_ERROR); } }
public int InsertPersonalInformation(MyDBDataContext db, Entities.User e) { try { DataLayer.User user = new DataLayer.User(); user.DisplayName = e.DisplayName; user.FirstName = e.FirstName; user.LastName = e.LastName; user.Gender = e.Gender; user.DateOfBirth = DateTime.ParseExact(e.DateOfBirth, "dd/MM/yyyy", null); user.UserName = e.UserName; user.Email = e.Email; user.Password = e.Password; user.Status = e.Status; user.Description = e.Description; user.Delete = e.Delete; user.DateCreate = DateTime.Now; user.DateUpdate = DateTime.Now; user.DateLogin = DateTime.Now; user.PlaceId = e.PlaceId; user.Address = e.Address; user.Zipcode = e.Zipcode; user.CompanyLogo = e.CompanyLogo; user.CodeActive = e.CodeActive; user.CompanyName = e.CompanyName; user.Phone = e.Phone; user.Avatar = e.Avatar; user.IsUpdated = false; db.Users.InsertOnSubmit(user); db.SubmitChanges(); return(user.Id); } catch (Exception ex) { string data = className + " " + ex.Message.ToString(); Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data)); return((int)Enums.Errors.INSERT_ERROR); } }
public ActionResult Edit(int? id, LearningMVC.Models.User userDetails) { TempData["TempData Name"] = "Akhil"; try { var dbContext = new MyDBDataContext(); var user = dbContext.Users.FirstOrDefault(userId => userId.UserId == id); if (user != null) { user.FirstName = userDetails.FirstName; user.LastName = userDetails.LastName; user.Address = userDetails.Address; user.PhoneNo = userDetails.PhoneNo; user.EMail = userDetails.EMail; user.Company = userDetails.Company; user.Designation = userDetails.Designation; dbContext.SubmitChanges(); } return RedirectToAction("Index"); } catch { return View(); } }
public void Dispose() { _context.SubmitChanges(); _context.Dispose(); }
public string InsertHero(string x) { string r; try { var str = from a in cntx.Heros where a.Name == x select a; Hero test = str.First(); r = "Hero Already Exist"; } catch { Hero h = new Hero(); h.Name = x; cntx.Heros.InsertOnSubmit(h); cntx.SubmitChanges(); r = "Hero Inserted"; } return(r); }
public ActionResult Delete(int? id, LearningMVC.Models.User userDetails) { try { var dbContext = new MyDBDataContext(); var user = dbContext.Users.FirstOrDefault(userId => userId.UserId == id); if (user != null) { dbContext.Users.DeleteOnSubmit(user); dbContext.SubmitChanges(); } return RedirectToAction("Index"); } catch { return View(); } }