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);
}