private void GetBadge()
{
var badgeId = db.badge.Where(p => p.moduleId == moduleId).Select(p => p.badgeId).FirstOrDefault();
var resultTest = db.result.Where(p => p.userId == MainWindow.userIdToTest && p.badgeId == badgeId).Any();
if (resultTest)
{
var image = ConvertToImage.ToImage(db.badge.Where(p => p.moduleId == moduleId).Select(p => p.badgeImage).FirstOrDefault());
badgeImage.Source = image;
dialogEnd.IsOpen = true;
}
else
{
var image = ConvertToImage.ToImage(db.badge.Where(p => p.moduleId == moduleId).Select(p => p.badgeImage).FirstOrDefault());
badgeImage.Source = image;
dialogEnd.IsOpen = true;
result finishTest = new result
{
badgeId = badgeId,
userId = MainWindow.userIdToTest
};
db.result.Add(finishTest);
db.SaveChanges();
}
}
private void GetModule()
{
var module = db.module.Where(p => p.moduleId == moduleID).ToList();
moduleName.Text = module.Select(p => p.moduleName).FirstOrDefault();
imageArray = module.Select(p => p.moduleImage).FirstOrDefault();
moduleImage.ImageSource = ConvertToImage.ToImage(imageArray);
rtbEditor.AppendText(module.Select(p => p.description).FirstOrDefault());
}
private void GetModule()
{
var submodule = db.submodule.Where(p => p.submoduleId == submoduleID).ToList();
submoduleName.Text = submodule.Select(p => p.submoduleName).FirstOrDefault();
imageArray = submodule.Select(p => p.submoduleImage).FirstOrDefault();
submoduleImage.ImageSource = ConvertToImage.ToImage(imageArray);
rtbEditor.AppendText(submodule.Select(p => p.submoduleText).FirstOrDefault());
}
// Start is called before the first frame update
void Awake()
{
videoPlayer = GetComponent <VideoPlayer>();
converToImage = GetComponent <ConvertToImage>();
videoPlayer.clip = videoClip;
TotalFrame = videoPlayer.frameCount;
//videoPlayer.Stop();
}
private void addImage_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
dlg.InitialDirectory = "";
dlg.Filter = "Image files (*.jpg,*.png,*.bmp)|*.jpg;*.png;*.bmp|All Files (*.*)|*.*";
if (dlg.ShowDialog() == true)
{
string selectedFileName = dlg.FileName;
imageArray = ConvertToImage.ConvertImageToByteArray(selectedFileName);
image = ConvertToImage.ToImage(imageArray);
moduleImage.ImageSource = image;
}
}
private void uploadPhoto_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
dlg.InitialDirectory = "";
dlg.Filter = "Image files (*.jpg,*.png,*.bmp)|*.jpg;*.png;*.bmp|All Files (*.*)|*.*";
if (dlg.ShowDialog() == true)
{
string selectedFileName = dlg.FileName;
var profilePhoto = db.users.Where(p => p.userId == MainWindow.userIdToTest).FirstOrDefault();
profilePhoto.userPhoto = ConvertToImage.ConvertImageToByteArray(selectedFileName);
db.SaveChanges();
GetInfo(MainWindow.userIdToTest);
mainWindow.ReloadPhoto();
}
}
private void GetInfo(int userId)
{
fullname.Text = $"{db.users.Where(p => p.userId == MainWindow.userIdToTest).Select(p => p.firstname).FirstOrDefault()} {db.users.Where(p => p.userId == MainWindow.userIdToTest).Select(p => p.surname).FirstOrDefault()}";
dob.Text = $"Дата рождения: {db.users.Where(p => p.userId == MainWindow.userIdToTest).Select(p => p.dob).FirstOrDefault():d}";
sex.Text = $"Пол: {db.users.Where(p => p.userId == MainWindow.userIdToTest).Select(p => p.sex).FirstOrDefault()}";
profilePhoto.ImageSource = ConvertToImage.ToImage(db.users.Where(p => p.userId == MainWindow.userIdToTest).Select(p => p.userPhoto).FirstOrDefault());
var result = (from PR in db.badge
join OD in db.result on PR.badgeId equals OD.badgeId
where PR.badgeId == OD.badgeId && OD.userId == userId
select new
{
badgeImage = PR.badgeImage,
badgeName = PR.badgeName
}).ToList();
badgeList.ItemsSource = result;
}
private async void btLogin_Click(object sender, RoutedEventArgs e)
{
if (tbLogin.Text != "" && tbPassword.Password != "")
{
string username = tbLogin.Text;
string password = tbPassword.Password;
using (CoursesContext context = new CoursesContext())
{
var user = await(context.users.FirstOrDefaultAsync(u => u.userLogin == username));
var userId = await(context.users.Where(u => u.userLogin == username).Select(u => u.userId).ToArrayAsync());
if (user != null)
{
if (PBKDF2HashHelper.VerifyPassword(tbPassword.Password, user.userPassword))
{
tbLoginMain.Text = username;
tbNameMain.Text = $"{context.users.Where(p => p.userLogin == username).Select(p => p.firstname).FirstOrDefault()} {context.users.Where(p => p.userLogin == username).Select(p => p.surname).FirstOrDefault()}";
if (context.users.Where(p => p.userLogin == username).Select(p => p.userPhoto).FirstOrDefault() != null)
{
profileIcon.ImageSource = ConvertToImage.ToImage(context.users.Where(p => p.userLogin == username).Select(p => p.userPhoto).FirstOrDefault());
noPhoto.Visibility = Visibility.Collapsed;
}
dialogAuth.IsOpen = false;
back.Visibility = Visibility.Collapsed;
userIdToTest = userId[0];
}
else
{
tbError.Visibility = Visibility.Visible;
}
}
else
{
tbNot.Visibility = Visibility.Visible;
}
}
}
else
{
tbNotNullLogin.Visibility = Visibility.Visible;
}
}
public void ReloadPhoto()
{
db = new CoursesContext();
profileIcon.ImageSource = ConvertToImage.ToImage(db.users.Where(p => p.userId == userIdToTest).Select(p => p.userPhoto).FirstOrDefault());
noPhoto.Visibility = Visibility.Collapsed;
}
public static void Main(string[] args)
{
//// ***********************************************************
//// GroupDocs.Conversion Cloud API Examples
//// ***********************************************************
//TODO: Get your ClientId and ClientSecret at https://dashboard.groupdocs.cloud (free registration is required).
Constants.MyClientId = "XXXX-XXXX-XXXX-XXXX";
Constants.MyClientSecret = "XXXXXXXXXXXXXXXX";
// Uploading sample test files from local disk to cloud storage
Constants.UploadSampleTestFiles();
#region Info API Examples
GetSupportedConversions.Run();
GetDocumentInformation.Run();
#endregion
#region License API Examples
GetLicenseConsumption.Run();
#endregion
#region Document conversion examples with conversion options
ConvertToPdf.Run();
ConvertToPdfResponseBody.Run();
ConvertToWordProcessing.Run();
ConvertToHtml.Run();
ConvertToImage.Run();
ConvertToPresentation.Run();
ConvertToSpreadsheet.Run();
ConvertToPdfDirect.Run();
ConvertToPdfDirectOptions.Run();
#endregion
#region Document conversion examples with common options
AddWatermark.Run();
ConvertConsecutivePages.Run();
ConvertSpecificPages.Run();
ConvertUsingCustomFont.Run();
#endregion
#region Document conversion examples with loading options
ConvertCadAndSpecifyLoadOptions.Run();
ConvertCsvByConvertingDateTimeAndNumericData.Run();
ConvertCsvBySpecifyingDelimiter.Run();
ConvertCsvBySpecifyingEncoding.Run();
ConvertEmailWithAlteringFieldsVisibility.Run();
ConvertEmailWithAttachments.Run();
ConvertEmailWithTimezoneOffset.Run();
ConvertEmailWithFieldLabels.Run();
ConvertEmailWithOriginalDate.Run();
ConvertHtmlWithPageNumbering.Run();
ConvertNoteBySpecifyingFontSubstitution.Run();
ConvertPdfAndFlattenAllFields.Run();
ConvertPdfAndHideAnnotations.Run();
ConvertPdfAndRemoveEmbeddedFiles.Run();
ConvertPresentationByHidingComments.Run();
ConvertPresentationBySpecifyingFontSubstitution.Run();
ConvertPresentationWithHiddenSlidesIncluded.Run();
ConvertSpreadsheetAndHideComments.Run();
ConvertSpreadsheetByShowingGridLines.Run();
ConvertSpreadsheetBySkippingEmptyRowsAndColumns.Run();
ConvertSpreadsheetBySpecifyingFontsubstitution.Run();
ConvertSpreadsheetBySpecifyingRange.Run();
ConvertSpreadsheetWithHiddenSheetsIncluded.Run();
ConvertTxtByControllingLeadingSpacesBehavior.Run();
ConvertTxtByControllingTrailingSpacesBehavior.Run();
ConvertTxtBySpecifyingEncoding.Run();
ConvertWordProcessingByHidingComments.Run();
ConvertWordProcessingByHidingTrackedChanges.Run();
ConvertWordProcessingBySpecifyingFontSubstitution.Run();
#endregion
Console.WriteLine("Completed!");
Console.ReadKey();
}
