public bool SaveChangesToDB(Controller c, weightlogEntities db, object[] records, bool isEdit = false) { try { foreach (object record in records) { Type recordType = record.GetType(); if (isEdit) { db.Entry(record).State = EntityState.Modified; } DbSet dbSet = db.Set(record.GetType()); if (!isEdit) { dbSet.Add(record); } } db.SaveChanges(); c.TempData["RecordSaved"] = "Success"; return(true); } catch (Exception e) { c.TempData["RecordSaved"] = "Failed"; return(false); } }
public static weight_list GetWeightRecord(string dateString, weightlogEntities db = null) { DateTime record_date = DateTime.Parse(dateString); if (db == null) { db = new weightlogEntities(); } var weight_list = db.weight_list.AsQueryable().ToList() .Where(wl => wl.record_date == record_date); weight_list weight_list_original = null; if (weight_list != null && weight_list.Count() > 0) { weight_list_original = weight_list.ToArray()[0]; } return(weight_list_original); }