public HttpResponseMessage DeleteTrack(int itemId, int codeCampId)
{
try
{
var sessions = SessionDataAccess.GetItemsByTrackId(itemId, codeCampId);
if (sessions.Any())
{
foreach (var session in sessions)
{
session.TrackId = null;
session.LastUpdatedByDate = DateTime.Now;
session.LastUpdatedByUserId = UserInfo.UserID;
SessionDataAccess.UpdateItem(session);
}
}
TrackDataAccess.DeleteItem(itemId, codeCampId);
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage GetRoomByTrackId(int trackId, int codeCampId)
{
try
{
RoomInfo room = null;
var track = TrackDataAccess.GetItems(codeCampId).Where(t => t.TrackId == trackId).FirstOrDefault();
if (track != null)
{
room = RoomDataAccess.GetItem(track.RoomId.Value, codeCampId);
}
var response = new ServiceResponse <RoomInfo> {
Content = room
};
if (room == null)
{
ServiceResponseHelper <RoomInfo> .AddNoneFoundError("rooms", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage CreateTrack(TrackInfo track)
{
try
{
var timeStamp = DateTime.Now;
track.CreatedByDate = timeStamp;
track.CreatedByUserId = UserInfo.UserID;
track.LastUpdatedByDate = timeStamp;
track.LastUpdatedByUserId = UserInfo.UserID;
TrackDataAccess.CreateItem(track);
var tracks = TrackDataAccess.GetItems(track.CodeCampId);
var savedTrack = tracks.OrderByDescending(s => s.CreatedByDate).FirstOrDefault(s => s.Title == track.Title);
var response = new ServiceResponse <TrackInfo> {
Content = savedTrack
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage UnassignRoomFromTrack(int roomId, int trackId, int codeCampId)
{
try
{
var track = TrackDataAccess.GetItem(trackId, codeCampId);
if (track != null)
{
track.RoomId = null;
track.LastUpdatedByDate = DateTime.Now;
track.LastUpdatedByUserId = UserInfo.UserID;
TrackDataAccess.UpdateItem(track);
}
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
if (track == null)
{
ServiceResponseHelper <string> .AddNoneFoundError("track", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage DeleteRoom(int itemId, int codeCampId)
{
try
{
var tracks = TrackDataAccess.GetItems(codeCampId).Where(t => t.RoomId == itemId);
if (tracks.Any())
{
foreach (var track in tracks)
{
track.RoomId = null;
track.LastUpdatedByDate = DateTime.Now;
track.LastUpdatedByUserId = UserInfo.UserID;
TrackDataAccess.UpdateItem(track);
}
}
RoomDataAccess.DeleteItem(itemId, codeCampId);
var response = new ServiceResponse <string> {
Content = SUCCESS_MESSAGE
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
/// <summary>
/// DataGridViewForm - display all client event for mailing
/// </summary>
/// <param name="mainForm"></param>
/// <param name="clientEventsList"></param>
public DataGridViewForm(MainForm mainForm, List <ClientEventModel> clientEventsList)
{
InitializeComponent();
DataGridView dataGridView = dgvData;
DataTable dataTable = ToDataTable(clientEventsList);
foreach (DataRow row in dataTable.Rows)
{
if (row["ClientId"] != null)
{
ClientModel clientModel = ClientDataAccess.LoadClient((int)row["ClientId"]);
row["ClientName"] = clientModel.Name;
}
if (row["TrackId"] != null)
{
TrackModel trackModel = TrackDataAccess.LoadTrack((int)row["TrackId"]);
row["TrackName"] = trackModel.Name;
}
}
dataTable.Columns.Add("Applied", typeof(bool)).SetOrdinal(0);
dataTable.Columns["ClientEventID"].SetOrdinal(1);
dataTable.Columns["ClientName"].SetOrdinal(2);
dataTable.Columns["TrackName"].SetOrdinal(3);
dataGridView.DataSource = dataTable;
dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
dataGridView.Columns["IsDeleted"].Visible = false;
dataGridView.Columns["ClientId"].Visible = false;
dataGridView.Columns["TrackId"].Visible = false;
int dgv_width = dataGridView.Columns.GetColumnsWidth(DataGridViewElementStates.Visible);
this.Width = 365 + dgv_width;
foreach (DataGridViewColumn column in dgvData.Columns)
{
if (column.HeaderText == "Applied")
{
column.ReadOnly = false;
}
else
{
column.ReadOnly = true;
}
}
dataGridView.ClearSelection();
btnSelect.Click += btnAddClientEvent_Click;
_mainForm = mainForm;
}
public int Insert(ref string errMessage, Track oTrack)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return(TrackDataAccess.Insert(db, oTrack));
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return(-1);
}
}
/// <summary>
/// RefreshDataGridViewTrack - refresh track data grid view
/// </summary>
public void RefreshDataGridViewTrack()
{
List <TrackModel> list = TrackDataAccess.LoadAllTrack();
DataGridView dataGridView = dgvTrack;
DataTable dataTable = ToDataTable(list);
dataGridView.DataSource = dataTable;
dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
//dataGridView.Columns["TrackID"].HeaderText = "Track ID";
//dataGridView.Columns["IsDeleted"].Visible = false;
int dgv_width = dataGridView.Columns.GetColumnsWidth(DataGridViewElementStates.Visible);
this.Width = 365 + dgv_width;
dataGridView.ClearSelection();
}
/// <summary>
/// btnCreate_Click - create new track record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCreate_Click(object sender, EventArgs e)
{
if (ValidateChildren(ValidationConstraints.Enabled))
{
_trackModel = new TrackModel();
_trackModel.Name = txtTrackName.Text.Trim();
try
{
TrackDataAccess.SaveTrack(_trackModel);
}
catch (Exception ex)
{
MessageBox.Show("Runtime Error\n" + ex.Message, "Unexpected Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
this.Close();
}
}
}
public HttpResponseMessage GetTracks(int codeCampId)
{
try
{
var tracks = TrackDataAccess.GetItems(codeCampId);
var response = new ServiceResponse <List <TrackInfo> > {
Content = tracks.ToList()
};
if (tracks == null)
{
ServiceResponseHelper <List <TrackInfo> > .AddNoneFoundError("tracks", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
public HttpResponseMessage GetTrackByRoomId(int roomId, int codeCampId)
{
try
{
var track = TrackDataAccess.GetItems(codeCampId).FirstOrDefault(t => t.RoomId == roomId);
var response = new ServiceResponse <TrackInfo> {
Content = track
};
if (track == null)
{
ServiceResponseHelper <TrackInfo> .AddNoneFoundError("track", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
/// <summary>
/// btnUpdate_Click - update track record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
if (ValidateChildren(ValidationConstraints.Enabled))
{
_trackModel = new TrackModel();
_trackModel.Name = txtTrackName.Text.Trim();
_trackModel.IsDeleted = rdoIsDeleted_Disabled.Checked ? true : false;
try
{
TrackDataAccess.UpdateTrack(_trackModel, int.Parse(txtTrackId.Text));
}
catch (Exception ex)
{
MessageBox.Show("Runtime Error\n" + ex.Message, "Unexpected Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
this.Close();
}
}
}
public HttpResponseMessage GetUnassignedRooms(int codeCampId)
{
try
{
var trackList = TrackDataAccess.GetItems(codeCampId).Select(t => t.RoomId);
var rooms = RoomDataAccess.GetItems(codeCampId).Where(r => !trackList.Contains(r.RoomId));
var response = new ServiceResponse <List <RoomInfo> > {
Content = rooms.ToList()
};
if (rooms == null)
{
ServiceResponseHelper <List <RoomInfo> > .AddNoneFoundError("rooms", ref response);
}
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
/// <summary>
/// RefreshDataGridViewClientEvent - refresh client event data grid view
/// </summary>
public void RefreshDataGridViewClientEvent()
{
List <ClientEventModel> list = ClientEventDataAccess.LoadAllClientEvent();
DataGridView dataGridView = dgvClientEvent;
DataTable dataTable = ToDataTable(list);
foreach (DataRow row in dataTable.Rows)
{
if (row["ClientID"] != null)
{
ClientModel clientModel = ClientDataAccess.LoadClient((int)row["ClientID"]);
row["ClientName"] = clientModel.Name;
}
if (row["TrackID"] != null)
{
TrackModel trackModel = TrackDataAccess.LoadTrack((int)row["TrackID"]);
row["TrackName"] = trackModel.Name;
}
}
dataTable.Columns["ClientEventID"].SetOrdinal(0);
dataTable.Columns["ClientName"].SetOrdinal(1);
dataTable.Columns["TrackName"].SetOrdinal(2);
dataGridView.DataSource = dataTable;
dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
dataGridView.Columns["IsDeleted"].Visible = false;
dataGridView.Columns["ClientId"].Visible = false;
dataGridView.Columns["TrackId"].Visible = false;
int dgv_width = dataGridView.Columns.GetColumnsWidth(DataGridViewElementStates.Visible);
this.Width = 250 + dgv_width;
dataGridView.ClearSelection();
}
/// <summary>
/// ClientEventForm - for updating client event record
/// </summary>
/// <param name="mainForm">main form</param>
/// <param name="clientEventModel">client event record</param>
public ClientEventForm(MainForm mainForm, ClientEventModel clientEventModel)
{
_mainForm = mainForm;
InitializeComponent();
btnEnter.Click += btnClientEventUpdate_Click;
btnEnter.Text = "&Update";
// load client event data to the form
_clientEvent = clientEventModel;
ClientModel clientModel = ClientDataAccess.LoadClient(_clientEvent.ClientID);
TrackModel trackModel = TrackDataAccess.LoadTrack(_clientEvent.TrackID);
_clientsEvents_TrackWorkers = ClientEvents_TrackWorkersDataAccess.LoadClientEventTrackWorker(clientEventModel.ClientEventID);
txtClientEventId.Text = clientEventModel.ClientEventID.ToString();
txtClientId.Text = clientModel.Name.ToString();
txtTrackID.Text = trackModel.Name.ToString();
txtClientEventDate.Text = _clientEvent.Date.ToString();
txtWorkerRequested.Text = _clientEvent.WorkersRequested.ToString();
if (_clientEvent.IsLunchProvided)
{
rdoClientEventIsLunchProvided_True.Checked = true;
}
else
{
rdoClientEventIsLunchProvided_False.Checked = true;
}
if (_clientEvent.IsUsingUpperPaddock)
{
cbClientEventIsUsingUpperPaddock.Checked = true;
}
else
{
cbClientEventIsUsingUpperPaddock.Checked = false;
}
if (_clientEvent.IsUsingMiddlePaddock)
{
cbClientEventIsUsingMiddlePaddock.Checked = true;
}
else
{
cbClientEventIsUsingMiddlePaddock.Checked = false;
}
if (_clientEvent.IsUsingLowerPaddock)
{
cbClientEventIsUsingLowerPaddock.Checked = true;
}
else
{
cbClientEventIsUsingLowerPaddock.Checked = false;
}
if (_clientEvent.WorkerCalloutSent)
{
rdoClientEventWorkerCalloutSent_True.Checked = true;
}
else
{
rdoClientEventWorkerCalloutSent_False.Checked = true;
}
if (_clientEvent.RequireSafetyDemo)
{
rdoClientEventRequireSafetyDemo_True.Checked = true;
}
else
{
rdoClientEventRequireSafetyDemo_False.Checked = true;
}
if (_clientEvent.IsDeleted)
{
rdoClientEventIsDeleted_Disabled.Checked = true;
}
else
{
rdoClientEventIsDeleted_Enabled.Checked = true;
}
}
public HttpResponseMessage UpdateTrack(TrackInfo track)
{
try
{
var updatesToProcess = false;
var originalTrack = TrackDataAccess.GetItem(track.TrackId, track.CodeCampId);
if (!string.Equals(track.Title, originalTrack.Title))
{
originalTrack.Title = track.Title;
updatesToProcess = true;
}
if (!string.Equals(track.Description, originalTrack.Description))
{
originalTrack.Description = track.Description;
updatesToProcess = true;
}
if (originalTrack.CustomProperties != null)
{
// parse custom properties for updates
foreach (var property in originalTrack.CustomPropertiesObj)
{
if (track.CustomPropertiesObj.Any(p => p.Name == property.Name))
{
// see if the existing property needs to be updated
var prop = track.CustomPropertiesObj.FirstOrDefault(p => p.Name == property.Name);
if (!string.Equals(prop.Value, property.Value))
{
property.Value = prop.Value;
updatesToProcess = true;
}
}
else
{
// delete the property
originalTrack.CustomPropertiesObj.Remove(property);
updatesToProcess = true;
}
}
}
if (track.CustomPropertiesObj != null)
{
// add any new properties
if (originalTrack.CustomProperties == null)
{
foreach (var property in track.CustomPropertiesObj)
{
originalTrack.CustomPropertiesObj.Add(property);
updatesToProcess = true;
}
}
else
{
foreach (var property in track.CustomPropertiesObj.Where(property => !originalTrack.CustomPropertiesObj.Contains(property)))
{
originalTrack.CustomPropertiesObj.Add(property);
updatesToProcess = true;
}
}
}
if (updatesToProcess)
{
originalTrack.LastUpdatedByDate = DateTime.Now;
originalTrack.LastUpdatedByUserId = UserInfo.UserID;
TrackDataAccess.UpdateItem(originalTrack);
}
var savedTrack = TrackDataAccess.GetItem(track.TrackId, track.CodeCampId);
var response = new ServiceResponse <TrackInfo> {
Content = savedTrack
};
return(Request.CreateResponse(HttpStatusCode.OK, response.ObjectToJson()));
}
catch (Exception ex)
{
Exceptions.LogException(ex);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ERROR_MESSAGE));
}
}
/// <summary>
/// SetWebBrowserTable - for creating html mail
/// </summary>
public void SetWebBrowserTable()
{
List <ClientEventModel> clientEventModelsList = new List <ClientEventModel>();
allClientEventTrackWorkerIdList = new List <int>();
foreach (int clientEventId in _clientEventIdList)
{
ClientEventModel clientEvent = ClientEventDataAccess.LoadClientEvent(clientEventId);
clientEvent.TrackWorkersId = ClientEvents_TrackWorkersDataAccess.LoadClientEventTrackWorkerIDList(clientEventId);
allClientEventTrackWorkerIdList = allClientEventTrackWorkerIdList.Union(clientEvent.TrackWorkersId).ToList();
clientEventModelsList.Add(clientEvent);
}
stringBodyHTML += "<table style=\"border: 1px solid black;text-align:center;\">";
stringBodyHTML += "<tr>";
stringBodyHTML += "<td></td>";
foreach (ClientEventModel clientEvent in clientEventModelsList)
{
ClientModel client = ClientDataAccess.LoadClient(clientEvent.ClientID);
stringBodyHTML += "<td style=\"border: 1px solid black;\">" + client.Name + "</td>";
}
stringBodyHTML += "</tr>";
stringBodyHTML += "<tr>";
stringBodyHTML += "<td></td>";
foreach (ClientEventModel clientEvent in clientEventModelsList)
{
stringBodyHTML += "<td style=\"border: 1px solid black;\">" + clientEvent.Date + "</td>";
}
stringBodyHTML += "</tr>";
stringBodyHTML += "<tr>";
stringBodyHTML += "<td style=\"border: 1px solid black;\"># Workers Needed</td>";
foreach (ClientEventModel clientEvent in clientEventModelsList)
{
stringBodyHTML += "<td style=\"border: 1px solid black;\">" + clientEvent.WorkersRequested + "</td>";
}
stringBodyHTML += "</tr>";
stringBodyHTML += "<tr>";
stringBodyHTML += "<td style=\"border: 1px solid black;\">Track</td>";
foreach (ClientEventModel clientEvent in clientEventModelsList)
{
TrackModel track = TrackDataAccess.LoadTrack(clientEvent.TrackID);
stringBodyHTML += "<td style=\"border: 1px solid black;\">" + track.Name + "</td>";
}
stringBodyHTML += "</tr>";
stringBodyHTML += "<tr><td><b>Worker Name</b></td></tr>";
foreach (int trackWorkerId in allClientEventTrackWorkerIdList)
{
stringBodyHTML += "<tr>";
TrackWorkerModel trackWorker = TrackWorkerDataAccess.LoadTrackWorker(trackWorkerId);
stringBodyHTML += "<td style=\"border: 1px solid black;\">" + trackWorker.FullName() + "</td>";
foreach (ClientEventModel clientEvent in clientEventModelsList)
{
if (clientEvent.TrackWorkersId.Contains(trackWorkerId))
{
stringBodyHTML += "<td style=\"border: 1px solid black;\">X</td>";
}
else
{
stringBodyHTML += "<td style=\"border: 1px solid black;\"> </td>";
}
}
stringBodyHTML += "</tr>";
}
stringBodyHTML += "</table>";
//webBrowser.DocumentText += stringTableHTML;
}
public TracksController(TrackDataAccess dataAccess)
{
_dataAccess = dataAccess;
}
public async Task <Track> UpdateAsync(TrackUpdateModel track)
{
await AlbumGetService.ValidateAsync(track);
return(await TrackDataAccess.UpdateAsync(track));
}
/// <summary>
/// btnClientAdd_Click - for adding track for client event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnTrackAdd_Click(object sender, EventArgs e)
{
DataGridViewForm dataGridViewForm = new DataGridViewForm(this, TrackDataAccess.LoadTrack());
dataGridViewForm.ShowDialog();
}
