public string InsertSingleCRUDData(SingleCRUD singleCRUDData) { try { SingleCRUD singleCRUD = (from singleData in _db.SingleCRUD where singleData.Id == singleCRUDData.Id select singleData).FirstOrDefault(); //搜尋出重複資料,新增失敗 if (singleCRUD != null) { return("新增到重複SingleCRUD資料,新增失敗"); } singleCRUDData.Upuser = "******"; singleCRUDData.Updatetime = DateTime.Now; singleCRUDData.Cruser = "******"; singleCRUDData.Crdatetime = DateTime.Now; _db.SingleCRUD.Add(singleCRUDData); _db.SaveChanges(); return("true"); } catch (Exception ex) { return("false"); } }
public string InsertColumnCRUDData(ColumnCRUD columnCRUDData) { try { Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.SYS_FunctionStart, LogManagement.SystemName.基本作業, "開始新增一筆ColumnCRUD資料", columnCRUDData, null); ColumnCRUD columnCRUD = (from column in _db.ColumnCRUD where column.Id == columnCRUDData.Id select column).FirstOrDefault(); //搜尋出重複資料,新增失敗 if (columnCRUD != null) { Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "新增到重複PKey的ColumnCRUD資料,取消新增動作", columnCRUDData.Id, null); return("新增到重複ColumnCRUD資料,新增失敗"); } columnCRUDData.Upuser = "******"; columnCRUDData.Updatetime = DateTime.Now; columnCRUDData.Cruser = "******"; columnCRUDData.Crdatetime = DateTime.Now; _db.ColumnCRUD.Add(columnCRUDData); _db.SaveChanges(); Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Error, LogManagement.LogAction.SYS_FunctionEnd, LogManagement.SystemName.基本作業, "新增一筆ColumnCRUD資料結束", columnCRUDData.Id, null); return("true"); } catch (Exception ex) { Log.LogInfoWriter(userName, LogManagement.LogType.AP, LogManagement.EventLevel.Info, LogManagement.LogAction.Error_FunctionError, LogManagement.SystemName.基本作業, "新增一筆ColumnCRUD資料,發生錯誤", columnCRUDData, ex); return("false"); } }
public int AddEmployee(Employee model) { using (var context = new TestDBEntities()) { if (model.Address != null) { Address objadd = new Address() { Details = model.Address.Details, Country = model.Address.Country, State = model.Address.State }; context.Addresses.Add(objadd); context.SaveChanges(); model.AddressId = objadd.Id; } Employee emp = new Employee() { FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Code = model.Code, AddressId = model.AddressId //AddressId=_add.Id }; context.Employees.Add(emp); context.SaveChanges(); return(emp.Id); } }
public ActionResult UserSelect() { var model = db.kullanici.Include(m => m.Sehirler).ToList(); db.SaveChanges(); return(View(model)); }
public string InsertColumnCRUDData(ColumnCRUD columnCRUDData) { try { ColumnCRUD columnCRUD = (from column in _db.ColumnCRUD where column.Id == columnCRUDData.Id select column).FirstOrDefault(); //搜尋出重複資料,新增失敗 if (columnCRUD != null) { return("新增到重複ColumnCRUD資料,新增失敗"); } columnCRUDData.Upuser = "******"; columnCRUDData.Updatetime = DateTime.Now; columnCRUDData.Cruser = "******"; columnCRUDData.Crdatetime = DateTime.Now; _db.ColumnCRUD.Add(columnCRUDData); _db.SaveChanges(); return("true"); } catch (Exception ex) { return("false"); } }
public ActionResult Save(Contact objContact) { objCont.Name = objContact.Name; objCont.Address = objContact.Address; objCont.Contact_Number = objContact.Contact_Number; db.Contacts.Add(objCont); db.SaveChanges(); objCont.contactList = db.Contacts.ToList(); return(View("Index", objCont.contactList)); }
public ActionResult AddUser(UsersModel obj) { contextobj.Users.Add(new User() { Name = obj.UserName, Age = obj.Age }); contextobj.SaveChanges(); return(View("AddUser", obj)); }
public ActionResult Create([Bind(Include = "ID,CampaignName,Date,Clicks,Conversions,Impressions,AffiliateName")] DevTest devTest) { if (ModelState.IsValid) { db.DevTests.Add(devTest); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(devTest)); }
public ActionResult Create([Bind(Include = "ITEM_ID,ITEM_DESRIPTION,CATEGORY_ID,isActive")] ITEMS iTEMS) { if (ModelState.IsValid) { db.ITEMS.Add(iTEMS); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(iTEMS)); }
public ActionResult Create([Bind(Include = "Department_Code,Part_Code,Module_Code,Module_Title,Active")] timetable_module timetable_module) { if (ModelState.IsValid) { db.timetable_module.Add(timetable_module); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(timetable_module)); }
public ActionResult Create(logininfo logininfo) { if (ModelState.IsValid) { db.logininfoes.Add(logininfo); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(logininfo)); }
public ActionResult Create([Bind(Include = "SUPPLIER_ID,SUPPLIERS_NAME,ADDRESS,PHONE_NUMBER,isActive")] SUPPLIERS sUPPLIERS) { if (ModelState.IsValid) { db.SUPPLIERS.Add(sUPPLIERS); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sUPPLIERS)); }
public ActionResult Create(Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Create([Bind(Include = "Park_ID,Building_ID,Room_ID,Capacity,Type_ID")] timetable_room timetable_room) { if (ModelState.IsValid) { db.timetable_room.Add(timetable_room); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(timetable_room)); }
public ActionResult Create(labtask labtask) { if (ModelState.IsValid) { db.labtasks.Add(labtask); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(labtask)); }
public ActionResult Create([Bind(Include = "MemberID,Password,UserName,Email,Age,CellPhone,Blog,CreateDate")] Members members) { if (ModelState.IsValid) { db.Members.Add(members); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(members)); }
public ActionResult Create([Bind(Include = "EmpID,Name,City,MobileNo,birthdate,Email")] tblEmp tblEmp) { if (ModelState.IsValid) { db.tblEmps.Add(tblEmp); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblEmp)); }
public ActionResult Create([Bind(Include = "Facility_ID,Facility_Name")] timetable_facility timetable_facility) { if (ModelState.IsValid) { db.timetable_facility.Add(timetable_facility); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(timetable_facility)); }
public Product Add(Product item) { if (item == null) { throw new ArgumentNullException("item"); } // TO DO : Code to save record into database db.Products.Add(item); db.SaveChanges(); return(item); }
// POST: api/Emp public void Post([FromBody] EmployeeCustomClass emp) { Console.WriteLine(emp); tbDepartment dep = empDb.tbDepartments.FirstOrDefault(e => e.d_name.Equals(emp.DeptName)); tbEmployee newEmp = new tbEmployee(); newEmp.e_name = emp.EmpName; newEmp.tbDepartment = dep; //ef empDb.tbEmployees.Add(newEmp); empDb.SaveChanges(); }
public int Delete(int id) { var modelToDelete = _db.tblTests.Find(id); var practiceModel = new tblTest(); if (modelToDelete != null) { practiceModel = _db.tblTests.Remove(modelToDelete); } _db.SaveChanges(); return(practiceModel.Id); }
public ActionResult Create([Bind(Include = "MOVE_ORDER_ID,MOVE_ORDER_NUMBER,ITEM_ID,PRICE,QUANTITY,STORE_ID,STOCK_ID")] MOVE_ORDERS mOVE_ORDERS) { if (ModelState.IsValid) { db.MOVE_ORDERS.Add(mOVE_ORDERS); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ITEM_ID = new SelectList(db.ITEMS, "ITEM_ID", "ITEM_DESRIPTION", mOVE_ORDERS.ITEM_ID); ViewBag.STOCK_ID = new SelectList(db.STOCKS, "STOCK_ID", "ADDRESS", mOVE_ORDERS.STOCK_ID); ViewBag.STORE_ID = new SelectList(db.STORE, "STORE_ID", "STORE_NAME", mOVE_ORDERS.STORE_ID); return(View(mOVE_ORDERS)); }
public ActionResult Create([Bind(Include = "PURCHASE_ID,PURCHASE_NUMBER,ITEM_ID,PRICE,QUANTITY,PURCHASE_DATE,STOCK_ID,SUPPLIER_ID")] ITEMS_PURCHASE iTEMS_PURCHASE) { if (ModelState.IsValid) { db.ITEMS_PURCHASE.Add(iTEMS_PURCHASE); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ITEM_ID = new SelectList(db.ITEMS, "ITEM_ID", "ITEM_DESRIPTION", iTEMS_PURCHASE.ITEM_ID); ViewBag.STOCK_ID = new SelectList(db.STOCKS, "STOCK_ID", "ADDRESS", iTEMS_PURCHASE.STOCK_ID); ViewBag.SUPPLIER_ID = new SelectList(db.SUPPLIERS, "SUPPLIER_ID", "SUPPLIERS_NAME", iTEMS_PURCHASE.SUPPLIER_ID); return(View(iTEMS_PURCHASE)); }
public ActionResult Create(EMPLOYEE employee) { if (ModelState.IsValid) { db.EMPLOYEEs.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); MessageBox.Show("processed correctly"); } return(View(employee)); MessageBox.Show("processed correctly"); }
public ActionResult AddStudent(Student student) { // Save _db.People.Add(new People { Name = student.Name, LastName = student.LastName, BirthDate = student.BirthDate, City = student.City, Email = student.Email }); _db.SaveChanges(); return(RedirectToAction("Index")); }
public void DelStudentFromClass() { Console.WriteLine("Исключение ученика из класса"); Console.WriteLine("Введите id ученика: "); int idStudent = InsertNumber(); Console.WriteLine("Введите id класса: "); int idClass = InsertNumber(); if (IsHaveStudents(idStudent) && IsHaveClass(idClass)) { if (IsHaveStudentInClass(idStudent, idClass)) { using (TestDBEntities context = new TestDBEntities()) { Students selectStudent = context.Students .Where(s => s.StudentsId == idStudent && s.IsDelete == false) .FirstOrDefault(); selectStudent.ClassId = null; context.SaveChanges(); } Console.WriteLine("Ученик исключен из класса"); } } else { Console.WriteLine("Не существует указанного ученика или класса."); } }
public JsonResult SaveCustomerData(Customer customer) { bool status = false; string message = ""; if (ModelState.IsValid) { using (TestDBEntities dc = new TestDBEntities()) { var query = dc.Customers.Where(a => a.Id == customer.Id).FirstOrDefault(); if (query == null) { customer.CreateDate = DateTime.Now; dc.Customers.Add(customer); } else { query.Name = customer.Name; query.Email = customer.Email; query.Country = customer.Country; query.ZipCode = customer.ZipCode; } dc.SaveChanges(); status = true; message = "Save Complete"; } } else { message = "Failed! Please try again"; } return(new JsonResult { Data = new { status = status, message = message } }); }
public JsonResult DeleteCustomer(Customer customer) { bool status = false; string message = ""; if (ModelState.IsValid) { using (TestDBEntities dc = new TestDBEntities()) { var query = dc.Customers.Where(a => a.Id == customer.Id).FirstOrDefault(); if (query != null) { dc.Customers.Remove(query); } dc.SaveChanges(); status = true; message = "Deleted Complete"; } } else { message = "Failed! Please try again"; } return(new JsonResult { Data = new { status = status, message = message } }); }
// GET: TestSonuclari public ActionResult TestSonuclari() { var model = db.kullanici.Include(m => m.Sehirler).Where(m => m.Sonuc != null).ToList(); db.SaveChanges(); return(View(model)); }
public HttpResponseMessage UpdateEmployee([FromUri] int id, [FromBody] employee employee) { try { using (TestDBEntities entities = new TestDBEntities()) { var entity = entities.employees.FirstOrDefault(e => e.ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID: " + id + " does not exist")); } else { entity.Name = employee.Name; entity.Department = employee.Department; entity.Salary = employee.Salary; entity.Gender = employee.Gender; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }