public void RenewRequest(Request request, Person person, DateTime startDate, DateTime endDate)
{
using (var context = new ProgDatabaseEntities())
{
Decision _newDecision = new Decision();
Action _renewAction = new Action();
_renewAction = context.Actions.Where(a => a.DisplayName == "Renew").Single();
_newDecision.Action1 = _renewAction;
_newDecision.Request = context.Requests.Where(r => r.RequestID == request.RequestID).Single();
_newDecision.Person1 = context.People.Where(p => p.PersonID == person.PersonID).Single();
_newDecision.ChangeDate = DateTime.Now;
_newDecision.Reason = "Renew initiated by " + person.ToString();
context.Decisions.Add(_newDecision);
DecisionLevel _newDecisionLevel = new DecisionLevel();
_newDecisionLevel = context.DecisionLevels.Where(d => d.DecisionLevel1 == 1).Single();
Request _request = new Request();
_request = context.Requests.Where(r => r.RequestID == request.RequestID).Single();
_request.DecisionLevel = _newDecisionLevel;
_request.ValidityStart = startDate;
_request.ValidityEnd = endDate;
context.SaveChanges();
}
}
public void AddNewRequest(Request request)
{
using (var context = new ProgDatabaseEntities())
{
var _person = context.People.Where(p => p.PersonID == request.Person.PersonID).Single();
var _role = context.Roles.Where(r => r.RoleID == request.Role.RoleID).Single();
var _requestType = context.RequestTypes.Where(rt => rt.RequestTypeID == 1).Single(); ////////// <----- TÖRÖLNI
var _decisionLevel = context.DecisionLevels.Where(d => d.DecisionLevel1 == 1);
request.Person = _person;
request.Role = _role;
request.RequestType = _requestType;
foreach (var dLevel in _decisionLevel)
{
request.DecisionLevel = dLevel;
}
context.Requests.Add(request);
context.SaveChanges();
}
}
public void UpdateLocation(Location location, Person manager)
{
using (var context = new ProgDatabaseEntities())
{
Person oldLocManager = new Person();
var loc = from l in context.Locations
where l.LocationID == location.LocationID
select l;
var newManager = from m in context.People
where m.PersonID == manager.PersonID
select m;
var _manager = context.Locations.Where(l => l.LocationID == location.LocationID).Single().People1;
foreach (var item in _manager.ToList())
{
_manager.Remove(item);
}
foreach (var m in newManager)
{
_manager.Add(m);
}
context.SaveChanges();
//var ujManager = context.Locations.Where(l => l.LocationID == location.LocationID).Single().People1;
}
}
public void AddNewPerson(Person person)
{
using (var context = new ProgDatabaseEntities())
{
context.People.Add(person);
context.SaveChanges();
}
}
public void RemoveEditedPerson(Person person)
{
using (var context = new ProgDatabaseEntities())
{
try
{
context.Entry(person).State = EntityState.Deleted;
context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
public void AddNewDecision(Person person, Request request)
{
using (var context = new ProgDatabaseEntities())
{
Decision newDecision = new Decision();
var _action = context.Actions.Where(a => a.DisplayName.Contains("Create")).Single();
//var decesionLevels = context.DecisionLevels.Where(d => d.DecisionLevel1 == 1);
var _person = context.People.Where(p => p.PersonID == person.PersonID).Single();
var _request = context.Requests.Where(r => r.RequestID == request.RequestID).Single();
newDecision.Request = _request;
newDecision.Person = _person;
newDecision.ChangeDate = DateTime.Now;
newDecision.Reason = "Request created by " + person;
newDecision.Action1 = _action;
context.Decisions.Add(newDecision);
context.SaveChanges();
}
}
public void DenyRequest(Request request, Action action, Person approver, string reason)
{
using (var context = new ProgDatabaseEntities())
{
Decision _newDecision = new Decision();
_newDecision.Action1 = context.Actions.Where(a => a.ActionID == action.ActionID).Single();
_newDecision.Request = context.Requests.Where(r => r.RequestID == request.RequestID).Single();
_newDecision.Person1 = context.People.Where(p => p.PersonID == approver.PersonID).Single();
_newDecision.ChangeDate = DateTime.Now;
_newDecision.Reason = reason;
context.Decisions.Add(_newDecision);
DecisionLevel _newDecisionLevel = new DecisionLevel();
_newDecisionLevel = context.DecisionLevels.Where(d => d.DecisionLevel1 == 4).Single();
Request _request = new Request();
_request = context.Requests.Where(r => r.RequestID == request.RequestID).Single();
_request.DecisionLevel = _newDecisionLevel;
context.SaveChanges();
}
}
public void UpdatePerson(Person person)
{
using (var context = new ProgDatabaseEntities())
{
var query = from p in context.People
where p.PersonID == person.PersonID
select p;
foreach (var item in query)
{
item.FirstName = person.FirstName;
item.LastName = person.LastName;
item.Username = person.Username;
item.Password = person.Password;
item.Email = person.Email;
item.Position = person.Position;
item.LocationID = person.LocationID;
item.Manager = person.Manager;
}
context.SaveChanges();
}
}
public void UnsubscribeRequest(Request request)
{
using (var context = new ProgDatabaseEntities())
{
try
{
var decisions = from d in context.Decisions
where d.RequestID == request.RequestID
select d;
foreach (var decision in decisions)
{
context.Entry(decision).State = EntityState.Deleted;
}
context.Entry(request).State = EntityState.Deleted;
context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}