public List <ProgramDTO> ListPrograms()
{
var list = new List <ProgramDTO>();
var files = Directory.GetFiles(Environment.GetEnvironmentVariable("AppData") + @"\Microsoft\Windows\Start Menu\Programs\Startup");
foreach (string file in files)
{
if (Path.GetExtension(file).ToLower() != ".lnk")
{
continue;
}
var originPath = GetShortcutTarget(file);
var program = new ProgramDTO()
{
Image = GetImage(originPath),
Name = new FileInfo(originPath).Name,
Command = "",
FilePath = originPath,
TypeAutorun = TypeAutorun.StartMenu
};
CheckDigitalSignature(program);
list.Add(program);
}
return(list);
}
/// <summary>
/// Creates a new ProgramViewModel and initializes itself with the given program dto.
/// </summary>
/// <param name="program">The program dto.</param>
public ProgramViewModel(ProgramDTO program) : this()
{
Contract.Requires(program != null, "The program must not be null.");
Contract.Requires(program.RowVersion != null, "The row version must not be null.");
this.Contacts = program.Contacts;
this.CountryIsos = program.CountryIsos;
this.Description = program.Description;
this.Goals = program.Goals;
this.Id = program.Id;
this.Name = program.Name;
this.OwnerDescription = program.OwnerDescription;
this.OwnerName = program.OwnerName;
this.OwnerOrganizationId = program.OwnerOrganizationId;
this.OwnerOfficeSymbol = program.OwnerOfficeSymbol;
this.OwnerOfficeCategoryLabel = program.OwnerOrganizationCategoryLabel;
this.OwnerOfficeObjectiveLabel = program.OwnerOrganizationObjectiveLabel;
this.ParentProgramId = program.ParentProgramId;
this.ParentProgramName = program.ParentProgramName;
this.RegionIsos = program.RegionIsos;
this.RevisedOn = program.RevisedOn;
this.RowVersion = Convert.ToBase64String(program.RowVersion);
this.StartDate = program.StartDate;
this.EndDate = program.EndDate;
this.Themes = program.Themes;
this.Categories = program.Categories;
this.Objectives = program.Objectives;
this.ProgramStatusId = program.ProgramStatusId;
this.ProgramStatusName = program.ProgramStatusName;
this.Websites = program.Websites;
this.Regions = program.Regions;
}
public List <ProgramDTO> GetAllProgram(string board_Id)
{
List <ProgramDTO> listProgram = new List <ProgramDTO>();
this.ConnectToDatabase();
MySqlCommand command = this.mySQLConnection.CreateCommand();
command.CommandText = "SELECT * FROM PROGRAM where PROGRAM_ID = " + board_Id;
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string programId = reader.GetString(0);
string classId = reader.GetString(1);
int level = reader.GetInt32(2);
int fee = reader.GetInt32(3);
ProgramDTO program = new ProgramDTO(programId, classId, level, fee);
listProgram.Add(program);
}
reader.Close();
this.Close();
return(listProgram);
}
public ProgramDTO GetProgram(string id)
{
ProgramDTO program;
this.ConnectToDatabase();
MySqlCommand command = this.mySQLConnection.CreateCommand();
command.CommandText = "SELECT * FROM PROGRAM WHERE PROGRAM_ID = '" + id + "'";
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string programId = reader.GetString(0);
string classId = reader.GetString(1);
int level = reader.GetInt32(2);
int fee = reader.GetInt32(3);
program = new ProgramDTO(programId, classId, level, fee);
return(program);
}
reader.Close();
this.Close();
return(null);
}
private void button3_Click(object sender, EventArgs e)
{
ProgramDTO currentObject = (ProgramDTO)dgvListProgram.CurrentRow.DataBoundItem;
EditProgramForm f = new EditProgramForm(currentObject);
f.ShowDialog();
}
internal ProgramDTO getById(string programId)
{
ProgramDTO program;
string queryString =
"SELECT client_id FROM program " +
" WHERE @id = id";
using (SqlConnection connection = EstablishingConnection.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand(queryString, connection))
{
command.Parameters.AddWithValue("@id", programId);
SqlDataReader reader = command.ExecuteReader();
program = new ProgramDTO();
while (reader.Read())
{
ProgramDTO programNew = new ProgramDTO
{
ClientId = (string)reader["client_id"],
};
program = programNew;
}
connection.Close();
}
return(program);
}
}
public static ProgramDTO ReadOneProgram(ushort focasLibHandle, int progromToRead, short programDetailType = 1)
{
ProgramDTO program = new ProgramDTO();
int topProgram = progromToRead;
short prgromsToRead = 1;
short ret = 0;
ret = 0;
FocasLibBase.PRGDIR3 d = new FocasLibBase.PRGDIR3();
try
{
ret = FocasLib.cnc_rdprogdir3(focasLibHandle, programDetailType, ref topProgram, ref prgromsToRead, d);
if (ret != 0)
{
Logger.WriteErrorLog("cnc_rdprogdir3() failed. return value is = " + ret);
}
else
{
if (prgromsToRead > 0)
{
if (topProgram == progromToRead)
{
program.ProgramNo = d.dir1.number;
program.Comment = d.dir1.comment;
}
}
}
}
catch (Exception ex)
{
Logger.WriteErrorLog(ex.ToString());
}
return(program);
}
public List <ProgramDTO> GetAllPrograms(string clientId)
{
List <ProgramDTO> programs;
string queryString =
"SELECT * from program" +
" WHERE program.client_id = @client_id";
using (SqlConnection connection = EstablishingConnection.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand(queryString, connection))
{
command.Parameters.AddWithValue("@client_id", clientId);
SqlDataReader reader = command.ExecuteReader();
programs = new List <ProgramDTO>();
while (reader.Read())
{
ProgramDTO program = new ProgramDTO
{
Id = (int)reader["id"],
ClientId = (string)reader["client_id"],
GoalTypeId = (int)reader["goal_type_id"],
StartTime = Convert.ToDateTime(reader["start_time"]),
EndTime = Convert.ToDateTime(reader["end_time"]),
Description = (string)reader["description"]
};
programs.Add(program);
}
connection.Close();
}
return(programs);
}
}
public ICollection <ProgramDTO> GetUsersPrograms(ProgramDTO newProgram, String userName)
{
ActionResponse response = new ActionResponse();
ProgramRepository repository = RepositoriesFactory.CreateRepository <ProgramRepository, Program>();
int UserId = GetCurrentUser().UserId;
ICollection <Program> wantedPrograms;
if (GetCurrentUser().Permission == (int)Enums.PermissionsType.Admin)
{
wantedPrograms = repository.GetALL();
}
else
{
wantedPrograms =
repository.Query().Where(CurrProgram => CurrProgram.UserPrograms.Any(currUser => currUser.UserId == UserId)).ToList();
}
ICollection <ProgramDTO> ProgramDrills =
wantedPrograms.Select <Program, ProgramDTO>(currProgram => ConvertEntityTODTO(currProgram)).ToList();
return(ProgramDrills);
}
public ListProgramDTO GetAllPrograms()
{
try
{
ListProgramDTO listProgramDTO = new ListProgramDTO();
List <ProgramDTO> listPrograms = new List <ProgramDTO>();
//Call a DAL method to to get all Programs in database
List <Program> programs = _programRepository.GetAll().ToList();
foreach (var program in programs)
{
ProgramDTO programDTO = new ProgramDTO(
program.Id, program.ProgramTitle, program.ArrayOfIncludedModules.ToList(),
program.ArrayOfNeedByPotentialTrainees.ToList());
listPrograms.Add(programDTO);
}
listProgramDTO.ProgramList = listPrograms;
return(listProgramDTO);
}
catch
{
return(null);
}
}
public ActionResponse UpdateProgram(ProgramDTO program)
{
ActionResponse response = ValidateProgram(program, true);
if (response != null)
{
return(response);
}
response = CanUserEditProgram(program.Id);
if (response != null)
{
return(response);
}
Program programForUpdate = ConvertDTOToEntity(program);
ProgramRepository programRepository = RepositoriesFactory.CreateRepository <ProgramRepository, Program>();
Program existingProgram = programRepository.Get(programForUpdate.ProgramId);
existingProgram.ProgramName = programForUpdate.ProgramName;
foreach (ProgramDrill currDrill in programForUpdate.ProgramDrills)
{
ProgramDrill existingProgramDrill =
existingProgram.ProgramDrills.FirstOrDefault(currProgramDrill => currProgramDrill.Id == currDrill.Id);
if (existingProgramDrill == null)
{
existingProgram.ProgramDrills.Add(currDrill);
}
else
{
foreach (Set currSet in currDrill.Sets)
{
Set existingSet =
existingProgramDrill.Sets.FirstOrDefault(currExistingSet => currExistingSet.SetId == currSet.SetId);
if (existingSet == null)
{
existingProgramDrill.Sets.Add(currSet);
}
else
{
existingSet.Repetitions = currSet.Repetitions;
existingSet.Weight = currSet.Weight;
existingSet.Repetitions = currSet.Repetitions;
}
}
}
}
programRepository.Update(existingProgram);
return(new ActionResponse()
{
CompletedSuccessfully = true
});
}
public ProgramViewViewModel(ProgramDTO program) : base(PageModes.View)
{
Drills = program.Drills
.Select <ProgramDrillDTO, ProgramDrillViewModel>(currDrill => Converter.Convert <ProgramDrillViewModel>(currDrill))
.ToList();
ProgramName = program.Name;
}
public Models.Database.Program MapToProgram(ProgramDTO programDTO)
{
return(new Models.Database.Program()
{
EngSubject = programDTO.EngSubject,
Hours = programDTO.Hours,
Subject = programDTO.Subject
});
}
public List <AlumnDTO> HämtaAlumnerMedProgram(ProgramDTO program)
{
List <AlumnDTO> alumnerMedProgram = new List <AlumnDTO>();
foreach (AlumnProgramDTO ap in unitOfWork.AlumnRepository.HämtaAlumnerMedProgram(program))
{
alumnerMedProgram.Add(unitOfWork.AlumnRepository.GetById(ap.AlumnID));
}
return(alumnerMedProgram);
}
private static void get_program(List <ProgramDTO> ls, FocasLibBase.PRGDIR3_data dir)
{
ProgramDTO pDto = new ProgramDTO();
pDto.ProgramNo = dir.number;
pDto.ProgramLenght = dir.length;
pDto.Comment = dir.comment;
pDto.ModifiedDate = new DateTime(dir.mdate.year < 2000 ? dir.mdate.year + 2000 : dir.mdate.year, dir.mdate.month, dir.mdate.day, dir.mdate.hour, dir.mdate.minute, 00);
ls.Add(pDto);
}
//OK
// GET: Client/CreateProgramForClient/5
public ActionResult CreateProgramForClient(string clientId)
{
ProgramDTO program = new ProgramDTO();
program.ClientId = clientId;
program.StartTime = DateTime.Today;
program.EndTime = DateTime.Today;
ViewBag.goalsItems = goalTypeDAO.GetAll();
return(View(program));
}
public void TestConstructor_ProgramDtoArg()
{
var list = new List <LocationDTO>();
var dto = new ProgramDTO();
dto.Contacts = ToListOfSimpleLookups(1, "contact");
dto.CountryIsos = ToListOfSimpleLookups(2, "iso");
dto.Description = "desc";
dto.Goals = ToListOfSimpleLookups(4, "goal");
dto.Regions = list;
dto.Id = 1;
dto.Name = "name";
dto.ProgramStatusName = "status";
dto.ProgramStatusId = 100;
dto.OwnerDescription = "owner desc";
dto.OwnerName = "owner name";
dto.OwnerOrganizationId = 2;
dto.OwnerOfficeSymbol = "symbol";
dto.ParentProgramId = 3;
dto.ParentProgramName = "parent program";
dto.RegionIsos = ToListOfSimpleLookups(5, "region iso");
dto.RevisedOn = DateTimeOffset.UtcNow;
dto.RowVersion = new byte[1] {
(byte)1
};
dto.StartDate = DateTimeOffset.UtcNow.AddDays(-1.0);
dto.EndDate = DateTimeOffset.UtcNow.AddDays(1.0);
dto.Themes = ToListOfSimpleLookups(6, "theme");
var viewModel = new ProgramViewModel(dto);
Assert.AreEqual(dto.Description, viewModel.Description);
Assert.AreEqual(dto.Id, viewModel.Id);
Assert.AreEqual(dto.Name, viewModel.Name);
Assert.AreEqual(dto.OwnerDescription, viewModel.OwnerDescription);
Assert.AreEqual(dto.OwnerOrganizationId, viewModel.OwnerOrganizationId);
Assert.AreEqual(dto.OwnerOfficeSymbol, viewModel.OwnerOfficeSymbol);
Assert.AreEqual(dto.ParentProgramId, viewModel.ParentProgramId);
Assert.AreEqual(dto.ParentProgramName, viewModel.ParentProgramName);
Assert.AreEqual(dto.RevisedOn, viewModel.RevisedOn);
Assert.AreEqual(Convert.ToBase64String(dto.RowVersion), viewModel.RowVersion);
Assert.AreEqual(dto.StartDate, viewModel.StartDate);
Assert.AreEqual(dto.EndDate, viewModel.EndDate);
Assert.AreEqual(dto.ProgramStatusId, viewModel.ProgramStatusId);
Assert.AreEqual(dto.ProgramStatusName, viewModel.ProgramStatusName);
CollectionAssert.AreEqual(dto.Contacts.ToList(), viewModel.Contacts.ToList());
CollectionAssert.AreEqual(dto.CountryIsos.ToList(), viewModel.CountryIsos.ToList());
CollectionAssert.AreEqual(dto.Goals.ToList(), viewModel.Goals.ToList());
CollectionAssert.AreEqual(dto.RegionIsos.ToList(), viewModel.RegionIsos.ToList());
CollectionAssert.AreEqual(dto.Themes.ToList(), viewModel.Themes.ToList());
Assert.IsTrue(Object.ReferenceEquals(list, dto.Regions));
}
public ProgramEditViewModel(ProgramDTO program, bool shouldUpdateLocaly = false) : base(UIEnums.PageModes.Edit)
{
ShouldUpdateLocaly = shouldUpdateLocaly;
Program = program;
Drills = program.Drills.Select <ProgramDrillDTO, ProgramDrillViewModel>(currDrill =>
{
return(Converter.Convert <ProgramDrillViewModel>(currDrill, true));
}).ToList();
ProgramName = program.Name;
}
public ICollection <ProgramDTO> GetAllPrograms(ProgramDTO newProgram)
{
ActionResponse response = new ActionResponse();
ProgramRepository repository = RepositoriesFactory.CreateRepository <ProgramRepository, Program>();
ICollection <Program> wantedPrograms = repository.GetALL();
ICollection <ProgramDTO> ProgramDrills = wantedPrograms
.Select <Program, ProgramDTO>(currProgram => ConvertEntityTODTO(currProgram)).ToList();
return(ProgramDrills);
}
public bool Create(ProgramDTO program)
{
try
{
var data = MapperProfile.MapperConfig().Map <ProgramDTO, Program>(program);
_unitOfWork.ProgramRepository.Create(data);
return(_unitOfWork.Commit());
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
public async Task <int> AddProgram(ProgramDTO program)
{
if (program == null)
{
throw new ArgumentNullException($"Program cannot be null");
}
var newProgram = mapper.Map <Program>(program);
await _ctx.Programs.AddAsync(newProgram);
await _ctx.SaveChangesAsync();
return(newProgram.ProgramId);
}
public ActionResponse DeleteLocalProgram(ProgramDTO program)
{
ICollection <ProgramDTO> localProgram = GetLocalPrograms();
List <ProgramDTO> existingPrograms = localProgram.ToList();
existingPrograms.RemoveAt(program.LocalId);
SetLocalPrograms(existingPrograms);
return(new ActionResponse()
{
CompletedSuccessfully = true
});
}
public ActionResponse SetLocalProgram(ProgramDTO program)
{
ICollection <ProgramDTO> localProgram = GetLocalPrograms();
ProgramDTO[] existingPrograms = localProgram.ToArray();
existingPrograms[program.LocalId] = program;
SetLocalPrograms(existingPrograms);
return(new ActionResponse()
{
CompletedSuccessfully = true
});
}
public bool Edit(ProgramDTO program)
{
try
{
program.ProDateCreate = _unitOfWork.ProgramRepository.GetById(program.ID).ProDateCreate;
var data = MapperProfile.MapperConfig().Map <ProgramDTO, Program>(program);
_unitOfWork.ProgramRepository.Edit(data);
return(_unitOfWork.Commit());
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
public async Task <ProgramDTO> UpdateProgram(ProgramDTO programSrc)
{
var entityDest = await _ctx.Programs.FindAsync(programSrc.ProgramId);
if (entityDest != null)
{
entityDest.BaseFee = programSrc.BaseFee;
entityDest.Description = programSrc.Description;
entityDest.DurationDays = programSrc.DurationDays;
entityDest.Name = programSrc.Name;
}
await _ctx.SaveChangesAsync();
return(await Task.FromResult(programSrc));
}
public bool UpdateProgram(ProgramDTO program)
{
this.ConnectToDatabase();
string Query = "update PROGRAM set PROGRAM_ID='" + program.ProgramId + "',PROGRAM_NAME = '" + program.ProgramName + "',LEVEL = '" + program.Level + "',FEE = '" + program.Fee + "'";
//This is command class which will handle the query and connection object.
MySqlCommand command = new MySqlCommand(Query, mySQLConnection);
command.ExecuteNonQuery();
this.Close();
return(true);
}
public bool InsertProgram(ProgramDTO program)
{
this.ConnectToDatabase();
string Query = "insert into PROGRAM values('" + program.ProgramId + "','" + program.ProgramName + "','" + program.Level + "','" + program.Fee + "');";
//This is command class which will handle the query and connection object.
MySqlCommand command = new MySqlCommand(Query, mySQLConnection);
command.ExecuteNonQuery();
this.Close();
return(true);
}
public ActionResult Edit(ProgramDTO program)
{
var data = new ProgramDao(_unitOfWork).GetByid(program.ID);
ViewBag.TypeProgram = new TypeProgramDao(_unitOfWork).GetAll();
if (!ModelState.IsValid)
{
return(View(data));
}
if (new ProgramDao(_unitOfWork).Edit(program))
{
return(RedirectToAction("Index"));
}
TempData[MessageConst.ERROR] = "Edit Failed";
return(View(data));
}
public async Task <ActionResponse> DeleteProgram(ProgramDTO newProgram)
{
HttpRequestMessage request = await getRequest(HttpMethod.Delete, "programs/" + newProgram.Id);
HttpResponseMessage response = await getClient().SendAsync(request);
if (!response.IsSuccessStatusCode)
{
return(new ActionResponse()
{
ErrorMessage = "Operation failed program did not delete properly", CompletedSuccessfully = false
});
}
return(JsonConvert.DeserializeObject <ActionResponse>(await response.Content.ReadAsStringAsync()));
}
protected void CheckDigitalSignature(ProgramDTO program)
{
if (!File.Exists(program.FilePath))
{
Debug.WriteLine("File not found");
return;
}
X509Certificate2 theCertificate;
try
{
X509Certificate theSigner = X509Certificate.CreateFromSignedFile(program.FilePath);
theCertificate = new X509Certificate2(theSigner);
program.IsDigitalSignatureExists = true;
program.CompanyName = Parse(theCertificate.Subject, "CN").FirstOrDefault();
}
catch (Exception ex)
{
Debug.WriteLine("No digital signature found: " + ex.Message);
program.CompanyName = CompanyNameFromFileInfo(program.FilePath);
return;
}
var theCertificateChain = new X509Chain();
theCertificateChain.ChainPolicy.RevocationFlag = X509RevocationFlag.ExcludeRoot;
theCertificateChain.ChainPolicy.RevocationMode = X509RevocationMode.Offline;
theCertificateChain.ChainPolicy.UrlRetrievalTimeout = new TimeSpan(0, 1, 0);
theCertificateChain.ChainPolicy.VerificationFlags = X509VerificationFlags.NoFlag;
program.IsDigitalSignatureCorrect = theCertificateChain.Build(theCertificate);
if (program.IsDigitalSignatureCorrect)
{
Debug.WriteLine("Publisher Information : " + theCertificate.SubjectName.Name);
Debug.WriteLine("Valid From: " + theCertificate.GetEffectiveDateString());
Debug.WriteLine("Valid To: " + theCertificate.GetExpirationDateString());
Debug.WriteLine("Issued By: " + theCertificate.Issuer);
}
else
{
Debug.WriteLine("Chain Not Valid (certificate is self-signed)");
}
}
