protected void Page_Load(object sender, EventArgs e)
{
SetAvailabilityRequest req;
SetAvailabilityResponse res = new SetAvailabilityResponse();
res.error = String.Empty;
// 1. Deserialize the incoming Json.
try
{
req = GetRequestInfo();
}
catch (Exception ex)
{
res.error = ex.Message.ToString();
// Return the results as Json.
SendResultInfoAsJson(res);
return;
}
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
try
{
connection.Open();
string sql = "INSERT INTO AvailabilityTbl (EmployeeID, DayOfWeek, StartTime, EndTime, Status) VALUES (@EmployeeID, @DayOfWeek, @StartTime, @EndTime, 0)";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.Add("@EmployeeID", SqlDbType.Int);
cmd.Parameters.Add("@DayOfWeek", SqlDbType.Int);
cmd.Parameters.Add("@StartTime", SqlDbType.DateTime);
cmd.Parameters.Add("@EndTime", SqlDbType.DateTime);
cmd.Parameters["@EmployeeID"].Value = req.EmployeeID;
foreach (Availability a in req.days)
{
cmd.Parameters["@DayOfWeek"].Value = a.Day;
cmd.Parameters["@StartTime"].Value = a.StartTime;
cmd.Parameters["@EndTime"].Value = a.EndTime;
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
res.error = ex.Message.ToString();
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
// Return the results as Json.
SendResultInfoAsJson(res);
}
void SendResultInfoAsJson(SetAvailabilityResponse res)
{
string strJson = JsonConvert.SerializeObject(res);
Response.ContentType = "application/json; charset=utf-8";
Response.Write(strJson);
Response.End();
}
void SendResultInfoAsJson(SetAvailabilityResponse res)
{
string strJson = JsonConvert.SerializeObject(res);
Response.ContentType = "application/json; charset=utf-8";
Response.AppendHeader("Access-Control-Allow-Origin", "*");
Response.Write(strJson);
Response.End();
}
