//public bool EnterFishOld(string username, Models.FishModels.Fish fish) //{ // try // { // DateTime date = new DateTime(); // date = DateTime.Now; // FishDB.EnterFish(999999, // username, fish.strSpecies, fish.strLocationName, fish.decLengthInches, fish.decWeightLbs, fish.decWaterLevel, fish.decLatitude, fish.decLongitude); // //todo fix this username =999999...not even sure wtf this is. probably from before I added userId to the user DB. Will need to get MY UserID (the int), from DB and // // save to Session for use here and other places I want userID // return true; // } // catch (Exception ex) // { // error.logError(ex.Message, ex.Source, ex.StackTrace, "Enter Fish", "DatabaseClass", "EnterFish", HttpContext.Current.User.Identity.Name, null); // return false; // } //} public bool EnterFish(Models.FishModels.Fish fish) { try { string Id = GetId(); DateTime dtEntered = new DateTime(); dtEntered = DateTime.Now; //DateTime dtCaught = //TODO: give user option to manually enter datetime caught //dateCaught FishDB.spEnterFish(Id, fish.FishID, fish.strSpecies, dtEntered, dtEntered, fish.decLengthInches, fish.decWeightLbs); //todo fix this username =999999...not even sure wtf this is. probably from before I added userId to the user DB. Will need to get MY UserID (the int), from DB and // save to Session for use here and other places I want userID //todo: fix dateCaught Parameter. Allow user to change that when entering a fish. It shouldnt always be set to DateEntered // add images foreach (FishModels.FishImage image in fish.images) { // when you write the images to DB the first time, save them to the session. // then when you get here and you have a fishID, come back and update them with fishID. // you will need ot change spEnterFish so it returns the fishID } return(true); } catch (Exception ex) { error.logError(ex.Message, ex.Source, ex.StackTrace, "Enter Fish", "DatabaseClass", "EnterFish", HttpContext.Current.User.Identity.Name, null); return(false); } }
public List <Models.FishModels.Fish> GetFishByUsername(string username) { try { List <Models.FishModels.Fish> fishlst = new List <Models.FishModels.Fish>(); var lst = FishDB.spGetFishByUser(username).ToList(); foreach (var a in lst) { Models.FishModels.Fish f = new Models.FishModels.Fish(); f.strSpecies = a.strSpecies; f.strLocationName = a.strLocationName; f.dteDateTimeEntered = Convert.ToDateTime(a.dteTimeEntered); f.decLengthInches = a.decLengthInches; f.decWeightLbs = a.decWeightLbs; f.decWaterLevel = a.decWaterLevel; f.decLatitude = a.decLatitude; f.decLongitude = a.decLongitude; fishlst.Add(f); } return(fishlst); } catch (Exception ex) { error.logError(ex.Message, ex.Source, ex.StackTrace, "Enter Fish", "DatabaseClass", "getFishByUsername", HttpContext.Current.User.Identity.Name, null); return(null); } }