public JsonResult LoadEmployee()
{
client.DefaultRequestHeaders.Add("Authorization", HttpContext.Session.GetString("JWToken"));
EmployeeJson data = null;
var responseTask = client.GetAsync("Employee");
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var json = JsonConvert.DeserializeObject(result.Content.ReadAsStringAsync().Result).ToString();
data = JsonConvert.DeserializeObject <EmployeeJson>(json);
}
else
{
ModelState.AddModelError(string.Empty, "Sorry Server Error, Try Again");
}
return(Json(data));
}
public void ConnectToSql()
{
conn = new SqlConnection("server=sutterdb.cdnagtbeyki3.us-west-2.rds.amazonaws.com,1433; database=SutterDB;user id=sutterdbadmin;password=M6)wo697s*W");
conn.Open();
if (conn.State == ConnectionState.Open)
{
string scheduleStatement =
connectionStatus = "Connection OK";
SqlCommand selectCommand = new SqlCommand("SELECT Emp_First_Name FROM Employees", conn);
SqlCommand countCommand = new SqlCommand("SELECT COUNT(*) From Employees", conn);
SqlCommand scheduleCommand = new SqlCommand("SELECT Schedule_Line_ID, Master_Schedule_Schedule_ID, Shift_Start, End_Shift, Emp_First_Name FROM Schedule_Lines, Master_Schedule, Employees where Schedule_ID = Master_Schedule_Schedule_ID and Emp_ID=Employees_Emp_ID order by Master_Schedule_Schedule_ID", conn);
SqlCommand scheduleCountCommand = new SqlCommand("SELECT COUNT(*) FROM Schedule_Lines, Master_Schedule", conn);
int count = (int)countCommand.ExecuteScalar();
int scheduleCount = (int)scheduleCountCommand.ExecuteScalar();
employee = new Employee[count];
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
int i = 0;
while (reader.HasRows)
{
while (reader.Read())
{
employee[i] = new Employee();
employee[i].Emp_First_Name = reader.GetString(0);
i++;
}
reader.NextResult();
}
}
using (SqlDataReader scheduleReader = scheduleCommand.ExecuteReader())
{
int i = 0;
while (scheduleReader.HasRows)
{
while (scheduleReader.Read())
{
schedule[i] = new Schedule_Lines();
schedule[i].Schedule_ID = scheduleReader.GetInt32(0);
schedule[i].Exception_ID = scheduleReader.GetInt32(1);
schedule[i].Shift_Start = scheduleReader.GetDateTime(2);
schedule[i].End_Shift = scheduleReader.GetDateTime(3);
i++;
}
scheduleReader.NextResult();
}
}
ScheduleJSon[] theSchedule = new ScheduleJSon[scheduleCount];
scheduleList = new List <ScheduleJSon>();
for (int i = 0; i <= scheduleCount - 1; i++)
{
theSchedule[i].id = schedule[i].Schedule_ID;
theSchedule[i].resourceID = schedule[i].Exception_ID;
theSchedule[i].start = String.Format("{0:s}", schedule[i].Shift_Start);
theSchedule[i].end = String.Format("{0:s}", schedule[i].End_Shift);
theSchedule[i].title = "test";
scheduleList.Add(theSchedule[i]);
}
EmployeeJson[] testEmployee = new EmployeeJson[count];
employeeList = new List <EmployeeJson>();
for (int i = 0; i <= count - 1; i++)
{
testEmployee[i] = new EmployeeJson();
testEmployee[i].id = i;
testEmployee[i].title = employee[i].Emp_First_Name;
employeeList.Add(testEmployee[i]);
}
jsonString = JsonConvert.SerializeObject(employeeList, Formatting.Indented);
scheduleJsonString = JsonConvert.SerializeObject(scheduleList, Formatting.Indented);
conn.Close();
}
else
{
connectionStatus = "Connection not ok";
}
}
