public HttpResponseMessage AddEmployee(EmployeeViewModel model) { try { if (ModelState.IsValid) { EmployeeModel emp = new EmployeeModel(); emp.FirstName = model.FirstName; emp.LastName = model.LastName; emp.Address = model.Address; emp.Salary = model.Salary; emp.DOB = Convert.ToDateTime(model.DOB.ToString("yyyy-MM-dd HH:mm:ss.fff")); context.Employees.Add(emp); var result = context.SaveChanges(); if (result > 0) { return(Request.CreateResponse(HttpStatusCode.Created, "Submitted Successfully")); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something wrong !")); } } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something wrong !")); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something wrong !", ex)); } }
public IHttpActionResult PutUser(int id, User user) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != user.Id) { return(BadRequest()); } db.Entry(user).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!UserExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public HttpResponseMessage AddDeparment(EmployeeViewModel model) { try { if (ModelState.IsValid) { DepartmentModel emp = new DepartmentModel(); emp.DepartmentID = model.DepartmentID; emp.DepartmentName = model.DepartmentName; context.Department.Add(emp); var result = context.SaveChanges(); if (result > 0) { return(Request.CreateResponse(HttpStatusCode.Created, "Submitted Successfully")); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something wrong !")); } } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something wrong !")); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Something wrong !", ex)); } }
public ActionResult Create([Bind(Include = "InstitutionId,InstitutionName,CreateDate")] Institution institution) { if (ModelState.IsValid) { db.Institutions.Add(institution); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(institution)); }
public ActionResult Create([Bind(Include = "ID,Name,Gender,IdNum,School,TrainingDate,InstitutionId,InputDate")] Student student) { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.InstitutionId = new SelectList(db.Institutions, "InstitutionId", "InstitutionName", student.InstitutionId); return(View(student)); }
public bool Add(EmployeeViewModel item) { EmployeeModel emp = new EmployeeModel(); emp.FirstName = item.FirstName; emp.LastName = item.LastName; emp.Address = item.Address; emp.Salary = item.Salary; emp.DOB = Convert.ToDateTime(item.DOB.ToString("yyyy-MM-dd HH:mm:ss.fff")); context.Employees.Add(emp); var result = context.SaveChanges(); return(result > 0 ? true : false); }
public static bool AddGame(string NewName, string NewDescription) { bool result; try { using (var GameDb = new DataAccessContext()) { var newGame = new game_systems { name = NewName, description = NewDescription }; var gameRecord = GameDb.game_systems.Add(newGame); GameDb.SaveChanges(); result = true; } } catch { //TODO: Log exception to log result = false; } return(result); }
public static bool DeleteGame(int gameid) { bool result; try { //deleting the corresponding datasets in table "pairings" using (var matchDb = new DataAccessContext()) { matchDb.pairings.RemoveRange(matchDb.pairings.Where(match => match.game_system_id == gameid)); matchDb.SaveChanges(); } //deleting the corresponding datasets in table "elos" using (var eloDb = new DataAccessContext()) { eloDb.eloes.RemoveRange(eloDb.eloes.Where(elo => elo.gid == gameid)); eloDb.SaveChanges(); } //deleting the corresponding datasets in table "game_systems" using (var GameDb = new DataAccessContext()) { GameDb.game_systems.Remove(GameDb.game_systems.Find(gameid)); GameDb.SaveChanges(); } result = true; } catch { //TODO: Log exception to log result = false; } return(result); }
public static bool ChangePassword(int userid, string NewPassword) { bool result; try { using (var userDb = new DataAccessContext()) { var userRecord = userDb.users.Find(userid); if (userRecord != null) { userRecord.password = NewPassword.CalculateMd5Hash(); userDb.Entry(userRecord).State = System.Data.Entity.EntityState.Modified; userDb.SaveChanges(); result = true; } else { result = false; } } } catch (Exception) { //TODO: Log exception to log result = false; } return(result); }
public static bool ChangeNameAndEmail(int userid, string NewUsername, string NewUseremail) { bool result; try { using (var userDb = new DataAccessContext()) { var userRecord = userDb.users.Find(userid); if (userRecord != null) { if (userRecord.email != NewUseremail) { CreateEmailChangeLog(userRecord.email, NewUseremail); } userRecord.name = NewUsername; userRecord.email = NewUseremail; userDb.Entry(userRecord).State = System.Data.Entity.EntityState.Modified; userDb.SaveChanges(); result = true; } else { result = false; } } } catch (Exception) { //TODO: Log exception to log result = false; } return(result); }
public static bool Save(UserModel user) { bool result; try { using (var db = new DataAccessContext()) { var newUser = new users { name = user.UserName, email = user.Email, isadmin = user.IsAdmin, password = user.Password.CalculateMd5Hash(), loginid = user.LoginGuid.ToString("N"), last_login = DateTime.Now }; db.users.Add(newUser); db.SaveChanges(); result = true; } } catch (Exception) { //TODO: Log exception to log result = false; } return(result); }
public ResultDTO ChangePassword(ChangePasswordDTO data) { ResultDTO retValue = null; using (var context = new DataAccessContext()) { User user = (from n in context.Users where n.Email == data.Email select n).FirstOrDefault(); if (user != null) { if (data.CurrentPassword.MD5Encrypt() == user.Password) { user.Password = data.NewPassword.MD5Encrypt(); context.SaveChanges(); retValue = new ResultDTO(); } } } return(retValue); }
public static bool ChangeGame(int gameid, string NewName, string NewDescription) { bool result; try { using (var GameDb = new DataAccessContext()) { var gameRecord = GameDb.game_systems.Find(gameid); if (gameRecord != null) { gameRecord.name = NewName; gameRecord.description = NewDescription; GameDb.Entry(gameRecord).State = System.Data.Entity.EntityState.Modified; GameDb.SaveChanges(); result = true; } else { result = false; } } } catch { //TODO: Log exception to log result = false; } return(result); }
public ResultDTO CheckItemOut(ItemDTO itemDto) { ResultDTO retValue = new ResultDTO(); using (var context = new DataAccessContext()) { var authResult = itemDto.Authenticate(context); if (!authResult.StatusCodeSuccess) { return(authResult); } Item item = (from n in context.Items where n.ID == itemDto.ID select n).First(); item.CheckOutDate = DateTime.Now; item.RequestDate = null; try { context.SaveChanges(); } catch (Exception ex) { retValue.StatusCode = (int)HttpStatusCode.InternalServerError; retValue.StatusCodeSuccess = false; retValue.StatusMessage = ex.Message; } } return(retValue); }
public void SaveHistory(History objectModel, long userId) { var objectTypeName = objectModel.GetType().Name; var objectTypeId = context.Set <ObjectType>().Where(x => x.Name == objectTypeName).FirstOrDefault().Id; var _object = new Models.Object() { CreatedById = userId, ModifiedById = userId, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, ObjectTypeId = objectTypeId }; context.Add(_object); context.SaveChanges(); context.Add <History>(objectModel); context.SaveChanges(); }
public void Save(T objectModel, long userId, long houseId, long?targetObjectId) { var objectTypeName = objectModel.GetType().Name; var objectTypeId = context.Set <ObjectType>().Where(x => x.Name == objectTypeName).FirstOrDefault().Id; var _object = new APPartment.Models.Object() { CreatedById = userId, ModifiedById = userId, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, ObjectTypeId = objectTypeId }; context.Add(_object); context.SaveChanges(); objectModel.ObjectId = _object.ObjectId; Task.Run(async() => await this.SaveChangesAsync(true, houseId, userId, targetObjectId, _object.ObjectId, objectModel, ContextExecutionTypes.Create)).Wait(); }
public ActionResult Classificar(PacoteViagem pacote) { if (ModelState.IsValid) { objContext.Entry(pacote).State = EntityState.Modified; objContext.SaveChanges(); return(RedirectToAction("Index")); } var pacotesViagens = objContext.PacoteViagens.ToList(); return(View(pacotesViagens)); }
public IActionResult Post([FromForm] string Name, int Age, string Gender, string Phone, string Email) { var pre = dbContext.Customer.LastOrDefault(); var cus = new Customer(); if (pre == null) { cus.ID = 1; } else { cus.ID = pre.ID + 1; } cus.Name = Name; cus.Age = Age; cus.Gender = Gender; cus.Phone = Phone; cus.Email = Email; dbContext.Customer.Add(cus); dbContext.SaveChanges(); return(Created("api/customers", cus)); }
public void SaveToDatabase() { var dbContext = new DataAccessContext(); foreach (var item in MicrocontrollerMap.IpMapId) { ValuesModel valuesModel = UpdateDatabase(item); if (valuesModel != null) { dbContext.ValuesModels.Add(valuesModel); dbContext.SaveChanges(); } } }
public static void ChangeMatchState(int gameId, int matchId, int status) { using (var db = new DataAccessContext()) { var acceptedMatch = db.pairings.FirstOrDefault(match => match.id == matchId); if (acceptedMatch != null) { acceptedMatch.status1 = status; db.Entry(acceptedMatch).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } }
public void TestMethod2() { var db = new DataAccessContext(); var usr = new Users() { Username = "******" }; db.User.Add(usr); var gravou = db.SaveChanges(); var teste = gravou; }
public static bool ChangeAdminState(int userid, int adminid) { bool result; string oldstate = ""; string newstate = ""; try { using (var userDb = new DataAccessContext()) { var userRecord = userDb.users.Find(userid); if (userRecord != null) { oldstate = userRecord.isadmin.ToString(); userRecord.isadmin = !userRecord.isadmin; userDb.Entry(userRecord).State = System.Data.Entity.EntityState.Modified; userDb.SaveChanges(); newstate = userRecord.isadmin.ToString(); result = true; } else { result = false; } } } catch (Exception) { //TODO: Log exception to log result = false; } finally { using (var LogDb = new DataAccessContext()) { var logentry = new log_admin(); logentry.timestamp = DateTime.Now; logentry.uid_affected = userid; logentry.uid_performed = adminid; logentry.changed_from = oldstate; logentry.changed_to = newstate; LogDb.log_admin.Add(logentry); LogDb.SaveChanges(); } } return(result); }
public static void CreateElo(int uid, int gameId) { using (var db = new DataAccessContext()) { var newElo = new eloes { elo = 1000, gid = gameId, uid = uid }; db.eloes.Add(newElo); db.SaveChanges(); } }
public void Save(T objectModel, long userId, long?targetObjectId, long houseId) { var objectTypeName = objectModel.GetType().Name; var objectTypeId = context.Set <ObjectType>().Where(x => x.Name == objectTypeName).FirstOrDefault().Id; var _object = new Models.Object() { CreatedById = userId, ModifiedById = userId, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, ObjectTypeId = objectTypeId }; context.Add(_object); context.SaveChanges(); historyContext.PopulateHistory((int)HistoryFunctionTypes.Create, objectModel, _object, userId, targetObjectId, houseId); objectModel.ObjectId = _object.ObjectId; context.Add <T>(objectModel); context.SaveChanges(); }
public HttpResponseMessage DeleteEmployee(int Id) { EmployeeModel emp = new EmployeeModel(); emp = context.Employees.Find(Id); if (emp != null) { context.Employees.Remove(emp); context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, emp)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Something wrong !")); } }
public static void Save(int opponentId, int result, int currentUserId, int gameId) { using (var db = new DataAccessContext()) { var pairing = new pairings { status1 = 0, status2 = 1, game_system_id = gameId, result = result, timestamp = DateTime.Now, uid1 = opponentId, uid2 = currentUserId }; db.pairings.Add(pairing); db.SaveChanges(); } }
private string SaveImageToDB(IFormFile file, long targetId, long userId, long houseId) { var image = new Image() { FileName = file.FileName, FileSize = humanSizeConverter.ConvertFileLength(file), CreatedDate = DateTime.Now, TargetId = targetId, }; context.Save(image, userId, houseId, targetId); image.Name = $"{image.Id}_{targetId}_{file.FileName}"; _context.Update(image); _context.SaveChanges(); return(image.Name); }
public static void RecalcRatings(int playerOneId, int playerTwoId, int result, int gameId) { using (var db = new DataAccessContext()) { var playerOne = db.eloes.Single(dbUser => dbUser.uid == playerOneId && dbUser.gid == gameId); var playerTwo = db.eloes.Single(dbUser => dbUser.uid == playerTwoId && dbUser.gid == gameId); var playerOneElo = playerOne.elo; var playerTwoElo = playerTwo.elo; var playerOneResult = 0.0; var playerTwoResult = 0.0; switch (result) { case 0: playerOneResult = 0.5; playerTwoResult = 0.5; break; case 1: playerOneResult = 1.0; playerTwoResult = 0.0; break; case 2: playerOneResult = 0.0; playerTwoResult = 1.0; break; } var playerOneEa = 1 / (1 + Math.Pow(10, (playerTwoElo - playerOneElo) / 400.0)); var newPlayerOneElo = playerOneElo + 20 * (playerOneResult - playerOneEa); var playerTwoEa = 1 / (1 + Math.Pow(10, (playerOneElo - playerTwoElo) / 400.0)); var newPlayerTwoElo = playerTwoElo + 20 * (playerTwoResult - playerTwoEa); playerOne.elo = (int)Math.Round(newPlayerOneElo, MidpointRounding.AwayFromZero); playerTwo.elo = (int)Math.Round(newPlayerTwoElo, MidpointRounding.AwayFromZero); db.SaveChanges(); } }
public ResultDTO RequestItems(DTOList <ItemDTO> dtoItems) { ResultDTO result = null; try { using (var context = new DataAccessContext()) { var idList = dtoItems.Select(n => n.ID); var items = (from n in context.Items where idList.Contains(n.ID) select n).ToList(); items.ForEach(item => { item.AssociatedUserId = dtoItems.Where(dto => dto.ID == item.ID).First().AssociatedUserId; item.RequestDate = DateTime.Now; }); context.SaveChanges(); result = new ResultDTO { StatusCode = (int)HttpStatusCode.OK, StatusCodeSuccess = true, StatusMessage = $"Updated {items.Count} items" }; } } catch (Exception ex) { result = new ResultDTO { StatusCode = (int)HttpStatusCode.InternalServerError, StatusCodeSuccess = false, StatusMessage = ex.ToString() }; } return(result); }
public ResultDTO DeleteItem(IdDTO idDTO) { ResultDTO result = new ResultDTO(); using (var context = new DataAccessContext()) { var authResult = idDTO.Authenticate(context); if (!authResult.StatusCodeSuccess) { return(authResult); } // remove foreign keys List <Item2AgeGroup> item2AgeGroups = (from n in context.Item2AgeGroup where n.ItemId == idDTO.ID select n).ToList(); item2AgeGroups.ForEach(n => context.Item2AgeGroup.Remove(n)); List <Item2Subject> item2Subjects = (from n in context.Item2Subject where n.ItemId == idDTO.ID select n).ToList(); item2Subjects.ForEach(n => context.Item2Subject.Remove(n)); // delete item Item curItem = (from n in context.Items where n.ID == idDTO.ID select n).First(); result.StatusMessage = "Deleted 1 item"; context.Items.Remove(curItem); context.SaveChanges(); } return(result); }