/// <summary>
/// Delete a single
/// </summary>
/// <param name="section"></param>
public void Delete(DataContext dc, Domain.Section section)
{
dc = dc ?? Conn.GetContext();
var dbSection = dc.Sections.Where(s => s.SectionID == section.ID).SingleOrDefault();
if (dbSection == null)
{
return;
}
//dc.Sections.Attach(dbSection, true);
foreach (var task in dbSection.Tasks)
{
dc.Tasks.DeleteOnSubmit(task);
}
dc.Sections.DeleteOnSubmit(dbSection);
dc.SubmitChanges();
}
/// <summary>
/// Save a Section
/// </summary>
/// <param name="dc"></param>
/// <param name="section"></param>
/// <returns>returns the id of the saved section</returns>
public int Save(DataContext dc, Domain.Section section)
{
dc = dc ?? Conn.GetContext();
var dbSection = dc.Sections.Where(s => s.SectionID == section.ID).SingleOrDefault();
var isNew = false;
if (dbSection == null)
{
dbSection = new DataAccess.SqlRepository.Section();
isNew = true;
}
dbSection.Name = section.Name;
dbSection.GreenhouseID = section.GreenhouseID;
dbSection.PresetID = section.PresetID;
dbSection.UserID = section.UserID;
dbSection.IsTemperatureActivated = section.IsTemperatureActivated;
dbSection.IdealTemperature = section.IdealTemperature;
dbSection.TemperatureThreshold = section.TemperatureThreshold;
dbSection.IsLightActivated = section.IsLightActivated;
dbSection.IdealLightIntensity = section.IdealLightIntensity;
dbSection.LightIntensityThreshold = section.LightIntensityThreshold;
dbSection.IsHumidityActivated = section.IsHumidityActivated;
dbSection.IdealHumidity = section.IdealHumidity;
dbSection.HumidityThreshold = section.HumidityThreshold;
dbSection.IsWaterLevelActivated = section.IsWaterLevelActivated;
dbSection.IdealWaterLevel = section.IdealWaterLevel;
dbSection.WaterLevelThreshold = section.WaterLevelThreshold;
dbSection.DateUpdated = DateTime.Now;
if (isNew)
{
dbSection.DateCreated = DateTime.Now;
dc.Sections.InsertOnSubmit(dbSection);
}
dc.SubmitChanges();
return(dbSection.SectionID);
}