public static JArray parseJsonTaskLines(string result) { JArray conversion = null; try { var jObject2 = JObject.Parse(result); //dynamic json = JValue.Parse(result.ToString()); //conversion = (JArray)json.value; JArray items = (JArray)jObject2["value"]; for (int i = 0; i < items.Count; i++) { TaskMaster obj = new TaskMaster(); obj.JobNo = (string)jObject2["value"][i]["Job_No"]; obj.Project_Number = (string)jObject2["value"][i]["Job_Task_No"]; obj.TaskName = (string)jObject2["value"][i]["Description"]; SyncTasks.InsertTaskLines(obj); } } catch (Exception e) { } return(conversion); }
public static int InsertTaskLines(TaskMaster obj) { DBHelper DBConn = new DBHelper(); DataTable dt; SqlParameter[] sqlparam; sqlparam = new SqlParameter[4]; sqlparam[0] = new SqlParameter("@id", '0'); sqlparam[1] = new SqlParameter("@JobNo", obj.JobNo); sqlparam[2] = new SqlParameter("@Project_Number", obj.Project_Number); sqlparam[3] = new SqlParameter("@TaskName", obj.TaskName); int a = DBConn.Save("InsertTaskLines", sqlparam, ""); return(a); }