/// <summary>
/// Delete a single product
/// </summary>
/// <param name="dc"></param>
/// <param name="product"></param>
public void Delete(DataContext dc, Domain.Product product)
{
dc = dc ?? Conn.GetContext();
var dbProduct = dc.Products.Where(p => p.ProductID == product.ID).SingleOrDefault();
if (dbProduct == null) return;
dc.Products.Attach(dbProduct, true);
dc.Products.DeleteOnSubmit(dbProduct);
dc.SubmitChanges();
}
/// <summary>
/// Delete a single TaskRepository
/// </summary>
/// <param name="dc">DataContext</param>
/// <param name="task"></param>
public void Delete(DataContext dc, Domain.Task task)
{
dc = dc ?? Conn.GetContext();
var dbTask = dc.Tasks.Where(t => t.TaskID == task.ID).SingleOrDefault();
if (dbTask == null) return;
//dc.Tasks.Attach(dbTask, true);
dc.Tasks.DeleteOnSubmit(dbTask);
dc.SubmitChanges();
}
/// <summary>
/// Delete a single TaskType
/// </summary>
/// <param name="dc">DataContext</param>
/// <param name="taskType"></param>
public void Delete(DataContext dc, Domain.TaskType taskType)
{
dc = dc ?? Conn.GetContext();
var dbTaskType = dc.TaskTypes.Where(t => t.TaskTypeId == taskType.ID).SingleOrDefault();
if (dbTaskType == null) return;
dc.TaskTypes.Attach(dbTaskType, true);
dc.TaskTypes.DeleteOnSubmit(dbTaskType);
dc.SubmitChanges();
}
/// <summary>
/// Delete a single greenhouse
/// </summary>
/// <param name="dc"></param>
/// <param name="greenhouse"></param>
public void Delete(DataContext dc, Domain.Greenhouse greenhouse)
{
dc = dc ?? Conn.GetContext();
var dbGreenhouse = dc.Greenhouses.Where(g => g.GreenhouseID == greenhouse.ID).SingleOrDefault();
if (dbGreenhouse == null) return;
dc.GreenhouseUsers.DeleteAllOnSubmit(dbGreenhouse.GreenhouseUsers);
foreach (var section in dbGreenhouse.Sections) { dc.Tasks.DeleteAllOnSubmit(section.Tasks); }
dc.Sections.DeleteAllOnSubmit(dbGreenhouse.Sections);
dc.Greenhouses.DeleteOnSubmit(dbGreenhouse);
dc.SubmitChanges();
}
/// <summary>
/// Delete a single
/// </summary>
/// <param name="dc"></param>
/// <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;
foreach (var task in dbSection.Tasks)
{
dc.Tasks.DeleteOnSubmit(task);
}
dc.Sections.DeleteOnSubmit(dbSection);
dc.SubmitChanges();
}
public void Delete(DataContext dc, Domain.GreenhouseUser greenhouseUser)
{
dc = dc ?? Conn.GetContext();
var dbGreenhouseUser = dc.GreenhouseUsers.Where(g => g.GreenhouseUserId == greenhouseUser.ID).SingleOrDefault();
if (dbGreenhouseUser == null) return;
foreach (var section in dbGreenhouseUser.Greenhouse.Sections.Where(gu => gu.UserID == dbGreenhouseUser.UserId))
{
dc.Sections.DeleteOnSubmit(section);
foreach (var task in section.Tasks)
{
dc.Tasks.DeleteOnSubmit(task);
}
}
dc.GreenhouseUsers.DeleteOnSubmit(dbGreenhouseUser);
dc.SubmitChanges();
}
public int Save(DataContext dc, Domain.GreenhouseUser greenhouseUser)
{
dc = dc ?? Conn.GetContext();
var dbGreenhouseUser = dc.GreenhouseUsers.Where(g => g.GreenhouseUserId == greenhouseUser.ID).SingleOrDefault();
var isNew = false;
if (dbGreenhouseUser == null)
{
dbGreenhouseUser = new GreenhouseUser();
isNew = true;
}
dbGreenhouseUser.UserId = greenhouseUser.UserID;
dbGreenhouseUser.GreenhouseId = greenhouseUser.GreenhouseID;
if (isNew)
{
dc.GreenhouseUsers.InsertOnSubmit(dbGreenhouseUser);
}
dc.SubmitChanges();
greenhouseUser.ID = dbGreenhouseUser.GreenhouseId;
return greenhouseUser.ID;
}
/// <summary>
/// Save a Product
/// </summary>
/// <param name="dc"></param>
/// <param name="product"></param>
/// <returns>returns the id of the saved product</returns>
public int Save(DataContext dc, Domain.Product product)
{
dc = dc ?? Conn.GetContext();
var dbProduct = dc.Products.Where(p => p.ProductID == product.ID).SingleOrDefault();
var isNew = false;
if (dbProduct == null)
{
dbProduct = new Product();
isNew = true;
}
dbProduct.Name = product.Name;
dbProduct.Description = product.Description;
dbProduct.Price = product.Price;
dbProduct.IsActive = product.IsActive;
dbProduct.Image = product.Image;
dbProduct.DateUpdated = DateTime.Now;
if (isNew)
{
dbProduct.DateCreated = DateTime.Now;
dc.Products.InsertOnSubmit(dbProduct);
}
dc.SubmitChanges();
return dbProduct.ProductID;
}
/// <summary>
/// Save a TaskRepository
/// </summary>
/// <param name="dc">DataContext</param>
/// <param name="task"></param>
/// <returns>returns the id of the saved task</returns>
public int Save(DataContext dc, Domain.Task task)
{
dc = dc ?? Conn.GetContext();
var dbTask = dc.Tasks.Where(t => t.TaskID == task.ID).SingleOrDefault();
var isNew = false;
if (dbTask == null)
{
dbTask = new DataAccess.SqlRepository.Task();
isNew = true;
}
dbTask.SectionID = task.SectionID;
dbTask.StartTime = task.StartTime;
dbTask.EndTime = task.StartTime.AddMinutes(task.Interval);
dbTask.TaskTypeID = task.TaskTypeId;
dbTask.DateUpdated = DateTime.Now;
if (isNew)
{
dbTask.DateCreated = DateTime.Now;
dc.Tasks.InsertOnSubmit(dbTask);
}
dc.SubmitChanges();
return dbTask.TaskID;
}
/// <summary>
/// Save a Preset
/// </summary>
/// <param name="dc">DataContext</param>
/// <param name="preset"></param>
/// <returns>returns the id of the saved preset</returns>
public int Save(DataContext dc, Domain.Preset preset)
{
dc = dc ?? Conn.GetContext();
var dbPreset = dc.Presets.Where(p => p.PresetID == preset.ID).SingleOrDefault();
var isNew = false;
if (dbPreset == null)
{
dbPreset = new Preset();
isNew = true;
}
dbPreset.Name = preset.Name;
dbPreset.UserID = preset.UserID;
dbPreset.IdealTemperature = preset.IdealTemperature;
dbPreset.TemperatureThreshold = preset.TemperatureThreshold;
dbPreset.IdealLightIntensity = preset.IdealLightIntensity;
dbPreset.LightIntensityThreshold = preset.LightIntensityThreshold;
dbPreset.IdealHumidity = preset.IdealHumidity;
dbPreset.HumidityThreshold = preset.HumidityThreshold;
dbPreset.IdealWaterLevel = preset.IdealWaterLevel;
dbPreset.WaterLevelThreshold = preset.WaterLevelThreshold;
dbPreset.IsGlobal = preset.IsGlobal;
dbPreset.DateUpdated = DateTime.Now;
if (isNew)
{
dbPreset.DateCreated = DateTime.Now;
dc.Presets.InsertOnSubmit(dbPreset);
}
dc.SubmitChanges();
return dbPreset.PresetID;
}
/// <summary>
/// Save a Greenhouse
/// </summary>
/// <param name="dc"></param>
/// <param name="greenhouse"></param>
/// <returns>returns the id of the saved greenhouse</returns>
public int Save(DataContext dc, Domain.Greenhouse greenhouse)
{
dc = dc ?? Conn.GetContext();
var dbGreenhouse = dc.Greenhouses.Where(g => g.GreenhouseID == greenhouse.ID).SingleOrDefault();
var isNew = false;
if (dbGreenhouse == null)
{
dbGreenhouse = new DataAccess.SqlRepository.Greenhouse();
isNew = true;
}
dbGreenhouse.City = greenhouse.Address.City;
dbGreenhouse.Country = greenhouse.Address.Country;
dbGreenhouse.StateOrProvince = greenhouse.Address.StateOrProvince;
dbGreenhouse.Zip = greenhouse.Address.Zip;
dbGreenhouse.StreetLine1 = greenhouse.Address.StreetLine1;
dbGreenhouse.StreetLine2 = greenhouse.Address.StreetLine2;
dbGreenhouse.IsDefault = greenhouse.Address.IsDefault;
dbGreenhouse.DateUpdated = DateTime.Now;
if (isNew)
{
dbGreenhouse.DateCreated = DateTime.Now;
dc.Greenhouses.InsertOnSubmit(dbGreenhouse);
}
dc.SubmitChanges();
greenhouse.ID = dbGreenhouse.GreenhouseID;
if (greenhouse.Sections != null)
foreach (Section section in greenhouse.Sections)
{
section.Save();
}
return greenhouse.ID;
}
/// <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.IsTemeratureActivated = 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;
}
/// <summary>
/// Save a TaskType
/// </summary>
/// <param name="dc">DataContext</param>
/// <param name="taskType"></param>
/// <returns>returns the id of the saved taskType</returns>
public int Save(DataContext dc, Domain.TaskType taskType)
{
dc = dc ?? Conn.GetContext();
var dcTaskType = dc.TaskTypes.Where(t => t.TaskTypeId == taskType.ID).SingleOrDefault();
var isNew = false;
if (dcTaskType == null)
{
dcTaskType = new DataAccess.SqlRepository.TaskType();
isNew = true;
}
dcTaskType.Name = taskType.Name;
if (isNew)
{
dc.TaskTypes.InsertOnSubmit(dcTaskType);
}
dc.SubmitChanges();
return dcTaskType.TaskTypeId;
}