public IHttpActionResult PutEmployee(int id, Employee employee) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != employee.EmployeeID) { return(BadRequest()); } db.Entry(employee).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EmployeeExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutProduct(int id, Product product) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != product.PId) { return(BadRequest()); } db.Entry(product).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ProductExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutBook(string id, Book book) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != book.Title) { return(BadRequest()); } db.Entry(book).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!BookExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutUsuarios(int id, Usuarios usuarios) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != usuarios.id) { return(BadRequest("Los Ids deben ser iguales para realizar la actualizacion.")); } db.Entry(usuarios).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!UsuariosExists(id)) { return(NotFound()); } else { throw; } } return(Ok(usuarios)); }
//put-update database on id public IHttpActionResult PutCustomer(CustomerViewModel customer) { if (!ModelState.IsValid) { return(BadRequest("This is invalid model.please recheck")); } using (var x = new webapiEntities()) { var checkExsitingCustomer = x.Customers.Where(c => c.id == customer.Id) .FirstOrDefault <Customer>(); if (checkExsitingCustomer != null) { checkExsitingCustomer.name = customer.Name; checkExsitingCustomer.address = customer.Address; checkExsitingCustomer.phone = customer.Phone; x.SaveChanges(); } else { return(NotFound()); } } return(Ok()); }
//delete-delete a record base on id public IHttpActionResult Delete(int id) { if (id <= 0) { return(BadRequest("please enter valid customer id")); } using (var x = new webapiEntities()) { var customer = x.Customers .Where(c => c.id == id).FirstOrDefault(); x.Entry(customer).State = System.Data.Entity.EntityState.Deleted; x.SaveChanges(); } return(Ok()); }
//post-insert new record public IHttpActionResult PostNewCustomer(CustomerViewModel customer) { if (!ModelState.IsValid) { return(BadRequest("Invaliddata.please recheck")); } using (var x = new webapiEntities()) { x.Customers.Add(new Customer() { name = customer.Name, email = customer.Email, address = customer.Address, phone = customer.Phone }); x.SaveChanges(); } return(Ok()); }
public int Login(ChromeDriver chromeDriver, WebDriverWait wait, string userName, string passWord) { chromeDriver.Url = "http://qldt.actvn.edu.vn/CMCSoft.IU.Web.info/Login.aspx"; chromeDriver.Navigate(); string source = chromeDriver.PageSource; // tìm username input var userNameInput = chromeDriver.FindElementById("txtUserName"); userNameInput.SendKeys(userName); // tìm password input var passWordInput = chromeDriver.FindElementById("txtPassword"); passWordInput.SendKeys(passWord); // tìm nust login var btnSubmit = chromeDriver.FindElementById("btnSubmit"); btnSubmit.Click(); chromeDriver.FindElement(By.Id("PageHeader1_lblUserRole")); wait.Until(driver => driver.FindElement(By.Id("PageHeader1_lblUserRole")).Displayed); string currentURL = chromeDriver.Url; if (currentURL.ToLower() != "http://qldt.actvn.edu.vn/CMCSoft.IU.Web.info/home.aspx".ToLower()) { //Không đăng nhập thành công(tài khoản mật khẩu sai) return(-1); } else { if (CheckExistAccount(userName, passWord) == -1) { #region Vào cái trang thông tin cá nhân này lấy ít thông tin //http://qldt.actvn.edu.vn/CMCSoft.IU.Web.Info/StudentViewExamList.aspx chromeDriver.Url = "http://qldt.actvn.edu.vn/CMCSoft.IU.Web.info/StudentMark.aspx"; string hoTen = chromeDriver.FindElementById("lblStudentName").Text; string khoa = chromeDriver.FindElementById("lblAy").Text; string lop = chromeDriver.FindElementById("lblAdminClass").Text; #endregion #region Save Student sinhVien sV = new sinhVien(); sV.userName = userName; sV.passWord = passWord; sV.lop = lop; sV.khoa = lop; sV.ten = hoTen; con.sinhViens.Add(sV); con.SaveChanges(); #endregion return(2); } else if (CheckExistAccount(userName, passWord) == 0) { return(0); } else { sinhVien sV = con.sinhViens.Where(x => x.userName == userName).FirstOrDefault(); sV.passWord = passWord; con.SaveChanges(); return(1); } } }
public void Save() { _context.SaveChanges(); }