// --------------------------- Personal Plant ---------------------------- #region Personal Plant /// <summary> /// Adds a personal Plant to an account /// </summary> /// <param name="plantID">Plant ID</param> /// <param name="accID">Account ID</param> /// <param name="daysWater">Assigned days between waterings</param> /// <param name="nName">NickName</param> /// <returns>Returns the ID of the new Personal PLant</returns> public int AddPersonalPlant(int plantID, int accID, int daysWater, string nName) { int result = 0; using (plantdb = new LinQtoSQLDataContext(GetConnectionString())) { try { plantdb.LoadOptions = SetDataLoadOptions(TableInUse.PersonalPlant); PersonalPlant pplant = new PersonalPlant { pid = plantID, aid = accID, nname = nName, wduration = daysWater, lastwatered = DateTime.Today, nextwatered = DateTime.Today.AddDays(daysWater) }; plantdb.PersonalPlants.InsertOnSubmit(pplant); plantdb.SubmitChanges(); result = pplant.id; } catch (Exception e) { Console.WriteLine(e.Message); Console.WriteLine(e.StackTrace); result = 0; } } return(result); }
private Model.PersonalPlant ConvertPersonalPlant(PersonalPlant plant) { if (plant != null) { Model.PersonalPlant mPP = new Model.PersonalPlant { Id = plant.id, PId = plant.pid, AId = plant.aid, NName = plant.nname, LastWatered = plant.lastwatered, NextWatered = plant.nextwatered, WDuration = plant.wduration, account = ConvertAccount(plant.Account), plant = ConvertPlant(plant.Plant) }; return(mPP); } else { return(null); } }
public bool UpdatePersonalPlant(int ppID, int daysWater, string nName) { bool result = false; using (plantdb = new LinQtoSQLDataContext(GetConnectionString())) { try { plantdb.LoadOptions = SetDataLoadOptions(TableInUse.PersonalPlant); PersonalPlant pp = plantdb.PersonalPlants.First(e => e.id.Equals(ppID)); pp.wduration = daysWater; pp.nname = nName; plantdb.SubmitChanges(); result = true; } catch (Exception) { result = false; } } return(result); }
/// <summary> /// Find a single personal plant via PersonalPlant ID /// </summary> /// <param name="ppID">PersonalPlant ID</param> /// <returns>Returns the personal plant with the correct PersonalPlantID, /// or it will return null if nothing is find.</returns> public PersonalPlant FindPersonalPlant(int ppID) { PersonalPlant result = null; using (plantdb = new LinQtoSQLDataContext(GetConnectionString())) { try { plantdb.LoadOptions = SetDataLoadOptions(TableInUse.PersonalPlant); PersonalPlant pp = plantdb.PersonalPlants.First(e => e.id.Equals(ppID)); result = new PersonalPlant { id = pp.id, aid = pp.aid, pid = pp.pid, nname = pp.nname, wduration = pp.wduration, lastwatered = pp.lastwatered, nextwatered = pp.nextwatered, Plant = pp.Plant }; } catch (Exception e) { Console.WriteLine(e.Message); Console.WriteLine(e.StackTrace); result = null; } } return(result); }
public bool UpdatePersonalPlantDates(int ppid) { using (plantdb = new LinQtoSQLDataContext(GetConnectionString())) { try { plantdb.LoadOptions = SetDataLoadOptions(TableInUse.PersonalPlant); PersonalPlant pp = plantdb.PersonalPlants.First(e => e.id.Equals(ppid)); pp.lastwatered = DateTime.Now; pp.nextwatered = DateTime.Now.AddDays(pp.wduration); plantdb.SubmitChanges(); return(true); } catch (Exception) { return(false); } } }
/// <summary> /// Removes a PersonalPlant from the PersonalPlant Database /// </summary> /// <param name="ppID">The Personal Plant ID of the plant needed to be</param> /// <returns>Returns a boolean. True if successful, False if not.</returns> public bool RemovePersonalPlant(int ppID) { bool result = false; using (plantdb = new LinQtoSQLDataContext(GetConnectionString())) { try { plantdb.LoadOptions = SetDataLoadOptions(TableInUse.PersonalPlant); PersonalPlant pp = plantdb.PersonalPlants.First(e => e.id.Equals(ppID)); plantdb.PersonalPlants.DeleteOnSubmit(pp); plantdb.SubmitChanges(); result = true; } catch (Exception) { result = false; } } return(result); }
private void detach_PersonalPlants(PersonalPlant entity) { this.SendPropertyChanging(); entity.Account = null; }
partial void DeletePersonalPlant(PersonalPlant instance);
partial void UpdatePersonalPlant(PersonalPlant instance);
partial void InsertPersonalPlant(PersonalPlant instance);
private void attach_PersonalPlants(PersonalPlant entity) { this.SendPropertyChanging(); entity.Plant = this; }