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