public Accommodation GetAccommodationByID(int ID)
{
using (var context = new PMSContext())
{
return(context.Accommodations.Find(ID));
}
}
private User AddUserWithoutCorrespondenceAdress()
{
PMSContext dbContext = new PMSContext();
var userRole = dbContext.UserRole.Where(n => n.Name.Equals(_UserRole)).SingleOrDefault();
int userRoleID = userRole.UserRoleID;
User user;
user = new User()
{
UserRoleID = userRoleID,
TeamID = null,
FirstName = _FirstName,
LastName = _LastName,
Login = _Login,
Password = _Password,
Salary = _Salary,
PhoneNumber = _PhoneNumber,
Email = _Email,
AccountCreationDate = DateTime.Now,
HiredDate = _HiredDate,
FiredDate = _FiredDate,
ResidenceStreet = _ResidenceStreet,
ResidenceHouseNumber = _ResidenceHouseNumber,
ResidenceApartmentNumber = _ResidenceApartmentNumber,
ResidenceCity = _ResidenceCity,
ResidencePostcode = _ResidencePostcode,
CorrespondenceStreet = _ResidenceStreet,
CorrespondenceHouseNumber = _ResidenceHouseNumber,
CorrespondenceApartmentNumber = _ResidenceApartmentNumber,
CorrespondencePostcode = _ResidencePostcode,
CorrespondenceCity = _ResidenceCity
};
return(user);
}
/// <summary>
/// sprawdzam czy user ma jeszce jakies subtaski
/// </summary>
/// <param name="user"></param>
/// <param name="teamParam"></param>
/// <returns></returns>
bool EditUserTeamValidation(User user, string teamParam)
{
PMSContext dbContext = new PMSContext();
if (user.UserRole.Name != "Admin")
{
if (user.Team.Name == teamParam)
{
return(true);
}
else
{
int _allTask = dbContext.Subtask.Where(x => (x.UserID == user.UserID) && ((x.SubtaskStatus.Name == "New") || (x.SubtaskStatus.Name == "In progress"))).Count();
if (_allTask == 0)
{
return(true);
}
else
{
ErrorMessage er = new ErrorMessage("User has new or in progress task!");
er.ShowDialog();
return(false);
}
}
}
else
{
return(true);
}
}
public bool UpdateAccommodation(Accommodation accommodation)
{
var context = new PMSContext();
context.Entry(accommodation).State = System.Data.Entity.EntityState.Modified;
return(context.SaveChanges() > 0);
}
public bool SavePicture(Picture picture)
{
var context = new PMSContext();
context.Pictures.Add(picture);
return(context.SaveChanges() > 0);
}
public bool SaveAccommodationPackage(AccommodationPackage accommodationPackage)
{
var context = new PMSContext();
context.AccommodationPackages.Add(accommodationPackage);
return(context.SaveChanges() > 0);
}
public bool SaveAccommodation(Accommodation accommodation)
{
var context = new PMSContext();
context.Accommodations.Add(accommodation);
return(context.SaveChanges() > 0);
}
public bool DeleteAccommodationType(AccommodationType accommodationType)
{
var context = new PMSContext();
context.Entry(accommodationType).State = System.Data.Entity.EntityState.Deleted;
return(context.SaveChanges() > 0);
}
public ActionResult Delete(int id)
{
PMSContext context = new PMSContext();
Property property = context.Properties.Find(id);
context.Properties.Remove(property);
context.SaveChanges();
return RedirectToAction("Index","Property");
}
private static void increaseLoginTry()
{
using (PMSContext context = new PMSContext())
{
TblLoginTry tempTry = new TblLoginTry();
tempTry.TriedIp = GlobalMethods.returnUserIp();
tempTry.DateOfTry = DateTimeHelper.ServerTime;
context.TblLoginTry.Add(tempTry);
context.SaveChanges();
}
}
//private void RemoveUser(object ID)
//{
// int val = Convert.ToInt32(ID);
// User user = dbContext.User.Find(val);
// dbContext.User.Remove(user);
// dbContext.SaveChanges();
// _Users.Remove(user);
// _FilteredUsers.Remove(user);
//}
public void FilterUser()
{
if (SelectedName == null)
{
SelectedName = "";
}
PMSContext dbContext2 = new PMSContext();
FilteredUsers = new ObservableCollection <User>(dbContext2.User.Where(c => (SelectedUserRole == "All" ? true : c.UserRole.Name == SelectedUserRole) &&
c.FirstName.Contains(SelectedName)));
}
public bool DeleteAccommodationPackage(AccommodationPackage accommodationPackage)
{
var context = new PMSContext();
var existingAccommodationPackage = context.AccommodationPackages.Find(accommodationPackage.ID);
context.AccommodationPackagePictures.RemoveRange(existingAccommodationPackage.AccommodationPackagePicture);
context.Entry(existingAccommodationPackage).State = System.Data.Entity.EntityState.Deleted;
return(context.SaveChanges() > 0);
}
public IEnumerable <AccommodationType> SearchAccommodationTypes(string searchTerm)
{
var context = new PMSContext();
var accommodationTypes = context.AccommodationTypes.AsQueryable();
if (!string.IsNullOrEmpty(searchTerm))
{
accommodationTypes = accommodationTypes.Where(a => a.Name.ToLower().Contains(searchTerm.ToLower()));
}
return(accommodationTypes.ToList());
}
public bool UpdateAccommodationPackage(AccommodationPackage accommodationPackage)
{
var context = new PMSContext();
var existingAccommodationPackage = context.AccommodationPackages.Find(accommodationPackage.ID);
context.AccommodationPackagePictures.RemoveRange(existingAccommodationPackage.AccommodationPackagePicture);
context.Entry(existingAccommodationPackage).CurrentValues.SetValues(accommodationPackage);
context.AccommodationPackagePictures.AddRange(accommodationPackage.AccommodationPackagePicture);
return(context.SaveChanges() > 0);
}
protected override void Seed(PMSContext context)
{
PMSInitializer.SeedPMS(context);
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
// context.People.AddOrUpdate(
// p => p.FullName,
// new Person { FullName = "Andrew Peters" },
// new Person { FullName = "Brice Lambson" },
// new Person { FullName = "Rowan Miller" }
// );
//
}
//private void RemoveUser(object ID)
//{
// int val = Convert.ToInt32(ID);
// User user = dbContext.User.Find(val);
// dbContext.User.Remove(user);
// dbContext.SaveChanges();
// _Users.Remove(user);
// _FilteredUsers.Remove(user);
//}
public void FilterUser()
{
PMSContext dbContext = new PMSContext();
if (SelectedNIP == null)
{
SelectedNIP = "";
}
if (_SelectedCompanyName == null)
{
_SelectedCompanyName = "";
}
FilteredClients = new ObservableCollection <Client>(dbContext.Client.Where(c => c.NIP.Contains(SelectedNIP) &&
c.CompanyName.Contains(SelectedCompanyName)));
}
bool LoginValidation(string login)
{
PMSContext dbContext = new PMSContext();
List <User> users = dbContext.User.ToList();
var check = users.Where(x => x.Login == login).SingleOrDefault();
if (login.Length >= 6 && check == null)
{
return(true);
}
else
{
ErrorMessage er = new ErrorMessage("Incorrect login! Login already exists or has less than 6 characters.");
er.ShowDialog();
return(false);
}
}
bool TeamEditRemoveUserCheckSUbtaskValidation(User user)
{
PMSContext dbContext = new PMSContext();
int _allTask = dbContext.Subtask.Where(x => (x.UserID == user.UserID) && ((x.SubtaskStatus.Name == "New") || (x.SubtaskStatus.Name == "In progress"))).Count();
if (_allTask == 0)
{
return(true);
}
else
{
ErrorMessage er = new ErrorMessage("User has new or in progress task!");
er.ShowDialog();
return(false);
}
}
bool TeamNameValidation(string teamName)
{
PMSContext dbContext = new PMSContext();
List <Team> teams = dbContext.Team.ToList();
var check = teams.Where(x => x.Name == teamName).SingleOrDefault();
if (teamName.Length >= 5 && check == null)
{
return(true);
}
else
{
ErrorMessage er = new ErrorMessage("Incorrect team name! Team name has less than 5 characters.");
er.ShowDialog();
return(false);
}
}
//Usuniecie teamu
bool RemoveTeamCheckSUbtaskValidation(Team team)
{
PMSContext dbContext = new PMSContext();
foreach (var user in team.Users)
{
int _allTask = dbContext.Subtask.Where(x => (x.UserID == user.UserID) && ((x.SubtaskStatus.Name == "New") || (x.SubtaskStatus.Name == "In progress"))).Count();
if (_allTask > 0)
{
ErrorMessage er = new ErrorMessage("Users have new or in progress task!");
er.ShowDialog();
return(false);
}
}
return(true);
}
public int SearchAccommodationsCount(string searchTerm, int?accommodationPackageID)
{
var context = new PMSContext();
var accommodations = context.Accommodations.AsQueryable();
if (!string.IsNullOrEmpty(searchTerm))
{
accommodations = accommodations.Where(a => a.Name.ToLower().Contains(searchTerm.ToLower()));
}
if (accommodationPackageID.HasValue && accommodationPackageID.Value > 0)
{
accommodations = accommodations.Where(a => a.AccommodationPackageID == accommodationPackageID.Value);
}
return(accommodations.Count());
}
private void AddTask()
{
EmployeeValidation EV = new EmployeeValidation();
bool correctForm = EV.AddTaskValidation(Name, Description);
if (correctForm)
{
PMSContext dbContext = new PMSContext();
Subtask subtask = new Subtask
{
Name = _Name,
Description = _Description,
StartTime = DateTime.Now,
EndTime = _EndTime,
MainTaskID = null,
SubtaskStatusID = 1,
Priority = _SelectedPriority,
UserID = SelectedUser.UserID,
WhoCreated = Global.user.UserID
};
RecentActivity ra = new RecentActivity
{
DateAdded = DateTime.Now,
TeamID = (int)Global.user.TeamID,
Description = $"User {Global.user.FullName} has created a new task " +
$"for {SelectedUser.FullName} called: {_Name}"
};
dbContext.Subtask.Add(subtask);
dbContext.RecentActivity.Add(ra);
dbContext.SaveChanges();
setVariableWhenAddTask();
ErrorMessage er = new ErrorMessage("Task created successfully!");
er.ShowDialog();
}
}
public IEnumerable <Accommodation> SearchAccommodations(string searchTerm, int?accommodationPackageID, int page, int recordSize)
{
var context = new PMSContext();
var accommodations = context.Accommodations.AsQueryable();
if (!string.IsNullOrEmpty(searchTerm))
{
accommodations = accommodations.Where(a => a.Name.ToLower().Contains(searchTerm.ToLower()));
}
if (accommodationPackageID.HasValue && accommodationPackageID.Value > 0)
{
accommodations = accommodations.Where(a => a.AccommodationPackageID == accommodationPackageID.Value);
}
var skip = (page - 1) * recordSize;
return(accommodations.OrderBy(x => x.AccommodationPackageID).Skip(skip).Take(recordSize).ToList());
}
private Client AddClientObject()
{
PMSContext dbContext = new PMSContext();
Client client;
client = new Client()
{
FirstName = _FirstName,
LastName = _LastName,
CompanyName = _CompanyName,
NIP = _NIP,
REGON = _REGON,
Street = _Street,
HouseNumber = _HouseNumber,
ApartmentNumber = _ApartmentNumber,
City = _City,
Postcode = _Postcode
};
return(client);
}
private void AddClient()
{
AdminValidation VM = new AdminValidation();
bool correctForm = VM.ClientValidation(FirstName, LastName, CompanyName, NIP, REGON);
if (correctForm)
{
PMSContext dbContext = new PMSContext();
Client client;
client = AddClientObject();
dbContext.Client.Add(client);
dbContext.SaveChanges();
setVariable();
ErrorMessage er = new ErrorMessage("Client created successfully!");
er.ShowDialog();
}
}
public static void loginTry(MainWindow main)
{
using (PMSContext context = new PMSContext())
{
var vrIpTestResult = context.TblLoginTry.Where(pr => pr.TriedIp == GlobalMethods.returnUserIp() & pr.DateOfTry.AddMinutes(15) > DateTimeHelper.ServerTime).Count();
if (vrIpTestResult >= 5)
{
MessageBox.Show("Error! You have so many times tried to login withing 15 minutes. Try again later!");
return;
}
var vrUserEmail = context.TblUsers.FirstOrDefault(pr => pr.UserEmail == main.txtLoginEmail.Text);
if (vrUserEmail == null)
{
increaseLoginTry();
MessageBox.Show("Error! No such user is found!");
return;
}
if (vrUserEmail.UserPw != GlobalMethods.returnUserPw(main.txtLoginPassword.Password.ToString(), vrUserEmail.SaltOfPw))
{
increaseLoginTry();
MessageBox.Show("Error! The entered password is incorrect");
return;
}
loggedUser = vrUserEmail;
loggedUser.UserPw = null;//you can nullfiy the sensitive information so they wont remain in ram memory
dtLoginTime = DateTimeHelper.ServerTime;
GlobalMethods.changeLoginStatus();
if (loggedUser.UserType == 2)
{
GlobalMethods.main.tabDrugs.IsSelected = true;
}
MessageBox.Show("You have successfully logged-in");
}
}
protected override void Seed(PMS.Service.PMSContext context)
{
using (PMSContext db = new PMSContext())
{
PMSuser user = new PMSuser
{
Id = new Guid("BF60FF99-0E9E-4E75-8B4F-5C70CBD3B4A0"),
CreatedBy = new Guid("BF60FF99-0E9E-4E75-8B4F-5C70CBD3B4A0"),
ModifiedBy = new Guid("BF60FF99-0E9E-4E75-8B4F-5C70CBD3B4A0"),
CreatedOn = DateTime.Now,
ModifiedOn = DateTime.Now,
DOB = new DateTime(1993, 6, 9),
Email = "*****@*****.**",
IsDeleted = false,
Attempts = 0,
Name = "Admin",
IsLockedOut = false,
Password = "******",
Phone = "8905179900",
UserName = "******"
};
db.PMSuser.Add(user);
db.SaveChanges();
}
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
// context.People.AddOrUpdate(
// p => p.FullName,
// new Person { FullName = "Andrew Peters" },
// new Person { FullName = "Brice Lambson" },
// new Person { FullName = "Rowan Miller" }
// );
//
}
bool NameProjectValidation(string name)
{
PMSContext dbContext = new PMSContext();
List <Project> listOfPrject = new List <Project>(dbContext.Project);
foreach (var tmp in listOfPrject)
{
if (tmp.Name == name)
{
name = null;
}
}
if (name.Length > 10 && name != null)
{
return(true);
}
else
{
ErrorMessage er = new ErrorMessage("Project name must be over 10 characters and be unique");
er.ShowDialog();
return(false);
}
}
/*public string VisibilityTeam
* {
* get
* {
* return _VisibilityTeam;
* }
* set
* {
* _VisibilityTeam = value;
* RaisePropertyChanged("VisibilityTeam");
* }
* }*/
#endregion
private void AddUser()
{
PMSContext dbContext = new PMSContext();
User user;
AdminValidation AV = new AdminValidation();
bool correctForm = AV.AddUserValidation(FirstName, LastName, Login, Password, Salary, PhoneNumber, Email, UserRole, FiredDate, HiredDate);
if (correctForm == true)
{
if (CorrespondenceCity == null)
{
user = AddUserWithoutCorrespondenceAdress();
dbContext.User.Add(user);
dbContext.SaveChanges();
setVariable();
ErrorMessage er = new ErrorMessage("User created successfully!");
er.ShowDialog();
}
else
{
user = AddUserWithCorrespondenceAdress();
dbContext.User.Add(user);
dbContext.SaveChanges();
setVariable();
ErrorMessage er = new ErrorMessage("User created successfully!");
er.ShowDialog();
}
}
}
public OrderController(PMSContext context, IMapper mapper, ILogger <OrderController> logger)
{
_context = context;
_mapper = mapper;
_logger = logger;
}
