/// <summary>
/// Method to add an clinic
/// </summary>
/// <param name="clinicToAdd"></param>
public void AddClinic(tblClinic clinicToAdd)
{
try
{
using (Nedeljni_IIEntities context = new Nedeljni_IIEntities())
{
tblClinic clinic = new tblClinic
{
ClinicName = clinicToAdd.ClinicName,
DateConstruction = clinicToAdd.DateConstruction,
ClinicOwner = clinicToAdd.ClinicOwner,
Adress = clinicToAdd.Adress,
FloorNumber = clinicToAdd.FloorNumber,
NumberRoomsPerFloor = clinicToAdd.NumberRoomsPerFloor,
Balcony = clinicToAdd.Balcony,
Garden = clinicToAdd.Garden,
AmbulancesParking = clinicToAdd.AmbulancesParking,
InvalidParking = clinicToAdd.InvalidParking,
};
context.tblClinics.Add(clinic);
context.SaveChanges();
clinicToAdd.ClinicID = clinic.ClinicID;
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
/// <summary>
/// Find the administrator by username
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public vwAdministrator FindAdmin(string username)
{
try
{
using (Nedeljni_IIEntities context = new Nedeljni_IIEntities())
{
vwAdministrator admin = (from e in context.vwAdministrators where e.Username == username select e).First();
return(admin);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <vwAdministrator> GetAllAdministratorView()
{
try
{
using (Nedeljni_IIEntities context = new Nedeljni_IIEntities())
{
List <vwAdministrator> list = new List <vwAdministrator>();
list = (from x in context.vwAdministrators select x).ToList();
return(list);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <tblClinic> GetAllClinics()
{
try
{
using (Nedeljni_IIEntities context = new Nedeljni_IIEntities())
{
List <tblClinic> list = new List <tblClinic>();
list = (from x in context.tblClinics select x).ToList();
return(list);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Metod to edit an clinic
/// </summary>
/// <param name="clinic"></param>
/// <returns></returns>
public tblClinic EditClinic(tblClinic clinic)
{
try
{
using (Nedeljni_IIEntities context = new Nedeljni_IIEntities())
{
tblClinic clinicToEdit = context.tblClinics.Where(x => x.ClinicID == clinic.ClinicID).FirstOrDefault();
clinicToEdit.ClinicOwner = clinic.ClinicOwner;
clinicToEdit.AmbulancesParking = clinic.AmbulancesParking;
clinicToEdit.InvalidParking = clinic.InvalidParking;
context.SaveChanges();
return(clinic);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
/// <summary>
/// Method to add an administrator
/// </summary>
/// <param name="administrator"></param>
/// <returns></returns>
public bool AddAdministrator(vwAdministrator administrator)
{
try
{
using (Nedeljni_IIEntities context = new Nedeljni_IIEntities())
{
tblUser user = new tblUser
{
Gender = administrator.Gender,
IdCard = administrator.IdCard,
DateOfBirth = administrator.DateOfBirth,
Citizenship = administrator.Citizenship,
FirstName = administrator.FirstName,
Pasword = SecurePasswordHasher.Hash(administrator.Pasword),
Surname = administrator.Surname,
Username = administrator.Username
};
context.tblUsers.Add(user);
context.SaveChanges();
administrator.UserID = user.UserID;
tblAdministrator newAdministrator = new tblAdministrator
{
UserID = user.UserID,
};
context.tblAdministrators.Add(newAdministrator);
context.SaveChanges();
administrator.AdministratorID = newAdministrator.AdministratorID;
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
/// <summary>
/// Checks if there is user with that username
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public bool IsUser(string username)
{
try
{
using (Nedeljni_IIEntities context = new Nedeljni_IIEntities())
{
vwAdministrator admin = (from e in context.vwAdministrators where e.Username == username select e).First();
if (admin == null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
