public IHttpActionResult PutDepartment(int id, Department department) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != department.DeptID) { return(BadRequest()); } db.Entry(department).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DepartmentExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult postEmployee(Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); db.SaveChanges(); return(Ok(employee)); } else { return(BadRequest(ModelState)); } }
// Add New Employee public IHttpActionResult PostEmployee(Employee employee) { if (employee == null) { return(BadRequest()); } else { db.Employees.Add(employee); db.SaveChanges(); return(Created("Employee Class", employee)); } }
// Add New Department public IHttpActionResult PostDepartment(Department department) { if (department == null) { return(BadRequest()); } else { db.Departments.Add(department); db.SaveChanges(); return(Created("Employee Class", department)); } }
public dynamic Create(dynamic _Obj, dynamic _Para = null) { try { Product product = _Obj; MyEF.Products.Add(product); MyEF.SaveChanges(); return(ReturnCode.Success); } catch (Exception ex) { return(ReturnCode.Fail); } }
public dynamic Create(dynamic _Obj, dynamic _Para = null) { try { Member member = _Obj; MyEF.Members.Add(member); MyEF.SaveChanges(); return(ReturnCode.Success); } catch (Exception ex) { return(ReturnCode.Fail); } }
public ActionResult Registration(User user) { bool Status = false; string message = ""; //Model validation if (ModelState.IsValid) { var emailIsExist = IsEmailExist(user.EmailID); if (emailIsExist) { ModelState.AddModelError("EmailExists", "Email already exists."); return(View()); } //Password Hashing user.Password = Crypto.Hash(user.Password); user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword); //save to DB using (MyDataBaseEntities dc = new MyDataBaseEntities()) { { dc.Users.Add(user); dc.SaveChanges(); } } } else { message = "Invalid Request"; } ViewBag.Message = message; ViewBag.Status = Status; return(View(user)); }
public void DeleteStudent(int id) { var db = new MyDataBaseEntities(); var student = db.Student.Find(id); db.Student.Remove(student); db.SaveChanges(); }
public ActionResult DeleteReader(int id) { MyDataBaseEntities dc = new MyDataBaseEntities(); var readerId = dc.Reader.Find(id); dc.Reader.Remove(readerId); dc.SaveChanges(); return(RedirectToAction("ReaderList", "Reader")); }
public ActionResult AddOrEdit(Emp empModel) { using (MyDataBaseEntities dbmodel = new MyDataBaseEntities()) { dbmodel.Emps.Add(empModel); dbmodel.SaveChanges(); } ModelState.Clear(); ViewBag.SuccessMessage = "Regestration Successfully"; return(View(" AddOrEdit", new Emp())); }
public void UpdateStudent(int id, string name, DateTime birthday, int class_id) { var db = new MyDataBaseEntities(); var student = db.Student.Find(id); student.Name = name; student.Birthday = birthday; student.Class_id = class_id; db.Entry(student).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }
public ActionResult Registration([Bind(Exclude = "IsEmailVerified, ActivationCode")] User user) { bool Status = false; string message = ""; //Modelvalidation if (ModelState.IsValid) { #region //Email is already Exist or not var isExist = IsEmailExist(user.EmailID); if (isExist) { ModelState.AddModelError("EmailExist", "Email already exist"); return(View(user)); } #endregion #region Generate Activation Code user.ActivationCode = Guid.NewGuid(); #endregion #region Password Hashing user.Password = Crypto.Hash(user.Password); user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword); #endregion user.IsEmailVerified = false; #region Sava data to Database using (MyDataBaseEntities dc = new MyDataBaseEntities()) { dc.Users.Add(user); dc.SaveChanges(); //Send Email to User sendVerificationLinkEmail(user.EmailID, user.ActivationCode.ToString()); message = "Registration successfully done. Account activation link has been sent" + " to your email id:" + user.EmailID; Status = true; } #endregion } else { message = "Invalid Request"; } ViewBag.Message = message; ViewBag.Status = Status; return(View(user)); }
public void CreateStudent(string code, string name, DateTime birthday, int class_id) { var student = new Student(); student.Code = code; student.Name = name; student.Birthday = birthday; student.Class_id = class_id; var db = new MyDataBaseEntities(); db.Student.Add(student); db.SaveChanges(); }
public ActionResult Reader(Reader reader) { MyDataBaseEntities dc = new MyDataBaseEntities(); var model = dc.ReadingLog.ToList(); try { dc.Reader.Add(reader); dc.SaveChanges(); } catch (DbUpdateException ex) { Console.WriteLine(ex.InnerException.Message); } return(RedirectToAction("ReaderList", "Reader")); }
public ActionResult VerifyAccount(string id) { bool Status = false; using (MyDataBaseEntities dc = new MyDataBaseEntities()) { dc.Configuration.ValidateOnSaveEnabled = false; //This is the line i have added here to avoid confirm password does not match issue on save changes var v = dc.Users.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault(); if (v != null) { v.IsEmailVerified = true; dc.SaveChanges(); Status = true; } else { ViewBag.Message = "Invalid Request"; } } ViewBag.Status = Status; return(View()); }
public ActionResult Add(User usermodel) { using (MyDataBaseEntities dbmodel = new MyDataBaseEntities()) { if (dbmodel.User.Any(x => x.UserName == usermodel.UserName)) { log.Info(usermodel.UserName + " already exists"); ViewBag.DuplicateMessage = "Username already exists"; return(View("Add", new User())); } RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider(); byte[] sel = new byte[4]; rng.GetBytes(sel); usermodel.Salt = Convert.ToBase64String(sel); usermodel.Password += usermodel.Salt; //hachage Password var crypt = new SHA256Managed(); var hash = new StringBuilder(); byte[] crypto = crypt.ComputeHash(Encoding.UTF8.GetBytes(usermodel.Password)); foreach (byte theByte in crypto) { hash.Append(theByte.ToString("x2")); } //change password to hash password usermodel.Password = hash.ToString(); usermodel.ConfirmPassword = usermodel.Password; dbmodel.User.Add(usermodel); dbmodel.SaveChanges(); log.Info(usermodel.UserName + " Success Registration"); ViewBag.SuccessMessage = "Success Registration"; return(View(new User())); } }
public ActionResult Create(ReadingLog readingLog) { string bookName = readingLog.BookName; string authorName = readingLog.Author; readingLog.ClockIn = DateTime.Now; readingLog.ClockOut = DateTime.Now; readingLog.ReaderId = Convert.ToInt32(Session["ReaderId"]); readingLog.ReaderName = Convert.ToString(Session["ReaderName"]); int Id = Convert.ToInt32(Session["ReaderId"]); using (MyDataBaseEntities dc = new MyDataBaseEntities()) { dc.ReadingLog.Add(readingLog); dc.SaveChanges(); var readingLogList = dc.ReadingLog.Where(a => a.ReaderId == Id).ToList(); //var BookList = (readingLogList.Select(a => a.BookName)).ToList(); //dc.ReadingLog.Where(a => a.ReaderId == readingLog.ReaderId).Select(a =>a.BookName).ToList(); //return Redirect(ReaderDetails); //Console.Write(BookList); return(View("BookList", readingLogList)); } }