public Object SendWeekData(string data) { Newtonsoft.Json.Linq.JArray jArray = (Newtonsoft.Json.Linq.JArray)JsonConvert.DeserializeObject(data); List<Activity> listData = jArray.ToObject<List<Activity>>(); List<ReturnData> returnData = new List<ReturnData>(); //Save to DB///////////// foreach (Activity element in listData) { ReturnData rData = new ReturnData { ActivityId = element.ActivityId, Status = "error" }; try { using (DataBaseContext db = new DataBaseContext()) { Activity activity = db.Activity.SingleOrDefault(t => t.ActivityId == element.ActivityId); if (activity != null) { activity.ActivityName = element.ActivityName; activity.Mo = element.Mo; activity.Tu = element.Tu; activity.We = element.We; activity.Th = element.Th; activity.Fr = element.Fr; activity.Sa = element.Sa; activity.Su = element.Su; db.SaveChanges(); } else { using (SqlConnection connection = new SqlConnection(@"Data Source = ECSC001034F5.epam.com\sqlexpress; UID = sa; PASSWORD = Nopassw2015; Initial Catalog = TimeDataBase;")) { connection.Open(); string sql = "INSERT INTO Activity(ActivityId,ActivityName) VALUES("+element.ActivityId+",'"+element.ActivityName+"')"; SqlCommand cmd = new SqlCommand(sql, connection); cmd.ExecuteNonQuery(); } //db.Activity.Add(element); } } rData.Status = "success"; } catch (Exception e){ } returnData.Add(rData); } ///////////////// return JsonConvert.SerializeObject(returnData); }
public Object GetWeekData() { List<Activity> listActivity = new List<Activity>(); using (DataBaseContext db = new DataBaseContext()) { listActivity = db.Set<Activity>().ToList(); } var returnData = JsonConvert.SerializeObject(listActivity); return returnData; }