public int CreateFacility(global::Ombudsman.Models.Facility facility)
{
Logger.Debug("CreateFacility {0}", facility.Name);
using (var db = new OmbudsmanEntities())
{
var added = new Facility()
{
Address1 = facility.Address1,
Address2 = facility.Address2,
City = facility.City,
FacilityTypeId = facility.FacilityTypeId,
Fax = facility.Fax,
IsActive = facility.IsActive,
IsContinuum = facility.IsContinuum,
IsMedicaid = facility.IsMedicaid,
Name = facility.Name,
NumberOfBeds = facility.NumberOfBeds,
OmbudsmanId = facility.OmbudsmanId,
Phone = facility.Phone,
State = facility.State,
ZipCode = facility.ZipCode
};
db.AddToFacilities(added);
db.SaveChanges();
return added.FacilityId;
}
}
public int CreateOmbudsman(global::Ombudsman.Models.Ombudsman ombudsman)
{
using (var db = new OmbudsmanEntities())
{
var added = new Ombudsman()
{
IsActive = ombudsman.IsActive,
Email = ombudsman.Email,
Address1 = ombudsman.Address1,
Address2 = ombudsman.Address2,
City = ombudsman.City,
Fax = ombudsman.Fax,
Name = ombudsman.Name,
Phone = ombudsman.Phone,
State = ombudsman.State,
ZipCode = ombudsman.ZipCode
};
db.AddToOmbudsmen(added);
db.SaveChanges();
return added.OmbudsmanId;
}
}
public static void MyClassInitialize(TestContext testContext)
{
// set up NLog
var config = new NLog.Config.LoggingConfiguration();
var dt = new NLog.Targets.DebuggerTarget()
{
Layout = "${longdate} ${uppercase:${level}} ${message}",
Name = "t"
};
config.AddTarget("t", dt);
config.LoggingRules.Add(new NLog.Config.LoggingRule("*", NLog.LogLevel.Trace, dt));
NLog.LogManager.Configuration = config;
var logger = NLog.LogManager.GetCurrentClassLogger();
logger.Info("Test starting");
// clear existing test objects,
// create new test objects,
// get IDs of test objects
using (var db = new OmbudsmanEntities())
{
TestData = db.TestInitialize().Single();
}
logger.Info("Facility ID {0}, Ombudsman ID {1}", TestData.Facility1, TestData.Ombudsman1);
}
/// <summary>
/// Return a list of all facilities.
/// </summary>
/// <remarks>No filtering is performed since this is a small (lt 1000 ) set of items.</remarks>
/// <returns>listing of facilities</returns>
public List<global::Ombudsman.Models.Facility> GetFacilities()
{
var facilities = new List<global::Ombudsman.Models.Facility>();
using (var db = new OmbudsmanEntities())
{
// we need to fetch all of them to get the Ombudsman Name
var all = db.Facilities.OrderBy(f => f.Name).AsEnumerable();
facilities.AddRange(all.Select(facility => new global::Ombudsman.Models.Facility()
{
Address1 = facility.Address1,
Address2 = facility.Address2,
City = facility.City,
FacilityId = facility.FacilityId,
FacilityTypeId = facility.FacilityTypeId,
FacilityTypeName = facility.FacilityType.Name,
Fax = facility.Fax,
IsActive = facility.IsActive,
IsContinuum = facility.IsContinuum,
IsMedicaid = facility.IsMedicaid,
Name = facility.Name,
NumberOfBeds = facility.NumberOfBeds,
OmbudsmanId = facility.OmbudsmanId,
OmbudsmanName = GetOmbudsmanNameIf(facility.Ombudsman),
Phone = facility.Phone,
State = facility.State,
ZipCode = facility.ZipCode
}));
}
return facilities;
}
/// <summary>
/// Update ombudsman. ID cannot be updated. User must be a manager to update IsActive.
/// </summary>
/// <param name="ombudsman"></param>
public bool UpdateOmbudsman(global::Ombudsman.Models.Ombudsman ombudsman, bool manager)
{
using (var db = new OmbudsmanEntities())
{
var found = db.Ombudsmen.Single(o => o.OmbudsmanId == ombudsman.OmbudsmanId);
if (!manager && (found.IsActive != ombudsman.IsActive))
{
return false;
}
found.IsActive = ombudsman.IsActive;
found.Email = ombudsman.Email;
found.Address1 = ombudsman.Address1;
found.Address2 = ombudsman.Address2;
found.City = ombudsman.City;
found.Fax = ombudsman.Fax;
found.Name = ombudsman.Name;
found.Phone = ombudsman.Phone;
found.State = ombudsman.State;
found.ZipCode = ombudsman.ZipCode;
db.SaveChanges();
return true;
}
}
/// <summary>
/// Update a Facility. Only a manager can update IsActive.
/// </summary>
/// <param name="facility"></param>
/// <param name="manager"></param>
public bool UpdateFacility(global::Ombudsman.Models.Facility facility, bool manager)
{
using (var db = new OmbudsmanEntities())
{
var found = db.Facilities.Single(f => f.FacilityId == facility.FacilityId);
if (!manager && (found.IsActive != facility.IsActive))
{
return false;
}
found.Address1 = facility.Address1;
found.Address2 = facility.Address2;
found.City = facility.City;
found.FacilityTypeId = facility.FacilityTypeId;
found.Fax = facility.Fax;
found.IsActive = facility.IsActive;
found.IsContinuum = facility.IsContinuum;
found.IsMedicaid = facility.IsMedicaid;
found.Name = facility.Name;
found.NumberOfBeds = facility.NumberOfBeds;
found.OmbudsmanId = facility.OmbudsmanId;
found.Phone = facility.Phone;
found.State = facility.State;
found.ZipCode = facility.ZipCode;
db.SaveChanges();
return true;
}
}
/// <summary>
/// Get a listing of all of the Ombudsman.
/// </summary>
/// <remarks>No filtering is performed since this is a small (lt 1000 ) set of items.</remarks>
/// <returns>listing of ombudsmen</returns>
public List<global::Ombudsman.Models.Ombudsman> GetOmbudsmenByName(string term)
{
var ombudsmen = new List<global::Ombudsman.Models.Ombudsman>();
using (var db = new OmbudsmanEntities())
{
var filtered = db.OmbudsmanNameStartsWith(term);
ombudsmen.AddRange(filtered.Select(omb => new global::Ombudsman.Models.Ombudsman()
{
IsActive = omb.IsActive,
Address1 = omb.Address1,
Address2 = omb.Address2,
City = omb.City,
Fax = omb.Fax,
Name = omb.Name,
OmbudsmanId = omb.OmbudsmanId,
Phone = omb.Phone,
State = omb.State,
ZipCode = omb.ZipCode
}));
}
return ombudsmen;
}
/// <summary>
/// Get a listing of all of the Ombudsman.
/// </summary>
/// <remarks>No filtering is performed since this is a small (lt 1000 ) set of items.</remarks>
/// <returns>listing of ombudsmen</returns>
public List<global::Ombudsman.Models.Ombudsman> GetOmbudsmen()
{
var ombudsmen = new List<global::Ombudsman.Models.Ombudsman>();
using (var db = new OmbudsmanEntities())
{
ombudsmen.AddRange(db.Ombudsmen.OrderBy(f => f.Name).Select(omb => new global::Ombudsman.Models.Ombudsman()
{
IsActive = omb.IsActive,
Address1 = omb.Address1,
Address2 = omb.Address2,
City = omb.City,
Fax = omb.Fax,
Name = omb.Name,
OmbudsmanId = omb.OmbudsmanId,
Phone = omb.Phone,
State = omb.State,
ZipCode = omb.ZipCode
}));
}
return ombudsmen;
}
public int? GetOmbudsmanIdFromName(string name)
{
using (var db = new OmbudsmanEntities())
{
var found = db.Ombudsmen.SingleOrDefault(o => o.Name == name);
if (found != null)
{
return found.OmbudsmanId;
}
return null;
}
}
public global::Ombudsman.Models.Ombudsman GetOmbudsman(int id)
{
using (var db = new OmbudsmanEntities())
{
var ombudsman = db.Ombudsmen.FirstOrDefault(o => o.OmbudsmanId == id);
if (ombudsman == null)
{
return null;
}
var found = new global::Ombudsman.Models.Ombudsman()
{
IsActive = ombudsman.IsActive,
Email = ombudsman.Email,
Address1 = ombudsman.Address1,
Address2 = ombudsman.Address2,
City = ombudsman.City,
Fax = ombudsman.Fax,
Name = ombudsman.Name,
OmbudsmanId = ombudsman.OmbudsmanId,
Phone = ombudsman.Phone,
State = ombudsman.State,
ZipCode = ombudsman.ZipCode
};
return found;
}
}
public List<global::Ombudsman.Models.FacilityType> GetFacilityTypes()
{
var types = new List<global::Ombudsman.Models.FacilityType>();
using (var db = new OmbudsmanEntities())
{
// we need to fetch all of them to get the Ombudsman Name
types.AddRange(db.FacilityTypes.Select(ft => new global::Ombudsman.Models.FacilityType()
{
FacilityTypeId = ft.FacilityTypeId,
Name = ft.Name
}));
}
return types;
}
public global::Ombudsman.Models.Facility GetFacility(int id)
{
using (var db = new OmbudsmanEntities())
{
var facility = db.Facilities.Where(f => f.FacilityId == id).Single();
var found = new global::Ombudsman.Models.Facility()
{
Address1 = facility.Address1,
Address2 = facility.Address2,
City = facility.City,
FacilityId = facility.FacilityId,
FacilityTypeId = facility.FacilityTypeId,
FacilityTypeName = facility.FacilityType.Name,
Fax = facility.Fax,
IsActive = facility.IsActive,
IsContinuum = facility.IsContinuum,
IsMedicaid = facility.IsMedicaid,
Name = facility.Name,
NumberOfBeds = facility.NumberOfBeds,
OmbudsmanId = facility.OmbudsmanId,
OmbudsmanName = GetOmbudsmanNameIf(facility.Ombudsman),
Phone = facility.Phone,
State = facility.State,
ZipCode = facility.ZipCode
};
return found;
}
}
