public Class UpdateClass(UpdateClassRequest request)
{
Class item = null;
if (request != null && request.Class != null)
{
var dataAccess = new ClassDataAccess(request.Context);
item = dataAccess.Update(request.Class);
}
return(item);
}
public void FixRoomDelete(Guid districtid)
{
District d;
var mcs = "Data Source=yqdubo97gg.database.windows.net;Initial Catalog=ChalkableMaster;UID=chalkableadmin;Pwd=Hellowebapps1!";
using (var uow = new UnitOfWork(mcs, false))
{
var da = new DistrictDataAccess(uow);
d = da.GetById(districtid);
}
var cs = String.Format("Data Source={0};Initial Catalog={1};UID=chalkableadmin;Pwd=Hellowebapps1!", d.ServerUrl, d.Id);
IList <SyncVersion> versions;
using (var uow = new UnitOfWork(cs, true))
{
versions = (new SyncVersionDataAccess(uow)).GetAll();
uow.Commit();
}
var cl = ConnectorLocator.Create("Chalkable", d.SisPassword, d.SisUrl);
var deletedRooms = (cl.SyncConnector.GetDiff(typeof(Room), versions.First(x => x.TableName == "Room").Version) as SyncResult <Room>).Deleted;
using (var uow = new UnitOfWork(cs, true))
{
var da = new ClassDataAccess(uow);
var all = da.GetAll();
var classes = all.Where(x => deletedRooms.Any(y => x.RoomRef == y.RoomID)).ToList();
foreach (var @class in classes)
{
@class.RoomRef = null;
}
da.Update(classes.ToList());
uow.Commit();
}
}
