public Training Predict(Training training)
{
var model = cache.Get(
training.UserId,
() =>
{
return this.GetPredictionModel(training.UserId);
}
, 5 * 60);
var trainingDuration = training.EndDate - training.StartDate;
var input = new double[]
{
training.Track.Length,
training.Track.Ascent,
training.Track.AscentLength,
};
var result = model.Compute(input);
training.Calories = result[0];
training.Water = result[1];
training.EndDate = training.StartDate.AddHours(result[2]);
return training;
}
public TrainingsModel(Training training)
: base()
{
this.Id = training.Id;
this.Text = training.Text;
this.Title = training.Title;
}
/// <summary>
/// Adds package to the database
/// </summary>
/// <param name="package">Package value represents package object with necessary information.</param>
public Training AddPackage(Package package)
{
PackageItemIdentifier packageId;
ValidationResults importLog;
using (PackageReader packageReader = package.GetPackageReader())
{
AddPackageResult result = PStore.AddPackage(packageReader, new PackageEnforcement(false, false, false));
packageId = result.PackageId;
importLog = result.Log;
}
// fill in the application-specific columns of the PackageItem table
LearningStoreJob job = LStore.CreateJob();
Dictionary<string, object> properties = new Dictionary<string, object>();
properties[Schema.PackageItem.Owner] = new UserItemIdentifier(package.Owner);
properties[Schema.PackageItem.FileName] = package.FileName;
properties[Schema.PackageItem.UploadDateTime] = package.UploadDateTime;
job.UpdateItem(packageId, properties);
job.Execute();
// retrieve information about the package
job = LStore.CreateJob();
RequestMyTraining(job, packageId);
DataTable dataTableResults = job.Execute<DataTable>();
Training training = new Training(dataTableResults.Rows[0]);
return training;
}
private IEnumerator Train(Training t)
{
this.State = HumanState.Typing;
yield return new RadicalWaitForSeconds(t.Strength * 2);
if(t.Skill.ID == 1)
this.Programming += t.Strength;
if (t.Skill.ID == 2)
this.Art += t.Strength;
this.State = HumanState.Idle;
}
protected void Page_Load(object sender, EventArgs e)
{
lbID.Text = Request.Params["id"];
string fid = Request.Params["fid"];
string cid = Request.Params["cid"];
if (fid != null && fid != string.Empty)
{
paramString = "fid=" + fid;
paramName = Field.GetField(new Guid(fid)).FieldName;
}
else if (cid != null && cid != string.Empty)
{
paramString = "cid=" + cid;
paramName = Category.GetCategory(new Guid(cid)).Title;
}
else
{
paramName = paramString = string.Empty;
}
cTraining = Training.GetTraining(new Guid(lbID.Text));
this.Title = cTraining.Title;
AuthorProfile ap = AuthorProfile.GetProfile(cTraining.Teacher);
if (ap != null)
{
TeacherString = "<a href='./TeacherView.aspx?uid=" + ap.UserName + "'>" + ap.DisplayName + "</a>";
TeacherDes = ap.AboutMe;
pnltch.Visible = true;
}
else
{
pnltch.Visible = false;
TeacherString = cTraining.Teacher;
}
if (Request.Cookies["TrainViewCount_" + lbID.Text] == null)
{
HttpCookie MyCookie = new HttpCookie("TrainViewCount_" + lbID.Text);
DateTime now = DateTime.Now;
MyCookie["IP"] = Request.UserHostAddress;
MyCookie["tid"] = lbID.Text;
MyCookie.Expires = now.AddHours(1);
Response.Cookies.Add(MyCookie);
cTraining.ViewCount++;
cTraining.UpdateViewCount();
}
}
/// <summary>
/// Retrieves collection of trainings for given user.
/// </summary>
/// <param name="userID">Long integer value representing user id.</param>
/// <returns>IEnumerable collection of Training objects.</returns>
public IEnumerable<Training> GetTrainings(long userID)
{
this.UserKey = userID.ToString();
LearningStoreJob job = LStore.CreateJob();
RequestMyTraining(job, null);
DataTable results = job.Execute<DataTable>();
List<Training> packages = new List<Training>();
foreach (DataRow dataRow in results.AsEnumerable())
{
// Create Training object
Training training = new Training(dataRow);
packages.Add(training);
}
return packages;
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (_training == null)
{
_training = new Training();
_training.Author = Page.User.Identity.Name;
_training.DateCreated = DateTime.Now.AddHours(-TrainSettings.Instance.Timezone);
}
_training.Title = txtTitle.Text;
_training.Teacher = ddlObj.SelectedValue;
_training.Days = Convert.ToInt32(txtDays.Text);
_training.Content = txtContent.Text;
_training.Tags.Clear();
_training.Categories.Clear();
_training.Fields.Clear();
foreach (ListItem item in cblCategories.Items)
{
if (item.Selected)
_training.Categories.Add(Category.GetCategory(new Guid(item.Value)));
}
foreach (ListItem item in cblField.Items)
{
if (item.Selected)
_training.Fields.Add(Field.GetField(new Guid(item.Value)));
}
if (txtTags.Text.Trim().Length > 0)
{
string[] tags = txtTags.Text.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (string tag in tags)
{
if (string.IsNullOrEmpty(_training.Tags.Find(delegate(string t) { return t.Equals(tag.Trim(), StringComparison.OrdinalIgnoreCase); })))
{
_training.Tags.Add(tag.Trim());
}
}
}
_training.Save();
Reload();
}
public ResponseMessage InsertTraining(Training training)
{
var message = new ResponseMessage();
if (training == null)
{
message.SetErrorMessage("Invalid data");
}
var value = _dbContext.Add(training);
var insertedCount = Save();
if (insertedCount > 0)
{
message.SetSuccessMessage("Request sent successfully!");
}
else
{
message.SetErrorMessage("Error sending request");
}
return(message);
}
public ActionResult CheckAttendance(int trainingID, List <int> playersList)
{
Training training = db.Trainings.Find(trainingID);
if (ModelState.IsValid)
{
training.IsAttendanceListChecked = true;
db.Teams.Single(t => t.ID == training.TeamID).Players.ForEach(p => db.Attendances.Add(new Attendance {
PlayerID = p.ID, TrainingID = trainingID, WasPresent = false
}));;
db.SaveChanges();
playersList.ForEach(p => db.Attendances.Single(a => a.PlayerID == p && a.TrainingID == trainingID).WasPresent = true);
db.SaveChanges();
return(RedirectToAction("Details", new { id = trainingID }));
}
return(View(training));
}
public async Task GetAll__Authenticated_Admin_Or_Moderator_Can_Retrieve_All_Public_Trainings()
{
AuthenticatedUser user = await LogInAs("*****@*****.**");
Training training1 = await CreatePublicTraining();
Training training2 = await CreatePublicTraining();
Training training3 = await CreatePublicTraining(user.Id);
var response = await Client.GetAsync(ApiRoutes.Training.GetAllPublicTrainings);
response.StatusCode.Should().Be(HttpStatusCode.OK);
var body = await response.Content.ReadAsAsync <List <PublicTrainingResponse> >();
body.Count.Should().Be(3);
body[0].Id.Should().Be(training1.Id);
body[1].Id.Should().Be(training2.Id);
body[2].Id.Should().Be(training3.Id);
}
public void CreateTraining(Training training, Coach coach)
{
var dbCoach = _coachRepo.Get(c => c.COACH_INTERNAL_ID == coach.Coach_Internal_Id);
var dbTraining = new TRAINING();
dbTraining.TRAINING_INTERNAL_ID = training.Training_Internal_Id;
dbTraining.DURATION = training.Duration;
dbTraining.NOTES = training.Notes;
dbTraining.STARTDATE = DateTime.ParseExact(training.StartDate, "yyyy-MM-dd",
System.Globalization.CultureInfo.InvariantCulture);
dbTraining.TRAININGTHEME = training.TrainingTheme;
dbTraining.TRAININGTYPE = training.TrainingType;
dbTraining.TRAINING_QUALITY = training.TrainingQuality;
dbTraining.RELATIONSHIP = training.Relationship;
dbTraining.COACH = dbCoach;
_trainingRepo.Add(dbTraining);
_unitOfWork.Commit();
}
// GET: Training
public ActionResult NewRequest(Training training)
{
if (training.EmployeeNo == null || training.TrainingGroupNo == 0 ||
training.ParticipantNo == 0 || training.Duration == 0)
{
ViewBag.Error = "Incomplete Form ! Please Fill all Fields";
ViewBag.Employees = db.Employees.Select(p => new { Id = p.ID, Name = p.FirstName + " " + p.LastName, Number = p.EmployeeNumber, Department = p.OfficePosition.Department.DepartmentName });
ViewBag.Courses = db.TrainingCourses.Select(p => new { p.Code, p.Description });
ViewBag.TrainingCourseCode = new SelectList(db.TrainingCourses.ToList(), "Code", "Description");
ViewBag.TrainingProviderCode = new SelectList(db.TrainingProviders.ToList(), "Code", "Name");
return(View(training));
}
if (ModelState.IsValid)
{
db.Trainings.Add(training);
db.SaveChanges();
return(RedirectToAction("Request/Create", "Trainings"));
}
return(View(training));
}
public IActionResult GetById(int Id)
{
Training trains = null;
//client.DefaultRequestHeaders.Add("Authorization", HttpContext.Session.GetString("token"));
var resTask = client.GetAsync("" + Id);
resTask.Wait();
var result = resTask.Result;
if (result.IsSuccessStatusCode)
{
var json = JsonConvert.DeserializeObject(result.Content.ReadAsStringAsync().Result).ToString();
trains = JsonConvert.DeserializeObject <Training>(json);
}
else
{
ModelState.AddModelError(string.Empty, "Server Error.");
}
return(Json(trains));
}
public void WriteModel()
{
Problem train = SVMUtilities.CreateTwoClassProblem(100);
Parameter param = new Parameter();
RangeTransform transform = RangeTransform.Compute(train);
Problem scaled = transform.Scale(train);
param.KernelType = KernelType.LINEAR;
Training.SetRandomSeed(SVMUtilities.TRAINING_SEED);
Model model = Training.Train(scaled, param);
using (MemoryStream stream = new MemoryStream())
using (StreamReader input = new StreamReader("svm0.model"))
{
Model.Write(stream, model);
string expected = input.ReadToEnd().Replace("\r\n", "\n");
string actual = Encoding.ASCII.GetString(stream.ToArray());
Assert.AreEqual(expected, actual);
}
}
public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)
{
if (objectType == typeof(Training))
{
JObject obj = serializer.Deserialize <JToken>(reader) as JObject;
if (obj != null)
{
var training = new Training(null);
training.ReadJson(obj);
return(training);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
public async Task <IEnumerable <VideoStreamDTO> > GetVideoStreamsAsync(int trainingId)
{
Training training = await trainings.GetAsync(trainingId);
if (training == null)
{
throw new NotFoundException("Training doesn't exist");
}
var streams = await videoStreams.GetForTrainingAsync(trainingId);
await UpdateVideoStreamsSavedInfo(streams.Where(s => s.EndTime == null || s.StartTime == null));
return(streams.Select(stream => new VideoStreamDTO
{
Id = stream.Id,
TeamMemberId = stream.TeamMemberId,
StreamId = stream.YouTubeId,
StartTime = stream.StartTime,
EndTime = stream.EndTime
}));
}
public async Task <IActionResult> createTraining([FromBody] SaveTrainingResource trainingResource)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Training training = mapper.Map <SaveTrainingResource, Training>(trainingResource);
DateTime now = DateTime.Now;
training.InsertDate = now;
training.LastUpdate = now;
trainingRepository.Add(training);
await unitOfWork.CompleteAsync();
Training trainingToMap = await trainingRepository.GetOne(training.Id);
var response = mapper.Map <Training, TrainingResource>(trainingToMap);
return(Ok(response));
}
public async Task <IActionResult> OrderSoloTraining(TrainingViewModel model)
{
var user = await _userService.GetUserAsync(User.Identity.Name);
if (user == null)
{
return(BadRequest(new { errorText = "Authorization error." }));
}
var participants = new List <User>()
{
user
};
var training = new Training()
{
};
await _trainingService.CreateTrainingAsync(training, "training/confirm/");
return(Ok());
}
public bool deleteTraining(Training obj)
{
string insertCommand = "delete from training " +
"where trainingId= @trainingId ";
SqlCommand command = new SqlCommand(insertCommand);
SqlParameter trainingIdParameter = new SqlParameter("@trainingId", SqlDbType.Int);
trainingIdParameter.Value = obj.trainingId;
command.Parameters.Add(trainingIdParameter);
if (da.Execution(command))
{
return(true);
}
else
{
return(false);
}
}
private void displayComboUIReset()
{
//Resets all the combo UI variables
for (int i = 0; i < 5; i++)
{
if (i >= comboTracker.Count)
{
if (Training.getTrainingMode())
{
if (i > comboTracker.Count || i == 0)
{
combo[i].GetComponent <SpriteRenderer>().enabled = false;
}
}
else
{
combo[i].GetComponent <SpriteRenderer>().enabled = false;
}
}
}
}
static void RunTraining()
{
Training training = new Training(
reproductionOrganismCount: 2,
maxGroupSize: 12,
selectionFactor: 0.5f,
populationSizeBeforeTrimming: 96,
populationSizeAfterTrimming: 12,
hiddenLayerCount: 2,
inputNodeCount: 790,
hiddenNodeCount: 32,
outputNodeCount: 1,
mutationRate: 0.01f,
testFrequency: 1,
engineDepth: 0,
maxParallelGames: 5,
numberOfTestGames: 20
);
training.Train();
}
private TrainingDTO CreateTrainingDTO(Training training)
{
List <ShortTraineeDetailDTO> shortTraineeDetailDtos = new List <ShortTraineeDetailDTO>();
List <ShortTrainerDetailDTO> shortTrainerDetailDtos = new List <ShortTrainerDetailDTO>();
var trainees = _traineeRepository.getTraineesByArrayId(training.ArrayOfAssignedTrainees);
var trainers = _trainerRepository.GetTrainersByArrayId(training.ArrayOfAssignedTrainees);
trainees.ForEach(thisTrainee => shortTraineeDetailDtos.Add(new ShortTraineeDetailDTO(thisTrainee.Id, thisTrainee.Person.Name, thisTrainee.DefaultDepartment)));
trainers.ForEach(thisTrainer => shortTrainerDetailDtos.Add(new ShortTrainerDetailDTO(thisTrainer.Id, thisTrainer.Person.Name)));
TrainingDTO trainingDto = new TrainingDTO(
training.Id, training.ProgramId, training.Programs.ProgramTitle,
ConfigurationRepository.GetMaximumHoursPerDay(),
training.TrainingStatus, training.StartDate, training.EndDate, training.TotalDuration,
shortTraineeDetailDtos,
shortTrainerDetailDtos,
BuildFullModuleArrangementDTO(training.ModuleArrangement)
);
return(trainingDto);
}
public IHttpActionResult DeleteTraining(int id)
{
Training training = db.Trainings.Find(id);
Schedule schedule = db.Schedules.Where(a => a.ScheduleId == training.ScheduleId).FirstOrDefault();
try
{
if (training == null)
{
return(NotFound());
}
db.Trainings.Remove(training); //delete training
db.Schedules.Remove(schedule); //delete schedule of training
db.SaveChanges();
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
return(Ok(training));
}
public async Task <Training> UpdateTraining(Training newTraining)
{
DefaultContractResolver contractResolver = new DefaultContractResolver
{
NamingStrategy = new CamelCaseNamingStrategy()
};
var postJson = JsonConvert.SerializeObject(newTraining, new JsonSerializerSettings
{
ContractResolver = contractResolver,
Formatting = Formatting.Indented
});
StringContent queryString = new StringContent(postJson, Encoding.UTF8, "application/json");
var response = await LoginInfo.client.PutAsync(uri + "/" + newTraining._id, queryString);
response.EnsureSuccessStatusCode();
Training training = JsonConvert.DeserializeObject <Training>(await response.Content.ReadAsStringAsync());
return(training);
}
public ActionResult Edit([Bind(Include = "Id, Name,Description")] Training training)
{
if (ModelState.IsValid)
{
Training t = db.Trainings.Find(training.Id);
if (training.CreatedBy == (System.Security.Claims.ClaimsPrincipal.Current).
FindFirst("http://schemas.microsoft.com/identity/claims/objectidentifier").Value)
{
db.Entry(training).State = EntityState.Modified;
db.SaveChanges();
}
else
{
return(new ViewResult {
ViewName = "Error", ViewBag = { message = "Unauthorized - only creator can edit training." }
});
}
}
return(RedirectToAction("Index"));
}
public async Task Patch__User_Can_Add_Exercises_To_His_Private_Training()
{
AuthenticatedUser user = await LogInAs("*****@*****.**");
Training training = await CreatePrivateTraining(user.Id);
Exercise exercise1 = await CreateExercise();
Exercise exercise2 = await CreateExercise();
string patchEndpoint = ApiRoutes.Training.AddExercisesToTraining.Replace("{trainingId}", training.Id.ToString());
UpdateTrainingExercisesRequest request = new UpdateTrainingExercisesRequest
{
Exercises = new[] { exercise1.Id, exercise2.Id }
};
HttpContent content = new StringContent(JsonSerializer.Serialize(request), Encoding.UTF8, "application/json");
var response = await Client.PatchAsync(patchEndpoint, content);
response.StatusCode.Should().Be(HttpStatusCode.OK);
}
public ActionResult Create([Bind(Include = "TrainingID,Name,TrainingDate,Location,TrainingEnd,NumberOfMeetings,Duration,ExpireDate,ExpirationDate,QualificationID")] Training training, int[] subsectors)
{
if (ModelState.IsValid)
{
foreach (var id in subsectors)
{
SubSector subsector = db.SubSectors.Find(id);
training.AddSubSector(subsector);
}
db.Trainings.Add(training);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Sectors = new MultiSelectList(db.Sectors, "SectorID", "SectorType");
ViewBag.subSectors = new MultiSelectList(db.SubSectors, "SubSectorID", "SubSectortype");
ViewBag.QualificationID = new SelectList(db.Qualification, "QualificationID", "Name");
return(View(training));
}
public void EditTrainingWithName(string trainingName, Training newTraining)
{
if (ExistsTrainingWithName(trainingName))
{
if (trainingName == newTraining.Name || !ExistsTrainingWithName(newTraining.Name))
{
int trainingToEditIndex = trainings.FindIndex(training => training.Name == trainingName);
trainings[trainingToEditIndex] = newTraining;
SendDataToObservers();
}
else
{
throw new NameAlreadyTakenException();
}
}
else
{
throw new NonexistantNameException();
}
}
public async Task Delete__Admin_Or_Moderator_Can_Delete_Public_Training()
{
string[] users = { "*****@*****.**", "*****@*****.**" };
int i = 1;
foreach (var user in users)
{
await LogInAs(user);
Training training = await CreatePublicTraining();
string deleteEndpoint = ApiRoutes.Training.DeletePublic.Replace("{trainingId}", training.Id.ToString());
var response = await Client.DeleteAsync(deleteEndpoint);
response.StatusCode.Should().Be(HttpStatusCode.NoContent);
int trainingCount = await Context.Training.AsNoTracking().CountAsync();
trainingCount.Should().Be(0);
}
}
public ActionResult Delete(int id)
{
Training training = db.Trainings.Find(id);
if (training == null)
{
return(HttpNotFound());
}
if (training.CreatedBy == (System.Security.Claims.ClaimsPrincipal.Current).
FindFirst("http://schemas.microsoft.com/identity/claims/objectidentifier").Value)
{
return(View(training));
}
else
{
return new ViewResult {
ViewName = "Error", ViewBag = { message = "Unauthorized - only creator can delete training." }
}
};
}
private async Task <Training> CreatePublicTraining(int userId = 0)
{
Training trainingModel = Factory.Training.GetModel(true);
await Context.Training.AddAsync(trainingModel);
await Context.SaveChangesAsync();
if (userId > 0)
{
UserTraining userTraining = new UserTraining
{
TrainingId = trainingModel.Id,
UserId = userId
};
await Context.UserTraining.AddAsync(userTraining);
await Context.SaveChangesAsync();
}
return(trainingModel);
}
public Training Post(string name, string detail, DateTime start_date, DateTime end_date, DateTime regis_start_date, DateTime regis_end_date, string image)
{
var date = DateTime.Now;
var trainingdata = new Training
{
Name = name,
Detail = detail,
StartDate = start_date,
EndDate = end_date,
RegisStartDate = regis_start_date,
RegisEndDate = regis_end_date,
Image = image,
CreatedAt = date
};
_context.Trainings.Add(trainingdata);
_context.SaveChanges();
return(trainingdata);
}
public async void Get_returns_list_of_trainings()
{
//Arrange
var sampleTraining1 = new Training()
{
Id = 1, StartDate = new DateTime(2019, 09, 20), EndDate = new DateTime(2019, 09, 21), TrainingName = "Asp.net Training"
};
var sampleTraining2 = new Training()
{
Id = 2, StartDate = new DateTime(2019, 09, 21), EndDate = new DateTime(2019, 09, 22), TrainingName = "Web Api training"
};
context.AddRange(sampleTraining1, sampleTraining2);
context.SaveChanges();
//Act
var taskResult = await myController.GetTrainings();
//Assert
Assert.IsType <ActionResult <IEnumerable <Training> > >(taskResult);
}
public async Task <bool> AddTrainingToHistory(Training training, List <ExerciseHistory> exerciseHistories)
{
int userId = _authHelper.GetAuthenticatedUserId();
User user = await _context.Users
.Include(x => x.ExerciseHistories)
.FirstOrDefaultAsync(x => x.Id == userId);
user.TrainingHistories.Add(new TrainingHistory {
Training = training, Date = DateTime.Now
});
foreach (ExerciseHistory exerciseHistory in exerciseHistories)
{
var alreadyExists = user.ExerciseHistories
.FirstOrDefault(x =>
x.ExerciseId == exerciseHistory.ExerciseId &&
x.Date == DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"))
);
if (alreadyExists != null)
{
var stats = exerciseHistory.ExerciseHistoryStats;
stats.ForAll(x => x.ExerciseHistoryId = alreadyExists.Id);
await _context.ExerciseHistoryStats.AddRangeAsync(stats);
}
else
{
user.ExerciseHistories.Add(new ExerciseHistory
{
UserId = userId,
ExerciseId = exerciseHistory.ExerciseId,
Date = DateTime.Now,
ExerciseHistoryStats = exerciseHistory.ExerciseHistoryStats
});
}
}
return(await _context.SaveChangesAsync() > 0);
}
public void ClassifierLoss2()
{
Matrix <double> classifier_input = Matrix <double> .Build.DenseOfArray(
new double[, ] {
{ 1 }, { 0.5 }
}
);
Matrix <double> target = Matrix <double> .Build.DenseOfArray(
new double[, ] {
{ 0.1 }, { 0.9 }
}
);
Matrix <double> dummy = Matrix <double> .Build.DenseOfArray(
new double[, ] {
{ 2 }
}
);
MutableTypes.Model model = new MutableTypes.Model(dummy, dummy);
double loss = Training._calculateLoss(classifier_input, model, target, 0.1);
double sm1 = Math.Exp(1);
double sm2 = Math.Exp(0.5);
double N = sm1 + sm2;
double sm1N = sm1 / N;
double sm2N = sm2 / N;
double sm1N_log = -Math.Log(sm1N);
double sm2N_log = -Math.Log(sm2N);
double sm1N_log_target = sm1N_log * 0.1;
double sm2N_log_target = sm2N_log * 0.9;
double sum = sm1N_log_target + sm2N_log_target;
double wd_loss = 0.1 * 8.0 / 2.0;
Assert.AreEqual(sum + wd_loss, loss, 0.00000000001);
}
private void acceptButton_Click(object sender, EventArgs e)
{
Training t = new Training();
t.LockerId = lockers[comboLocker.SelectedIndex].RecordId;
t.ClientId = clients[comboClient.SelectedIndex].RecordId;
t.TrainerId = trainers[comboTrainer.SelectedIndex].RecordId;
t.ToGender = clients[comboClient.SelectedIndex].Gender;
t.TimeFrom = DateTime.Now;
ClientFactory clientFactory = new ClientFactory();
ClientGateway <Client> cg = (ClientGateway <Client>)clientFactory.GetClient();
Client c = cg.Select(t.ClientId);
DiscountFactory discountFactory = new DiscountFactory();
DiscountGateway <DiscountCard> dg = (DiscountGateway <DiscountCard>)discountFactory.GetCard();
DiscountCard card = new DiscountCard();
if (c.CardId != null)
{
int toSetId = c.CardId ?? 0;
card = dg.Select(toSetId);
}
TrainingFactory trainingFactory = new TrainingFactory();
TrainingGateway <Training> tg = (TrainingGateway <Training>)trainingFactory.GetTraining();
tg.Insert(t);
if (card != null && card.Credit > 0)
{
Forms.ChangeCredit form = new Forms.ChangeCredit();
form.ShowDialog();
}
else
{
MessageBox.Show("Training was added successfully but client " + c.Name + " " + c.Surname + " has no credit on card!", "Warning", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
this.Dispose();
}
public void AddTraining(string account,
ProductivityTools.SportsTracker.SDK.Model.Training stTraining,
byte[] gpx,
List <ProductivityTools.SportsTracker.SDK.Model.TrainingImage> images)
{
Training training = new Training();
training.Account = account;
training.Application = "SportsTracker";
training.Calories = stTraining.EnergyConsumption;
// training.Comment = stTraining.Description;
training.Distance = Convert.ToDecimal(stTraining.Distance);
training.Duration = Convert.ToInt32(stTraining.Duration.TotalSeconds);
training.Start = stTraining.StartDate;
training.End = training.Start.AddSeconds(training.Duration);
training.ExternalIdList = new Dictionary <string, string>();
training.ExternalIdList.Add("SportsTracker", stTraining.WorkoutKey);
training.Name = stTraining.Description;
training.Source = "TrainingLog.SportsTracker.Cmdlet";
var trainingMap = TrainingMapConfiguration.GetTraining(stTraining.TrainingType);
training.Sport = trainingMap.TrainingLogTrainingType;
training.AverageSpeed = stTraining.AverageSpeed;
training.ExternalIdList = new Dictionary <string, string>();
training.ExternalIdList.Add("SportsTracker", stTraining.WorkoutKey);
training.Gpx = gpx;
training.Pictures = new List <byte[]>();
foreach (var image in images)
{
using (MemoryStream ms = new MemoryStream())
{
image.Stream.CopyTo(ms);
training.Pictures.Add(ms.ToArray());
}
}
TrainingLogSdk.PostTraining(training);
}
private static void SeedCheckedInTrainings(ApplicationDbContext context)
{
if (context.Trainings.Any(x => x.CheckedInOn != null && x.CheckedOutOn == null))
{
return;
}
var users = context.Users.Select(x => x.Id).ToList();
int i = 0;
var rand = new Random();
foreach (var userId in users)
{
var futureCoef = (i % 5 == 0) ? 1 : -1;
var randomDate = DateTime.Now.AddHours(rand.Next(1, 12) * futureCoef);
var training = new Training()
{
Title = $"Training{i}",
UserId = userId,
Calories = rand.Next(700, 3500),
Water = 0.5 + (rand.NextDouble() * 3),
StartDate = randomDate,
EndDate = randomDate + new TimeSpan(rand.Next(3, 12), 0, 0),
CheckedInOn = randomDate.AddHours(-1),
TrackId = i + 1
};
i++;
context.Trainings.Add(training);
}
}
private static void SeedTrainings(ApplicationDbContext context)
{
if (context.Trainings.Any())
{
return;
}
var rand = new Random();
for (int i = 0; i < 1000; i++)
{
var user = context.Users.OrderBy(x => Guid.NewGuid()).First();
var randomDate = DateTime.Now.AddHours(rand.Next(50, 150) * (-1));
var training = new Training()
{
Title = $"Training{i}",
Calories = rand.Next(700, 3500),
Water = 0.5 + (rand.NextDouble() * 3),
User = user,
StartDate = randomDate,
EndDate = randomDate + new TimeSpan(rand.Next(3, 12), 0, 0),
};
var ascentLen = 5 + (rand.NextDouble() * 30);
var track = new Track()
{
AscentLength = ascentLen,
Ascent = ascentLen * rand.Next(20, 100),
Length = ascentLen * (1.5 + (rand.NextDouble() * 2.5)),
Title = $"Track{i}",
User = user
};
training.Track = track;
context.Trainings.Add(training);
}
}
protected void saveBtn_Click(object sender, EventArgs e)
{
Training harkka = new Training();
harkka.name = txtName.Text;
harkka.date = txtDate.Text;
harkka.time = txtTime.Text;
harkka.kilometers = txtKilometers.Text;
TrainingXml tXml = new TrainingXml(filePath);
//tXml.insertToXml(filePath, dt, harkka);
if (Session["DataTable"] != null)
{
dt = (DataTable)Session["DataTable"];
tXml.insertToXml(filePath, dt, harkka);
}
else
{
dt = tXml.readXml();
tXml.insertToXml(filePath, dt, harkka);
}
}
public void SpecialTraining(Training training)
{
switch (training)
{
case Training.Assault:
{
//Assault Training
CombatSkills = 100;
GiveFeat = "FlurryOfBlows 3";
GiveFeat = "FlashyAttack 3";
FavouriteStance = "FlurryOfBlows";
FavouriteManeuver = "FlashyAttack";
SetStr(Str + 50);
SetDex(Dex + 50);
PassiveSpeed -= 0.05;
ActiveSpeed -= 0.1;
if (Nation == Nation.Mhordul || Nation == Nation.Azhuran || Nation == Nation.Insularii)
{
GiveFeat = "QuickReflexes 3";
GiveFeat = "BruteStrength 3";
SetHits(Hits + 50);
}
PayRate += 1000;
SetRank(2);
break;
}
case Training.Endurance:
{
//Endurance Training
CombatSkills = 100;
GiveFeat = "DefensiveStance 3";
GiveFeat = "PoisonRestance 3";
GiveFeat = "MagicResistance 3";
GiveFeat = "ShieldMastery 3";
FavouriteStance = "DefensiveStance";
SetHits(Hits + 100);
SetStam(Stam + 100);
if (Nation == Nation.Tyrean || Nation == Nation.Insularii)
{
GiveFeat = "DamageIgnore 3";
GiveFeat = "FastHealing 3";
SetHits(Hits + 100);
}
PayRate += 1000;
SetRank(2);
break;
}
case Training.Strategy:
{
//Strategy Training
CombatSkills = 100;
GiveFeat = "FocusedAttack 3";
GiveFeat = "BleedingStrike 3";
GiveFeat = "BruteStrength 3";
FavouriteStance = "FocusedAttack";
FavouriteManeuver = "BleedingStrike";
SetInt(Int + 50);
SetDex(Dex + 25);
SetMana(Mana + 50);
if (Nation == Nation.Khemetar || Nation == Nation.Insularii )
{
GiveFeat = "QuickReflexes 3";
GiveFeat = "DamageIgnore 3";
}
PayRate += 1000;
SetRank(2);
break;
}
case Training.Ranged:
{
//Ranged Combat Training
CombatSkills = 100;
GiveFeat = "BowMastery 3";
GiveFeat = "FarShot 3";
GiveFeat = "SwiftShot 3";
GiveFeat = "CripplingShot 3";
FavouriteStance = "SwiftShot";
FavouriteManeuver = "CripplingShot";
SetStr(Str + 25);
SetDex(Dex + 25);
SetInt(Int + 100);
if (Nation == Nation.Alyrian || Nation == Nation.Insularii )
{
GiveFeat = "Evade 3";
GiveFeat = "Dodge 3";
GiveFeat = "EnhancedDodge 3";
SetDex(Dex + 25);
}
PayRate += 1000;
SetRank(2);
break;
}
case Training.Dragoon:
{
//Dragoon Training
CombatSkills = 100;
GiveFeat = "MountedEndurance 3";
GiveFeat = "MountedDefence 3";
GiveFeat = "MountedCharge 3";
GiveFeat = "MountedCombat 3";
GiveFeat = "MountedMomentum 3";
FavouriteManeuver = "Charge";
FavouriteStance = "FocusedAttack";
SetStr(Str + 15);
SetHits(Hits + 50);
SetDex(Dex + 15);
SetInt(Int + 15);
SetStam(Stam + 50);
if (Nation == Nation.Vhalurian || Nation == Nation.Insularii )
{
SetStr(Str + 50);
SetHits(Hits + 100);
VirtualArmor += 10;
}
PayRate += 1000;
SetRank(2);
break;
}
default: break;
}
}
public static int CalculateSoldierPay(Armament arm, Training train)
{
int cost = 0;
if (train != Training.None)
cost += 1000;
switch (arm)
{
case Armament.Light: cost += 1000; break;
case Armament.Medium: cost += 1500; break;
case Armament.Heavy: cost += 2000; break;
case Armament.Ranged: cost += 1500; break;
case Armament.LightCavalry: cost += 2500; break;
case Armament.HeavyCavalry: cost += 3500; break;
default: break;
}
return cost;
}
private void RemoveTraining(Training cm)
{
bool found = false;
for (int i = 0; i < Training.Trainings.Count; i++)
{
if (Training.Trainings[i].Id == cm.Id)
{
Training.Trainings[i].Delete();
Training.Trainings[i].Save();
found = true;
break;
}
if (found) { break; }
}
}
/// <summary> /// Updates an existing Training in the data store specified by the provider. /// </summary> public abstract void UpdateTraining(Training training);
private static void RunPrediction(PredictionService service)
{
// Train the service with the existing bucket data.
string id = ClientCredentials.BucketPath;
CommandLine.WriteAction("Performing training of the service ...");
CommandLine.WriteResult("Bucket", id);
Training training = new Training { Id = id };
training = service.Training.Insert(training).Fetch();
// Wait until the training is complete.
while (training.TrainingStatus == "RUNNING")
{
CommandLine.Write("..");
Thread.Sleep(1000);
training = service.Training.Get(id).Fetch();
}
CommandLine.WriteLine();
CommandLine.WriteAction("Training complete!");
CommandLine.WriteLine();
// Make a prediction.
CommandLine.WriteAction("Performing a prediction...");
string text = "mucho bueno";
CommandLine.RequestUserInput("Text to analyze", ref text);
var input = new Input { InputValue = new Input.InputData { CsvInstance = new List<string> { text } } };
Output result = service.Training.Predict(input, id).Fetch();
CommandLine.WriteResult("Language", result.OutputLabel);
}
internal void BeginTraining(Training t)
{
var r = RadicalRoutine.Create(Train(t));
r.Run();
}
/// <summary>
/// Returns a Post based on Id
/// </summary>
/// <param name="id">PostID</param>
/// <returns>post</returns>
public override Training SelectTraining(Guid id)
{
Training training = new Training();
string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
using (DbConnection conn = provider.CreateConnection())
{
conn.ConnectionString = connString;
using (DbCommand cmd = conn.CreateCommand())
{
string sqlQuery = "SELECT TrainingID,Title,TrainingContent,DateCreated,DateModified,Author,IsPublished,Days,Teacher,ViewCount,IsGold " +
"FROM " + tablePrefix + "Trainings " +
"WHERE TrainingID = " + parmPrefix + "id";
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
DbParameter dpID = provider.CreateParameter();
dpID.ParameterName = parmPrefix + "id";
dpID.Value = id.ToString();
cmd.Parameters.Add(dpID);
conn.Open();
using (DbDataReader rdr = cmd.ExecuteReader())
{
if (rdr.HasRows)
{
rdr.Read();
training.Id = rdr.GetGuid(0);
training.Title = rdr.GetString(1);
training.Content = rdr.GetString(2);
//training.Description = rdr.IsDBNull(2) ? String.Empty : rdr.GetString(2);
if (!rdr.IsDBNull(3))
training.DateCreated = rdr.GetDateTime(3);
if (!rdr.IsDBNull(4))
training.DateModified = rdr.GetDateTime(4);
if (!rdr.IsDBNull(5))
training.Author = rdr.GetString(5);
if (!rdr.IsDBNull(6))
training.IsPublished = rdr.GetBoolean(6);
training.Days = rdr.GetInt32(7);
training.Teacher = rdr.GetString(8);
training.ViewCount = rdr.GetInt32(9);
if (!rdr.IsDBNull(10))
training.IsGold = rdr.GetBoolean(10);
}
}
// Tags
sqlQuery = "SELECT Tag " +
"FROM " + tablePrefix + "Tags " +
"WHERE ParentID = " + parmPrefix + "id and ParentType=1";
cmd.CommandText = sqlQuery;
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
if (!rdr.IsDBNull(0))
training.Tags.Add(rdr.GetString(0));
}
}
training.Tags.MarkOld();
// Categories
sqlQuery = "SELECT CategorieID " +
"FROM " + tablePrefix + "TrainingCategorie " +
"WHERE TrainingID = " + parmPrefix + "id";
cmd.CommandText = sqlQuery;
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
Guid key = rdr.GetGuid(0);
if (Category.GetCategory(key) != null)
training.Categories.Add(Category.GetCategory(key));
}
}
// Fields
sqlQuery = "SELECT FieldID " +
"FROM " + tablePrefix + "TrainingField " +
"WHERE TrainingID = " + parmPrefix + "id";
cmd.CommandText = sqlQuery;
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
Guid key = rdr.GetGuid(0);
if (Field.GetField(key) != null)
training.Fields.Add(Field.GetField(key));
}
}
// Comments
sqlQuery = "SELECT CommentID,CommentDate,Author,Count,Sex,Phone,Mobile,Email, " +
"Company,QQ_msn,Comment,IsDispose,DisposeBy,Country,IP " +
"FROM " + tablePrefix + "Comments " +
"WHERE ParentID = " + parmPrefix + "id and ParentType = 1";
cmd.CommandText = sqlQuery;
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
Comment comment = new Comment();
comment.Id = rdr.GetGuid(0);
comment.IsApproved = false;
comment.DateCreated = rdr.GetDateTime(1);
comment.Author = rdr.GetString(2);
comment.Count = rdr.GetInt32(3);
comment.Sex = rdr.GetBoolean(4);
if (!rdr.IsDBNull(5))
comment.Phone = rdr.GetString(5);
comment.Mobile = rdr.GetString(6);
if (!rdr.IsDBNull(7))
comment.Email = rdr.GetString(7);
comment.Company = rdr.GetString(8);
if (!rdr.IsDBNull(9))
comment.QQ_msn = rdr.GetString(9);
comment.Content = rdr.GetString(10);
if (!rdr.IsDBNull(11))
comment.IsApproved = rdr.GetBoolean(11);
if (!rdr.IsDBNull(10))
comment.ModeratedBy = rdr.GetString(12);
if (!rdr.IsDBNull(6))
comment.Country = rdr.GetString(6);
if (!rdr.IsDBNull(7))
comment.IP = rdr.GetString(7);
comment.ParentId = id;
comment.ParentType = 1;
comment.Parent = training;
training.Comments.Add(comment);
}
}
training.Comments.Sort();
}
}
return training;
}
/// <summary>
/// Deletes a post in the database
/// </summary>
/// <param name="post">post to delete</param>
public override void DeleteTraining(Training training)
{
string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
using (DbConnection conn = provider.CreateConnection())
{
conn.ConnectionString = connString;
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
string sqlQuery = "DELETE FROM " + tablePrefix + "Tags WHERE ParentID = @id and ParentType=1;" +
"DELETE FROM " + tablePrefix + "TrainingCategorie WHERE TrainingID = @id;" +
"DELETE FROM " + tablePrefix + "TrainingField WHERE TrainingID = @id;" +
"DELETE FROM " + tablePrefix + "Comments WHERE ParentID = @id and ParentType=1" +
"DELETE FROM " + tablePrefix + "Trainings WHERE TrainingID = @id;";
if (parmPrefix != "@")
sqlQuery = sqlQuery.Replace("@", parmPrefix);
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
DbParameter dpID = provider.CreateParameter();
dpID.ParameterName = parmPrefix + "id";
dpID.Value = training.Id.ToString();
cmd.Parameters.Add(dpID);
cmd.ExecuteNonQuery();
}
}
}
private Member NewEsarTrainee_Internal(FormCollection fields)
{
Member m = new Member();
TryUpdateModel(m, new[] { "FirstName", "LastName", "MiddleName", "BirthDate", "SheriffApp", "Gender" });
this.db.Members.Add(m);
SarUnit esar = (from u in this.db.Units where u.DisplayName == "ESAR" select u).First();
UnitStatus status = (from s in this.db.UnitStatusTypes where s.Unit.Id == esar.Id && s.StatusName == "trainee" select s).First();
if (!string.IsNullOrEmpty(fields["Street"]))
{
PersonAddress address = new PersonAddress { Person = m, Type = PersonAddressType.Mailing };
TryUpdateModel(address, new[] { "Street", "City", "State" });
GeographyServices.RefineAddressWithGeography(address);
if (address.Quality < 8)
{
try
{
ModelState.SetModelValue("Zip", new ValueProviderResult(fields["Zip"], fields["Zip"], CultureInfo.CurrentUICulture));
// This is supposed to be UpdateModel, not TryUpdate
UpdateModel(address, new[] { "Zip" });
}
catch (Exception)
{
ModelState.AddModelError("Zip", "Can't locate address. ZIP is required");
}
}
this.db.PersonAddress.Add(address);
}
foreach (string contact in new[] { "Home", "Work", "Cell" })
{
if (string.IsNullOrEmpty(fields[contact + "Phone"]))
{
continue;
}
ModelState.SetModelValue(contact + "Phone", new ValueProviderResult(fields[contact + "Phone"], fields[contact + "Phone"], CultureInfo.CurrentUICulture));
PersonContact pc = new PersonContact { Person = m, Type = "phone", Subtype = contact.ToLower(), Value = fields[contact + "Phone"] };
this.db.PersonContact.Add(pc);
}
if (!string.IsNullOrEmpty(fields["HamCall"]))
{
ModelState.SetModelValue("HamCall", new ValueProviderResult(fields["HamCall"], fields["HamCall"], CultureInfo.CurrentUICulture));
PersonContact pc = new PersonContact { Person = m, Type = "hamcall", Value = fields["HamCall"] };
this.db.PersonContact.Add(pc);
}
if (!string.IsNullOrEmpty(fields["Email"]))
{
ModelState.SetModelValue("Email", new ValueProviderResult(fields["Email"], fields["Email"], CultureInfo.CurrentUICulture));
PersonContact pc = new PersonContact { Person = m, Type = "email", Value = fields["Email"] };
this.db.PersonContact.Add(pc);
}
if (!string.IsNullOrEmpty(fields["Email2"]))
{
ModelState.SetModelValue("Email2", new ValueProviderResult(fields["Email2"], fields["Email2"], CultureInfo.CurrentUICulture));
PersonContact pc = new PersonContact { Person = m, Type = "email", Value = fields["Email2"] };
this.db.PersonContact.Add(pc);
}
DateTime courseDate = new DateTime(1900, 1, 1);
ModelState.SetModelValue("CourseDate", new ValueProviderResult(fields["CourseDate"], fields["CourseDate"], CultureInfo.CurrentUICulture));
if (string.IsNullOrEmpty(fields["CourseDate"]))
{
ModelState.AddModelError("CourseDate", "Required");
return null;
}
else if (!DateTime.TryParse(fields["CourseDate"], out courseDate))
{
ModelState.AddModelError("CourseDate", "Unknown format. Try yyyy-mm-dd");
return null;
}
courseDate = courseDate.Date;
UnitMembership um = new UnitMembership { Person = m, Status = status, Unit = esar, Activated = courseDate };
this.db.UnitMemberships.Add(um);
TrainingCourse courseA = (from tc in this.db.TrainingCourses where tc.DisplayName == "Course A" select tc).First();
DateTime nextDate = courseDate.AddDays(1);
Training t = (from trn in this.db.Trainings where trn.StartTime >= courseDate && trn.StartTime < nextDate && trn.Title == "Course A" select trn).FirstOrDefault();
if (t == null)
{
t = new Training();
t.OfferedCourses.Add(courseA);
t.StartTime = courseDate.AddHours(19);
t.StopTime = courseDate.AddHours(21);
t.County = "King";
t.Title = "Course A";
t.Location = "Eastside Fire Headquarters";
this.db.Trainings.Add(t);
}
TrainingRoster tr = new TrainingRoster { Person = m, TimeIn = courseDate.AddHours(18), TimeOut = courseDate.AddHours(22) };
this.db.TrainingRosters.Add(tr);
t.Roster.Add(tr);
TrainingAward ta = new TrainingAward();
ta.Completed = courseDate.AddHours(21);
if ((courseA.ValidMonths ?? 0) > 0)
{
ta.Expiry = ta.Completed.AddMonths(courseA.ValidMonths.Value);
}
ta.Course = courseA;
ta.Member = m;
this.db.TrainingAward.Add(ta);
tr.TrainingAwards.Add(ta);
return m;
}
/// <summary>
/// Deletes the specified Training from the current provider.
/// </summary>
public static void DeleteTraining(Training training)
{
LoadProviders();
_provider.DeleteTraining(training);
}
private void SetGoldTraining(Training cm)
{
bool found = false;
for (int i = 0; i < Training.Trainings.Count; i++)
{
if (Training.Trainings[i].Id == cm.Id)
{
if (!cm.IsGold)
{
int goldCount = Training.Trainings.FindAll(delegate(Training tg) { return tg.IsGold; }).Count;
if (goldCount >= 6)
{
String csname = "PopupScript";
Type cstype = this.GetType();
ClientScriptManager cs = Page.ClientScript;
if (!cs.IsStartupScriptRegistered(cstype, csname))
{
StringBuilder cstext = new StringBuilder();
cstext.Append("<script type=text/javascript> alert('仅能设置6个精品课程!') </script>");
cs.RegisterStartupScript(cstype, csname, cstext.ToString());
}
return;
}
Training.Trainings[i].IsGold = true;
}
else
{
Training.Trainings[i].IsGold = false;
}
Training.Trainings[i].DateModified = DateTime.Now;
Training.Trainings[i].Save();
found = true;
break;
}
if (found) { break; }
}
}
///// <summary>
///// Returns the content of a post.
///// </summary>
//public static string SelectTrainingContent(Guid id)
//{
// LoadProviders();
// return _provider.SelectTrainingContent(id);
//}
/// <summary>
/// Persists a new Training in the current provider.
/// </summary>
public static void InsertTraining(Training training)
{
LoadProviders();
_provider.InsertTraining(training);
}
private void ApproveTraining(Training cm)
{
bool found = false;
for (int i = 0; i < Training.Trainings.Count; i++)
{
if (Training.Trainings[i].Id == cm.Id)
{
if (!cm.IsPublished)
{
Training.Trainings[i].IsPublished = true;
Training.Trainings[i].DateModified = DateTime.Now;
Training.Trainings[i].Save();
}
found = true;
break;
}
if (found) { break; }
}
}
/// <summary>
/// Updates an exsiting Training.
/// </summary>
public static void UpdateTraining(Training training)
{
LoadProviders();
_provider.UpdateTraining(training);
}
/// <summary> /// Deletes a Training from the data store specified by the provider. /// </summary> public abstract void DeleteTraining(Training training);
public void insertToXml(String fileLocation, DataTable dt, Training tr)
{
dt.Rows.Add(tr.name, tr.date, tr.time, tr.kilometers);
dt.WriteXml(fileLocation, true);
}
public override void Deserialize(GenericReader reader)
{
base.Deserialize(reader);
int version = reader.ReadInt();
switch (version)
{
case 0:
{
m_Armaments = (Armament)reader.ReadInt();
m_PayRate = reader.ReadInt();
m_speechInterval = reader.ReadDeltaTime();
m_Training = (Training)reader.ReadInt();
m_BaseName = reader.ReadString();
break;
}
}
if (Government != null && Government.Deleted && !Government.Employees.Contains(this))
Government.Employees.Add(this);
}
protected void Page_Load(object sender, EventArgs e)
{
txtTitle.Focus();
if (!Page.IsPostBack && !Page.IsCallback)
{
BindTags();
BindCategories();
BindFields();
BindTeacher();
_id = HttpContext.Current.Request.QueryString["id"];
_urlReferrer = HttpContext.Current.Request.UrlReferrer.ToString();
if (_id!=null && _id!= string.Empty )
{
_training = Training.GetTraining(new Guid(_id));
}
if (_training!=null)
{
BindTraining();
}
}
}
/// <summary> /// Inserts a new Training into the data store specified by the provider. /// </summary> public abstract void InsertTraining(Training training);
/// <summary>
/// Saves and existing post in the database
/// </summary>
/// <param name="post">post to be saved</param>
public override void UpdateTraining(Training training)
{
string connString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
string providerName = ConfigurationManager.ConnectionStrings[connStringName].ProviderName;
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
using (DbConnection conn = provider.CreateConnection())
{
conn.ConnectionString = connString;
conn.Open();
using (DbCommand cmd = conn.CreateCommand())
{
string sqlQuery = "UPDATE " + tablePrefix + "Trainings " +
"SET Title = @title, TrainingContent = @content, " +
"DateCreated = @created, DateModified = @modified, Author = @Author, " +
"IsPublished = @published ,Days= @days,Teacher= @teacher,ViewCount=@ViewCount,IsGold=@IsGold " +
"WHERE TrainingID = @id";
if (parmPrefix != "@")
sqlQuery = sqlQuery.Replace("@", parmPrefix);
cmd.CommandText = sqlQuery;
cmd.CommandType = CommandType.Text;
DbParameter dpID = provider.CreateParameter();
dpID.ParameterName = parmPrefix + "id";
dpID.Value = training.Id.ToString();
cmd.Parameters.Add(dpID);
DbParameter dpTitle = provider.CreateParameter();
dpTitle.ParameterName = parmPrefix + "title";
dpTitle.Value = training.Title;
cmd.Parameters.Add(dpTitle);
DbParameter dpContent = provider.CreateParameter();
dpContent.ParameterName = parmPrefix + "content";
dpContent.Value = training.Content;
cmd.Parameters.Add(dpContent);
DbParameter dpCreated = provider.CreateParameter();
dpCreated.ParameterName = parmPrefix + "created";
dpCreated.Value = training.DateCreated.AddHours(-TrainSettings.Instance.Timezone);
cmd.Parameters.Add(dpCreated);
DbParameter dpModified = provider.CreateParameter();
dpModified.ParameterName = parmPrefix + "modified";
if (training.DateModified == new DateTime())
dpModified.Value = DateTime.Now;
else
dpModified.Value = training.DateModified.AddHours(-TrainSettings.Instance.Timezone);
cmd.Parameters.Add(dpModified);
DbParameter dpAuthor = provider.CreateParameter();
dpAuthor.ParameterName = parmPrefix + "author";
dpAuthor.Value = training.Author ?? "";
cmd.Parameters.Add(dpAuthor);
DbParameter dpPublished = provider.CreateParameter();
dpPublished.ParameterName = parmPrefix + "published";
dpPublished.Value = training.IsPublished;
cmd.Parameters.Add(dpPublished);
DbParameter dpDays = provider.CreateParameter();
dpDays.ParameterName = parmPrefix + "days";
dpDays.Value = training.Days;
cmd.Parameters.Add(dpDays);
DbParameter dpTeacher = provider.CreateParameter();
dpTeacher.ParameterName = parmPrefix + "teacher";
dpTeacher.Value = training.Teacher.ToString();
cmd.Parameters.Add(dpTeacher);
DbParameter dpViewCount = provider.CreateParameter();
dpViewCount.ParameterName = parmPrefix + "ViewCount";
dpViewCount.Value = training.ViewCount;
cmd.Parameters.Add(dpViewCount);
DbParameter dpIsGold = provider.CreateParameter();
dpIsGold.ParameterName = parmPrefix + "IsGold";
dpIsGold.Value = training.IsGold;
cmd.Parameters.Add(dpIsGold);
cmd.ExecuteNonQuery();
}
// Tags
UpdateTags(training, conn, provider);
// Categories
UpdateCategories(training, conn, provider);
//Fields
UpdateFields(training, conn, provider);
// Comments
UpdateComments(training, conn, provider);
}
}
