/// <summary>
/// Updates an existing row in the TrainingRequest table.
/// </summary>
/// <param name="trainingRequest">A TrainingRequest entity object.</param>
public void UpdateById(TrainingRequest trainingRequest)
{
const string SQL_STATEMENT =
"UPDATE dbo.TrainingRequest " +
"SET " +
"[CorrelationID]=@CorrelationID, " +
"[UserName]=@UserName, " +
"[StartDate]=@StartDate, " +
"[EndDate]=@EndDate, " +
"[RequestStatus]=@RequestStatus, " +
"[SubmitDate]=@SubmitDate, " +
"[TrainingName]=@TrainingName " +
"WHERE [TRequestID]=@TRequestID ";
// Connect to database.
var db = new SqlDatabase(base.ConnectionString);
using (DbCommand cmd = db.GetSqlStringCommand(SQL_STATEMENT))
{
// Set parameter values.
db.AddInParameter(cmd, "@CorrelationID", DbType.Guid, trainingRequest.CorrelationID);
db.AddInParameter(cmd, "@UserName", DbType.String, trainingRequest.UserName);
db.AddInParameter(cmd, "@StartDate", DbType.Date, trainingRequest.StartDate);
db.AddInParameter(cmd, "@EndDate", DbType.Date, trainingRequest.EndDate);
db.AddInParameter(cmd, "@RequestStatus", DbType.String, trainingRequest.RequestStatus);
db.AddInParameter(cmd, "@SubmitDate", DbType.Date, trainingRequest.SubmitDate);
db.AddInParameter(cmd, "@TrainingName", DbType.AnsiString, trainingRequest.TrainingName);
db.AddInParameter(cmd, "@TRequestID", DbType.String, trainingRequest.TRequestID);
db.ExecuteNonQuery(cmd);
}
}
public void ShowObject(object keyValue)
{
if (keyValue != null)
{
var tid = Convert.ToInt32(keyValue);
var training = _proxy.Context.Trainings.FirstOrDefault(tr => tr.TrainingId == tid);
if (training != null)
{
_training = training;
trainingBindingSource.DataSource = _training;
_request = _proxy.Context.TrainingRequests.FirstOrDefault(
tr => tr.TrainingRequestId == training.TrainingRequestId);
trainingRequestBindingSource.DataSource = _request;
atendeeBindingSource.DataSource =
_proxy.Context.TrainingAttendanceInfoes.Where(ta => ta.TrainingId == training.TrainingId);
feedBackListBindingSource.DataSource = _training.TrainingFeedback;
LoadLookup();
}
}
}
public ActionResult TrainingRegister(int id)
{
//var user = HttpContext.Session["UserProfile"] as UserProfile;
//var user2 = HttpContext.Application["UserProfile"] as UserProfile;
var count = db.Database.SqlQuery <TrainingRequest>("SELECT TOP 1 * FROM TrainingRequests WHERE TrainingID = " + id + " AND UserID = " + WebSecurity.CurrentUserId).FirstOrDefault();
if (count != null)
{
if (count.Status == 1)
{
db.Database.ExecuteSqlCommand("UPDATE TrainingRequests SET [Status] = 0 WHERE UserID = " + WebSecurity.CurrentUserId + " AND TrainingID = " + id);
return(Json(new { success = true, userId = count.UserID, status = 0 }, JsonRequestBehavior.AllowGet));
}
else
{
db.Database.ExecuteSqlCommand("UPDATE TrainingRequests SET [Status] = 1 WHERE UserID = " + WebSecurity.CurrentUserId + " AND TrainingID = " + id);
return(Json(new { success = true, userId = count.UserID, status = 1 }, JsonRequestBehavior.AllowGet));
}
}
else
{
TrainingRequest request = new TrainingRequest();
request.TrainingID = id;
request.UserID = WebSecurity.CurrentUserId;
request.Status = 1;
db.TrainingRequests.Add(request);
db.SaveChanges();
return(Json(new { success = true, userId = request.UserID, status = 1 }, JsonRequestBehavior.AllowGet));
}
}
public TrainingRequest Create([PexAssumeUnderTest] TrainingRequestDAC target, TrainingRequest trainingRequest)
{
TrainingRequest result = target.Create(trainingRequest);
return(result);
// TODO: add assertions to method TrainingRequestDACTest.Create(TrainingRequestDAC, TrainingRequest)
}
/// <summary>
/// Approve business method.
/// </summary>
/// <param name="trainingRequest">A trainingRequest value.</param>
public void Approve(TrainingRequest trainingRequest)
{
// Data access component declarations.
var trainingRequestDAC = new TrainingRequestDAC();
// trainingRequestDAC.SelectById(trainingRequest.TRequestID);
TrainingRequest oldRequest = trainingRequestDAC.SelectById(trainingRequest.TRequestID);
// Step 1 - Calling UpdateById on TrainingRequestDAC.
trainingRequestDAC.UpdateById(trainingRequest);
var auditLog = new AuditLog();
auditLog.Module = "Approve Training";
auditLog.Action = "Approve Training";
auditLog.Description = "Approve Training";
auditLog.CreateBy = Environment.MachineName;
var auditor = new Auditor();
auditor.AuditModified(auditLog, trainingRequest.RequestStatus, trainingRequest.RequestStatus);
// auditor.AuditModified(auditLog, trainingRequest);
//auditor.AuditAdded(auditLog, trainingRequest);
}
public TrainingRequest GetTrainingTest([PexAssumeUnderTest] TrainingComponent target, string tRequestID)
{
TrainingRequest result = target.GetTraining(tRequestID);
return(result);
// TODO: add assertions to method TrainingComponentTest.GetTrainingTest(TrainingComponent, String)
}
/// <summary>
/// Inserts a new row in the TrainingRequest table.
/// </summary>
/// <param name="trainingRequest">A TrainingRequest object.</param>
/// <returns>An updated TrainingRequest object.</returns>
public TrainingRequest Create(TrainingRequest trainingRequest)
{
const string SQL_STATEMENT =
"INSERT INTO dbo.TrainingRequest ([TRequestID], [CorrelationID], [UserName], [StartDate], [EndDate], [RequestStatus], [SubmitDate], [TrainingName]) " +
"VALUES(@TRequestID, @CorrelationID, @UserName, @StartDate, @EndDate, @RequestStatus, @SubmitDate, @TrainingName); ";
// Connect to database.
var db = new SqlDatabase(base.ConnectionString);
using (DbCommand cmd = db.GetSqlStringCommand(SQL_STATEMENT))
{
// Set parameter values.
db.AddInParameter(cmd, "@TRequestID", DbType.String, trainingRequest.TRequestID);
db.AddInParameter(cmd, "@CorrelationID", DbType.Guid, trainingRequest.CorrelationID);
db.AddInParameter(cmd, "@UserName", DbType.String, trainingRequest.UserName);
db.AddInParameter(cmd, "@StartDate", DbType.Date, trainingRequest.StartDate);
db.AddInParameter(cmd, "@EndDate", DbType.Date, trainingRequest.EndDate);
db.AddInParameter(cmd, "@RequestStatus", DbType.String, trainingRequest.RequestStatus);
db.AddInParameter(cmd, "@SubmitDate", DbType.Date, trainingRequest.SubmitDate);
db.AddInParameter(cmd, "@TrainingName", DbType.AnsiString, trainingRequest.TrainingName);
db.ExecuteNonQuery(cmd);
}
return(trainingRequest);
}
public void SendRequest(TrainingRequest request)
{
TrainingMessage message = new TrainingMessage();
message.type = "trainingrequest";
message.payload = JsonUtility.ToJson(request);
SendMessage(message);
}
public HttpResponseMessage Train(TrainingRequest trainingModel)
{
var mem = new RedisMemory(gen);
var trainer = new GameFinishedTrainer(mem, new FrontalLobe(mem));
trainer.Feedback(trainingModel.Game, trainingModel.Result);
return(Request.CreateResponse(HttpStatusCode.OK));
}
/// <summary>
/// Delay business method.
/// </summary>
/// <param name="trainingRequest">A trainingRequest value.</param>
public void Delay(TrainingRequest trainingRequest)
{
// Data access component declarations.
var trainingRequestDAC = new TrainingRequestDAC();
trainingRequest.RequestStatus = "Unattended";
// Step 1 - Calling UpdateById on TrainingRequestDAC.
trainingRequestDAC.UpdateById(trainingRequest);
}
public TrainingRequest ApplyTest(
[PexAssumeUnderTest] TrainingComponent target,
TrainingRequest trainingRequest
)
{
TrainingRequest result = target.Apply(trainingRequest);
return(result);
// TODO: add assertions to method TrainingComponentTest.ApplyTest(TrainingComponent, TrainingRequest)
}
protected override void Execute(CodeActivityContext context)
{
// Argument initialization (if any).
TrainingRequest trainingRequest = context.GetValue(this.TrainingRequest);
// Instantiate business components.
var trainingComponent = new TrainingComponent();
// Call business component methods.
trainingComponent.Delay(trainingRequest);
}
/// <summary>
/// GetTraining business method.
/// </summary>
/// <param name="tRequestID">A tRequestID value.</param>
/// <returns>Returns a TrainingRequest object.</returns>
public TrainingRequest GetTraining(string tRequestID)
{
TrainingRequest result = default(TrainingRequest);
// Data access component declarations.
var trainingRequestDAC = new TrainingRequestDAC();
// Step 1 - Calling SelectById on TrainingRequestDAC.
result = trainingRequestDAC.SelectById(tRequestID);
return(result);
}
public void Reject()
{
TrainingRequest trq = new TrainingRequest();
trq.RequestStatus = "Rejected";
TrainingComponent tr = new TrainingComponent();
tr.Reject(trq);
Assert.IsNotNull(tr);
}
public void Cancel()
{
TrainingRequest trq = new TrainingRequest();
trq.CorrelationID = Guid.NewGuid();
trq.RequestStatus = "Cancelled";
TrainingComponent tr = new TrainingComponent();
tr.Cancel(trq);
Assert.IsNotNull(tr);
}
public void Delay()
{
TrainingRequest trq = new TrainingRequest();
trq.RequestStatus = "Unattended";
TrainingComponent tr = new TrainingComponent();
tr.Delay(trq);
Assert.IsNotNull(tr);
}
/// <summary>
/// Conditionally retrieves one or more rows from the TrainingRequest table with paging.
/// </summary>
/// <param name="currentPage">The currentPage value.</param>
/// <returns>A collection of TrainingRequest objects.</returns>
public List <TrainingRequest> SelectPage(int currentPage)
{
const string SQL_STATEMENT =
"WITH SortedTrainingRequest AS " +
"(SELECT ROW_NUMBER() OVER (ORDER BY [SubmitDate] DESC) AS RowNumber, " +
"[TRequestID], [CorrelationID], [UserName], [StartDate], [EndDate], [RequestStatus]" +
", [SubmitDate], [TrainingName] " +
"FROM dbo.TrainingRequest " +
") SELECT * FROM SortedTrainingRequest " +
"WHERE RowNumber BETWEEN @StartIndex AND @EndIndex";
// PageSize is retrieved from config file via the base class.
long startIndex = (currentPage * base.PageSize);
long endIndex = startIndex + base.PageSize;
startIndex += 1;
List <TrainingRequest> result = new List <TrainingRequest>();
// Connect to database.
var db = new SqlDatabase(base.ConnectionString);
using (DbCommand cmd = db.GetSqlStringCommand(SQL_STATEMENT))
{
// Paging parameters.
db.AddInParameter(cmd, "@StartIndex", DbType.Int64, startIndex);
db.AddInParameter(cmd, "@EndIndex", DbType.Int64, endIndex);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
// Create a new TrainingRequest
TrainingRequest trainingRequest = new TrainingRequest();
// Read values.
trainingRequest.TRequestID = GetDataValue <string>(dr, "TRequestID");
trainingRequest.CorrelationID = GetDataValue <Guid>(dr, "CorrelationID");
trainingRequest.UserName = GetDataValue <string>(dr, "UserName");
trainingRequest.StartDate = GetDataValue <DateTime>(dr, "StartDate");
trainingRequest.EndDate = GetDataValue <DateTime>(dr, "EndDate");
trainingRequest.RequestStatus = GetDataValue <string>(dr, "RequestStatus");
trainingRequest.SubmitDate = GetDataValue <DateTime>(dr, "SubmitDate");
trainingRequest.TrainingName = GetDataValue <string>(dr, "TrainingName");
// Add to List.
result.Add(trainingRequest);
}
}
}
return(result);
}
public void Approve()
{
TrainingRequest trq = new TrainingRequest();
trq.CorrelationID = Guid.NewGuid();
trq.RequestStatus = "Approval";
TrainingComponent tr = new TrainingComponent();
tr.Approve(trq);
Assert.IsNotNull(tr);
}
private void OnTrainingFrame(TrainingRequest request, IAgentManager manager)
{
lock (state)
{
state.scenekey = request.circuit;
state.carkey = request.car;
state.agents.Clear();
state.agents.AddRange(manager.Agents.Select(t => new TrainingAgentTransform()
{
position = t.position, rotation = t.rotation
}));
}
}
public void get_CorrelationID()
{
TrainingRequest newtr = new TrainingRequest();
newtr.CorrelationID = Guid.NewGuid();
newtr.TRequestID = "TR10011";
newtr.UserName = "******";
newtr.TrainingName = "MCSD";
newtr.SubmitDate = DateTime.Now;
newtr.StartDate = Convert.ToDateTime("2017-04-01");
newtr.EndDate = Convert.ToDateTime("2017-07-01");
newtr.RequestStatus = "Pending";
Assert.IsNotNull(newtr.CorrelationID);
}
public void UpdateById()
{
TrainingRequestDAC tr = new TrainingRequestDAC();
TrainingRequest trq = new TrainingRequest();
trq.CorrelationID = Guid.NewGuid();
trq.TRequestID = "TR10011";
trq.StartDate = Convert.ToDateTime("2017-04-01");
trq.EndDate = Convert.ToDateTime("2017-07-01");
trq.RequestStatus = "Cancelled";
trq.SubmitDate = DateTime.Now;
trq.TrainingName = "MCSD";
trq.UserName = "******";
Assert.IsNotNull(tr, "TR10011");
}
public void Reject()
{
TrainingRequest trq = new TrainingRequest();
trq.CorrelationID = Guid.NewGuid();
trq.TRequestID = "TR10011";
trq.StartDate = Convert.ToDateTime("2017-04-01");
trq.EndDate = Convert.ToDateTime("2017-07-01");
trq.RequestStatus = "Rejected";
trq.SubmitDate = DateTime.Now;
trq.TrainingName = "MCSD";
trq.UserName = "******";
TrainingComponent tr = new TrainingComponent();
Assert.IsNotNull(tr);
}
public void SelectByIdTest()
{
TrainingRequest tr = new TrainingRequest();
tr.CorrelationID = Guid.NewGuid();
tr.CorrelationID = Guid.NewGuid();
tr.TRequestID = "TR10011";
tr.UserName = "******";
tr.TrainingName = "MCSD";
tr.SubmitDate = DateTime.Now;
tr.StartDate = Convert.ToDateTime("2017-04-01");
tr.EndDate = Convert.ToDateTime("2017-07-01");
tr.RequestStatus = "Pending";
Assert.IsNotNull(tr);
// Assert.Fail();
}
public void TrainingRequestDeclined()
{
var mock = new Mock <ITrainingRequestRepository>();
var entry = new TrainingRequest
{
IsActive = true
};
mock.Setup(r => r.Get(It.IsAny <Guid>())).Returns(entry);
var handler = new DeclineTrainingRequestHandler(mock.Object);
handler.Handle(new DeclineTrainingRequestRequest {
TrainingRequestId = Guid.NewGuid()
}, new System.Threading.CancellationToken());
entry.IsActive.Should().BeFalse();
}
protected override void Execute(CodeActivityContext context)
{
// Variable declarations (if any).
TrainingRequest applyResult = default(TrainingRequest);
// Argument initialization (if any).
TrainingRequest trainingRequest = context.GetValue(this.TrainingRequest);
// Instantiate business components.
var trainingComponent = new TrainingComponent();
// Call business component methods.
applyResult = trainingComponent.Apply(trainingRequest);
// Set value to Out arguments (if any).
context.SetValue(this.ApplyResult, applyResult);
}
protected void btnCancel_Click(object sender, EventArgs e)
{
TrainingRequest cancelTraining = new TrainingRequest();
cancelTraining.TRequestID = lblRequestID.Text;
cancelTraining.UserName = lblUserName.Text;
cancelTraining.CorrelationID = Guid.Parse(lblguid.Text);
cancelTraining.StartDate = Convert.ToDateTime(txtStartDate.Text);
cancelTraining.EndDate = Convert.ToDateTime(txtEndDate.Text);
cancelTraining.RequestStatus = "Cancelled";
cancelTraining.TrainingName = txtTrainingName.Text;
cancelTraining.SubmitDate = Convert.ToDateTime(lblSubmitDate.Text);
Process.TrainingController CancelledTraining = new Process.TrainingController();
CancelledTraining.Cancel(cancelTraining);
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
/// <summary>
/// Apply business method.
/// </summary>
/// <param name="trainingRequest">A trainingRequest value.</param>
/// <returns>Returns a TrainingRequest object.</returns>
public TrainingRequest Apply(TrainingRequest trainingRequest)
{
TrainingRequest result = default(TrainingRequest);
// Data access component declarations.
var trainingRequestDAC = new TrainingRequestDAC();
Sequencer sequencer = Sequencer.Create();
trainingRequest.TRequestID = "TR" + sequencer.Next();
// Step 1 - Calling Create on TrainingRequestDAC.
result = trainingRequestDAC.Create(trainingRequest);
return(result);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
TrainingRequest newTraining = new TrainingRequest();
newTraining.CorrelationID = Guid.NewGuid();
newTraining.UserName = lblUserName.Text;
newTraining.StartDate = Convert.ToDateTime(txtStartDate.Text);
newTraining.EndDate = Convert.ToDateTime(txtEndDate.Text);
newTraining.RequestStatus = lblStatus.Text;
newTraining.TrainingName = txtTrainingName.Text;
newTraining.SubmitDate = Convert.ToDateTime(lblSubmitDate.Text);
Process.TrainingController submitTraining = new Process.TrainingController();
submitTraining.Apply(newTraining);
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
public IActionResult PutTrainingRequest(int id, TrainingRequest trainingRequest)
{
if (trainingRequest != null && id != trainingRequest.Id)
{
return(BadRequest());
}
try
{
this._trainingRequestService.UpdateRecord(trainingRequest);
return(Ok());
}
catch (DbUpdateConcurrencyException)
{
return(NotFound());
}
}
public void Apply()
{
TrainingRequest trq = new TrainingRequest();
trq.CorrelationID = Guid.NewGuid();
trq.StartDate = Convert.ToDateTime("2017-04-01");
trq.EndDate = Convert.ToDateTime("2017-07-01");
trq.RequestStatus = "Pending";
trq.SubmitDate = DateTime.Now;
trq.TrainingName = "MCSD";
trq.UserName = "******";
TrainingComponent tr = new TrainingComponent();
tr.Apply(trq);
Assert.IsNotNull(trq);
}
