public OrderController(SessionApplication appSession, OrderApplication appOrder, FoodApplication appFood, MovieApplication appMovie)
{
_appSession = appSession;
_appOrder = appOrder;
_appFood = appFood;
_appMovie = appMovie;
}
private static Application GenerateSessionApplication(FormCollection collection)
{
SessionApplication toReturn = new SessionApplication();
toReturn.SessionStartTime = Convert.ToDateTime(collection["service_day"]);
toReturn.SessionStartTime = toReturn.SessionStartTime.AddHours(
Convert.ToInt32(collection["start_time"].Split(':')[0])
);
toReturn.SessionStartTime = toReturn.SessionStartTime.AddMinutes(
Convert.ToInt32(collection["start_time"].Split(':')[1])
);
return(toReturn);
}
public HttpResponseMessage Post([FromBody] Application application)
{
DeadlineApplication deadlineApp = application as DeadlineApplication;
SessionApplication sessionApp = application as SessionApplication;
using (SqlConnection connection = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["DBCS"].ConnectionString))
{
string cmdString = "INSERT INTO Applications VALUES(@ServiceId, @ServiceType, @Description, @Username, @DetailsId, @Status, GETDATE(), NULL, NULL);";
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@ServiceId", application.ServiceId);
parameters.Add("@ServiceType", application.ServiceType);
parameters.Add("@Description", application.Description);
parameters.Add("@Username", User.Identity.Name);
parameters.Add("@Status", "NO_BILL");
if (deadlineApp != null)
{
if (deadlineApp.StartTime.Year < 1753)
{
deadlineApp.StartTime = new DateTime(1900, 1, 1);
}
if (deadlineApp.EndTime.Year < 1753)
{
deadlineApp.EndTime = new DateTime(1900, 1, 1);
}
cmdString = cmdString.Replace("@DetailsId", "IDENT_CURRENT('Deadline_Application_Details') + 1");
cmdString += "INSERT INTO Deadline_Application_Details VALUES(@HasLastDate, @StartTime, @EndTime, @Duration);";
parameters.Add("@HasLastDate", deadlineApp.HasLastDate);
parameters.Add("@StartTime", deadlineApp.StartTime);
parameters.Add("@EndTime", deadlineApp.EndTime);
parameters.Add("@Duration", JsonConvert.SerializeObject(deadlineApp.Duration));
}
else if (sessionApp != null)
{
cmdString = cmdString.Replace("@DetailsId", "IDENT_CURRENT('Session_Application_Details') + 1");
cmdString += "INSERT INTO Session_Application_Details VALUES (@SessionStart);";
parameters.Add("@SessionStart", sessionApp.SessionStartTime);
}
else
{
cmdString = cmdString.Replace("@DetailsId", "0");
}
SqlCommand cmd = new SqlCommand(cmdString, connection);
foreach (var parameter in parameters)
{
cmd.Parameters.AddWithValue(parameter.Key, parameter.Value);
}
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
cmd.Transaction = transaction;
try
{
cmd.ExecuteNonQuery();
transaction.Commit();
return(Request.CreateResponse(HttpStatusCode.OK, "Application successfully added"));
}
catch (Exception ex)
{
transaction.Rollback();
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
}
public Session CreateSession([FromBody] SessionApplication application)
{
var session = _sessionsService.CreateSession(application.SessionName, application.MasterName);
return(session);
}
public SessionController(SessionApplication appSession, MovieApplication appMovie, RoomApplication appRoom)
{
_appSession = appSession;
_appRoom = appRoom;
_appMovie = appMovie;
}
