public static tblManager AddManager(tblManager manager)
{
try
{
using (dbHotelEntities context = new dbHotelEntities())
{
if (manager.managerId == 0)
{
//add
tblManager newManager = new tblManager();
newManager.name = "manager";
newManager.userId = manager.userId;
newManager.floorNumber = manager.floorNumber;
newManager.workExperience = manager.workExperience;
newManager.qualificationId = manager.qualificationId;
context.tblManagers.Add(newManager);
context.SaveChanges();
manager.managerId = newManager.managerId;
return(manager);
}
return(manager);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString());
return(null);
}
}
public static tblManager getManager(int userId)
{
try
{
using (dbHotelEntities context = new dbHotelEntities())
{
tblManager res = (from x in context.tblManagers where x.userId == userId select x).FirstOrDefault();
return(res);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception " + ex.Message.ToString());
return(null);
}
}