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;
}
