/// <summary>
/// Edits a new user depending if the uderID already exists
/// </summary>
/// <param name="user">the user that is being added</param>
/// <param name="sector">the sector that is being added</param>
/// <returns>a new user</returns>
public tblUser AddUser(tblUser user, tblSector sector)
{
InputCalculator iv = new InputCalculator();
try
{
using (WorkerContext context = new WorkerContext())
{
if (user.UserID == 0)
{
user.DateOfBirth = iv.CountDateOfBirth(user.JMBG);
tblUser newUser = new tblUser();
newUser.FirstName = user.FirstName;
newUser.LastName = user.LastName;
newUser.JMBG = user.JMBG;
newUser.IDCard = user.IDCard;
newUser.DateOfBirth = user.DateOfBirth;
newUser.Gender = user.Gender;
newUser.PhoneNumber = user.PhoneNumber;
newUser.SectorID = sector.SectorID;
newUser.LocationID = user.LocationID;
newUser.MenagerID = user.MenagerID;
context.tblUsers.Add(newUser);
context.SaveChanges();
user.UserID = newUser.UserID;
return(user);
}
else
{
tblUser usersToEdit = (from ss in context.tblUsers where ss.UserID == user.UserID select ss).First();
// Get the date of birth
user.DateOfBirth = iv.CountDateOfBirth(user.JMBG);
usersToEdit.FirstName = user.FirstName;
usersToEdit.LastName = user.LastName;
usersToEdit.JMBG = user.JMBG;
usersToEdit.IDCard = user.IDCard;
usersToEdit.DateOfBirth = user.DateOfBirth;
usersToEdit.Gender = user.Gender;
usersToEdit.PhoneNumber = user.PhoneNumber;
usersToEdit.SectorID = sector.SectorID;
usersToEdit.LocationID = user.LocationID;
usersToEdit.MenagerID = user.MenagerID;
usersToEdit.UserID = user.UserID;
context.SaveChanges();
return(user);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Calcualtes the birth date and places it in the textbox
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void TextBox_TextChanged(object sender, EventArgs e)
{
InputCalculator iv = new InputCalculator();
string text = "";
if (txtJMBG.Text.Length >= 7)
{
text = iv.CountDateOfBirth(txtJMBG.Text).ToString("dd.MM.yyy.");
}
else
{
text = "";
}
txtDateOfBirth.Text = text;
}
/// <summary>
/// Creates or edits a manager
/// </summary>
/// <param name="manager">the manager that is esing added</param>
/// <returns>a new or edited manager</returns>
public vwManager AddManager(vwManager manager)
{
InputCalculator iv = new InputCalculator();
try
{
using (ReportDBEntities context = new ReportDBEntities())
{
if (manager.UserID == 0)
{
manager.DateOfBirth = iv.CountDateOfBirth(manager.JMBG);
tblUser newManager = new tblUser
{
FirstName = manager.FirstName,
LastName = manager.LastName,
JMBG = manager.JMBG,
DateOfBirth = manager.DateOfBirth,
BankAccount = manager.BankAccount,
Email = manager.Email,
Position = manager.Position,
Salary = manager.Salary,
Username = manager.Username,
UserPassword = manager.UserPassword,
Sector = manager.Sector,
Access = manager.Access
};
context.tblUsers.Add(newManager);
context.SaveChanges();
manager.UserID = newManager.UserID;
return(manager);
}
else
{
tblUser managerToEdit = (from ss in context.tblUsers where ss.UserID == manager.UserID select ss).First();
// Get the date of birth
manager.DateOfBirth = iv.CountDateOfBirth(manager.JMBG);
managerToEdit.FirstName = manager.FirstName;
managerToEdit.LastName = manager.LastName;
managerToEdit.JMBG = manager.JMBG;
managerToEdit.DateOfBirth = manager.DateOfBirth;
managerToEdit.BankAccount = manager.BankAccount;
managerToEdit.Email = manager.Email;
managerToEdit.Salary = manager.Salary;
managerToEdit.Username = manager.Username;
managerToEdit.Position = manager.Position;
managerToEdit.UserPassword = manager.UserPassword;
managerToEdit.Sector = manager.Sector;
managerToEdit.Access = manager.Access;
managerToEdit.UserID = manager.UserID;
tblUser managerEdit = (from ss in context.tblUsers
where ss.UserID == manager.UserID
select ss).First();
context.SaveChanges();
return(manager);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Creates or edits a worker
/// </summary>
/// <param name="worker">the worker that is esing added</param>
/// <returns>a new or edited worker</returns>
public vwUser AddWorker(vwUser worker)
{
InputCalculator iv = new InputCalculator();
try
{
using (ReportDBEntities context = new ReportDBEntities())
{
if (worker.UserID == 0)
{
worker.DateOfBirth = iv.CountDateOfBirth(worker.JMBG);
tblUser newWorker = new tblUser
{
FirstName = worker.FirstName,
LastName = worker.LastName,
JMBG = worker.JMBG,
DateOfBirth = worker.DateOfBirth,
BankAccount = worker.BankAccount,
Email = worker.Email,
Position = worker.Position,
Salary = worker.Salary,
Username = worker.Username,
UserPassword = worker.UserPassword
};
context.tblUsers.Add(newWorker);
context.SaveChanges();
worker.UserID = newWorker.UserID;
return(worker);
}
else
{
tblUser workerToEdit = (from ss in context.tblUsers where ss.UserID == worker.UserID select ss).First();
// Get the date of birth
worker.DateOfBirth = iv.CountDateOfBirth(worker.JMBG);
workerToEdit.FirstName = worker.FirstName;
workerToEdit.LastName = worker.LastName;
workerToEdit.JMBG = worker.JMBG;
workerToEdit.DateOfBirth = worker.DateOfBirth;
workerToEdit.BankAccount = worker.BankAccount;
workerToEdit.Email = worker.Email;
workerToEdit.Salary = worker.Salary;
workerToEdit.Username = worker.Username;
workerToEdit.Position = worker.Position;
workerToEdit.UserPassword = worker.UserPassword;
workerToEdit.UserID = worker.UserID;
tblUser workerEdit = (from ss in context.tblUsers
where ss.UserID == worker.UserID
select ss).First();
context.SaveChanges();
return(worker);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
