public ActionResult CheckIn(WeightCheckInModel weightCheckInModel) { string userName = User.Identity.Name; AccountModel user = AccountRepository.GetAccount(userName); weightCheckInModel.UserId = user.UserId; WeightRepository.InsertWeightCheckIn(weightCheckInModel); return RedirectToAction("WeightCheckIns"); }
public WeightCheckInModel GetCheckInWeight(int checkInId) { using (Entities entity = new Entities(BaseBISL.ConnectionString)) { var weight = entity.WeightCheckIns.Include("WeightUser").Where(e => e.CheckInID == checkInId).FirstOrDefault(); if (weight != null) { WeightCheckInModel model = new WeightCheckInModel(); model.CheckInId = weight.CheckInID; model.UserId = weight.UserID; model.UserName = weight.WeightUser.UserName; model.Weight = weight.Weight; model.CheckInDate = weight.CheckInDate; return model; } } return null; }
public List<WeightCheckInModel> GetCheckInWeights(int userId) { List<WeightCheckInModel> weightList = new List<WeightCheckInModel>(); using (Entities entity = new Entities(BaseBISL.ConnectionString)) { var weights = entity.WeightCheckIns.Include("WeightUser").Where(e => e.UserID == userId); foreach (var weight in weights) { WeightCheckInModel model = new WeightCheckInModel(); model.CheckInId = weight.CheckInID; model.UserId = weight.UserID; model.UserName = weight.WeightUser.UserName; model.Weight = weight.Weight; model.CheckInDate = weight.CheckInDate; weightList.Add(model); } } return weightList; }
public ActionResult Edit(WeightCheckInModel model) { WeightRepository.UpdateCheckIn(model); return RedirectToAction("WeightCheckIns"); }
public bool InsertWeightCheckIn(WeightCheckInModel model) { using (Entities entity = new Entities(BaseBISL.ConnectionString)) { WeightCheckIn checkIn = new WeightCheckIn(); checkIn.UserID = model.UserId; checkIn.Weight = model.Weight; checkIn.CheckInDate = model.CheckInDate; entity.AddToWeightCheckIns(checkIn); int count = entity.SaveChanges(); if (count > 0) return true; } return false; }
public bool UpdateCheckIn(WeightCheckInModel model) { using (Entities entity = new Entities(BaseBISL.ConnectionString)) { WeightCheckIn checkIn = entity.WeightCheckIns.Where(e => e.CheckInID == model.CheckInId).FirstOrDefault(); if (checkIn != null) { //user.UserName = accountModel.UserName; checkIn.CheckInDate = model.CheckInDate; checkIn.Weight = model.Weight; int count = entity.SaveChanges(); if (count > 0) return true; } } return false; }