public static tblStaff AddStaff(tblStaff staff)
{
try
{
using (dbHotelEntities context = new dbHotelEntities())
{
if (staff.staffId == 0)
{
//add
tblStaff newStaff = new tblStaff();
newStaff.userId = staff.userId;
newStaff.citizenship = staff.citizenship;
newStaff.floorNumber = staff.floorNumber;
newStaff.engegamentId = staff.engegamentId;
newStaff.genderId = staff.genderId;
context.tblStaffs.Add(newStaff);
context.SaveChanges();
staff.staffId = newStaff.staffId;
return(staff);
}
else
{
tblStaff staffToEdit = (from x in context.tblStaffs where x.staffId == staff.staffId select x).FirstOrDefault();
staffToEdit.salary = staff.salary;
context.SaveChanges();
return(staff);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
public static tblStaff getStaff(int userId)
{
try
{
using (dbHotelEntities context = new dbHotelEntities())
{
tblStaff res = (from x in context.tblStaffs where x.userId == userId select x).FirstOrDefault();
return(res);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return(null);
}
}
public static string GetRole(int id)
{
try
{
using (dbHotelEntities context = new dbHotelEntities())
{
tblStaff res = (from x in context.tblStaffs where x.userId == id select x).FirstOrDefault();
if (res != null)
{
return("staff");
}
else
{
return("manager");
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return(null);
}
}