protected void Page_Load(object sender, EventArgs e)
{
SetScheduleRequest req;
SetScheduleResponse res = new SetScheduleResponse();
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 Schedule (StoreID, StartOfShift, EndOfShift, EmployeeID, ShiftStatus) VALUES (@StoreID, @StartOfShift, @EndOfShift, @EmployeeID, 1)";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.Add("@StoreID", SqlDbType.Int);
cmd.Parameters.Add("@StartOfShift", SqlDbType.DateTime);
cmd.Parameters.Add("@EndOfShift", SqlDbType.DateTime);
cmd.Parameters.Add("@EmployeeID", SqlDbType.Int);
cmd.Parameters["@StoreID"].Value = req.StoreID;
foreach (Schedule s in req.schedules)
{
cmd.Parameters["@StartOfShift"].Value = s.StartOfShift;
cmd.Parameters["@EndOfShift"].Value = s.EndOfShift;
cmd.Parameters["@EmployeeID"].Value = s.EmployeeID;
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(SetScheduleResponse res)
{
string strJson = JsonConvert.SerializeObject(res);
Response.ContentType = "application/json; charset=utf-8";
Response.AppendHeader("Access-Control-Allow-Origin", "*");
Response.Write(strJson);
Response.End();
}
