/// <summary>
/// Подтверждение статьи
/// </summary>
/// <param name="articleId"></param>
public void ConfirmArticle(int articleId)
{
var article = _context.Articles.SingleOrDefault(a => a.ArticleId == articleId);
article.RowStatusId = (int)RowStatusEnum.Confirmed;
_context.SaveChanges();
}
/// <summary>
/// Обновляет научный журнал
/// </summary>
/// <param name="scienceJournalEntry"></param>
/// <param name="scienceJournal"></param>
public void UpdateScienceJournal(ScienceJournal scienceJournalEntry, ScienceJournal scienceJournal)
{
scienceJournalEntry.ScienceJournalName = scienceJournal.ScienceJournalName;
scienceJournalEntry.IsVak = scienceJournal.IsVak;
scienceJournalEntry.IsZarubejn = scienceJournal.IsZarubejn;
scienceJournalEntry.ELibraryLink = scienceJournal.ELibraryLink;
scienceJournalEntry.ScienceJournalCitationBases = scienceJournal.ScienceJournalCitationBases;
if (scienceJournal.ScienceJournalCitationBases != null && scienceJournal.ScienceJournalCitationBases.Count > 0)
{
foreach (var scienceJournalCitationBases in scienceJournal.ScienceJournalCitationBases)
{
bool isExists = false;
foreach (var scienceJournalCitationBasesEntry in scienceJournalEntry.ScienceJournalCitationBases)
{
if (scienceJournalCitationBasesEntry.CitationBaseId == scienceJournalCitationBases.CitationBaseId)
{
isExists = true;
}
}
if (!isExists)
{
scienceJournalEntry.ScienceJournalCitationBases.Add(scienceJournalCitationBases);
}
}
}
_context.SaveChanges();
}
public IActionResult Create(AbiturientStatus abiturientStatus)
{
_context.AbiturientStatuses.Add(abiturientStatus);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
/// <summary>
/// Подтверждение патента (свидетельства)
/// </summary>
/// <param name="patentId"></param>
/// <returns></returns>
public void ConfirmPatent(int patentId)
{
var patent = _context.Patents.SingleOrDefault(p => p.PatentId == patentId);
patent.RowStatusId = (int)RowStatusEnum.Confirmed;
_context.SaveChanges();
}
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "ID,ComicName,Company,Year")] Comic comic)
{
if (ModelState.IsValid)
{
db.Comics.Add(comic);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(comic));
}
public ActionResult Create([Bind(Include = "ID,Title,Description,VideoLink,tags,isApproved")] Video video)
{
if (ModelState.IsValid)
{
db.Videos.Add(video);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(video));
}
public ActionResult Create([Bind(Include = "ID,GameName,Year,Platform,Approved")] Game game)
{
if (ModelState.IsValid)
{
game.Approved = "false";
db.Games.Add(game);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(game));
}
public ActionResult Register(User u)
{
if (ModelState.IsValid)
{
var checkUser = db.Users.Where(x => x.Username == u.Username).Count();
if (checkUser == 0)
{
using (AppIdentityDBContext db = new AppIdentityDBContext())
{
u.Role = "p";
u.Approved = "pending";
db.Users.Add(u);
db.SaveChanges();
ModelState.Clear();
u = null;
ViewBag.Msg = "Successfully registered.";
}
}
else
{
ViewBag.Msg = "That username is already taken, try another one.";
return(View(u));
}
}
return(View(u));
}
public ApplicationUser Create(ApplicationUser user, string password)
{
if (string.IsNullOrWhiteSpace(password))
{
throw new Exception("Password is required");
}
if (context.Users.Any(x => x.Username == user.Username))
{
throw new Exception($"Username \"{user.Username}\" is already taken");
}
byte[] passwordHash, passwordSalt;
CreatePasswordHash(password, out passwordHash, out passwordSalt);
user.PasswordHash = passwordHash;
user.PasswordSalt = passwordSalt;
context.Users.Add(user);
context.SaveChanges();
dataContext.ChatUsers.Add(new ChatUser {
LoginName = user.Username,
NikName = $"{user.LastName} {user.FirstName}"
});
dataContext.SaveChanges();
return(user);
}
public IActionResult SendMessagesToStudents(int id, int?StructFacultetId, string message)
{
var userSenderId = _context.Users.FirstOrDefault(u => u.UserName == User.Identity.Name).Id;
var students = _context.Students.Where(s => s.StudentGroupId == id).ToList();
var messages = new List <UserMessage>();
foreach (var student in students)
{
var userMessage = new UserMessage {
UserSenderId = userSenderId,
UserReceiverId = student.AppUserId,
UserMessageText = message,
UserMessageDate = DateTime.Now
};
messages.Add(userMessage);
}
_context.UserMessages.AddRange(messages);
_context.SaveChanges();
if (StructFacultetId != null)
{
return(RedirectToAction(nameof(StudentGroupsOfFacultet), new { StructFacultetId }));
}
else
{
return(RedirectToAction(nameof(Index)));
}
}
public async Task <IActionResult> AddFile(IFormFile uploadedFile, int[] SelectedFileDataTypeIds, FileModel fileModel)
{
if (uploadedFile != null)
{
string fileName = /*DateTime.Now.ToString("yyyy-MM-dd-") +*/
Guid.NewGuid().ToString() +
Path.GetExtension(uploadedFile.FileName);
// путь к папке files
string[] paths = { _appEnvironment.WebRootPath, "files", fileName };
string path = Path.Combine(paths);
// сохраняем файл в папку files в каталоге wwwroot
using (var fileStream = new FileStream(path, FileMode.Create))
{
await uploadedFile.CopyToAsync(fileStream);
}
fileModel.FileName = Path.GetFileName(uploadedFile.FileName);
//fileModel.Path = path;
fileModel.Path = Path.Combine("files", fileName);
if (Path.GetExtension(uploadedFile.FileName) == ".pdf")
{
fileModel.ContentType = "application/pdf";
}
_context.Files.Add(fileModel);
_context.SaveChanges();
// Добавляем привязку к списку типов файлов
foreach (var selectedFileDataTypeId in SelectedFileDataTypeIds)
{
FileToFileType newElement = new FileToFileType();
newElement.FileDataTypeId = selectedFileDataTypeId;
newElement.FileModelId = fileModel.Id;
_context.FileToFileTypes.Add(newElement);
}
_context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public bool Save(Post entity)
{
if (entity.Body == null)
{
return(false);
}
else
{
entity.IsDeleted = false;
_context.Posts.Add(entity);
_context.SaveChanges();
return(true);
}
}
/// <summary>
/// Добавляет новый объект типа ExternalResource
/// </summary>
/// <param name="externalResource"></param>
public void AddExternalResource(ExternalResource externalResource)
{
_context.ExternalResources.Add(externalResource);
_context.SaveChanges();
}
/// <summary>
/// Создаёт pdf-файл протокола вступительных испытаний
/// и возвращает путь к созданному файлу
/// </summary>
/// <param name="entranceTestsProtocol"></param>
/// <returns></returns>
public string GenerateEntranceTestsProtocol(EntranceTestsProtocol entranceTestsProtocol,
string userPhotoPath)
{
#region Free Spire.PDF
//Create a pdf document.
PdfDocument doc = new PdfDocument();
// Create one page
PdfPageBase page = doc.Pages.Add();
PrintShapka(page);
page.Canvas.DrawString("ПРОТОКОЛ ВСТУПИТЕЛЬНЫХ ИСПЫТАНИЙ № ____",
FontUtf_TNR_16_b,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
280, 150,
new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle));
int y = 190;
int dy = 25;
page.Canvas.DrawString("Фамилия: " + entranceTestsProtocol.Abiturient.AppUser.LastName,
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
20, y,
new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle));
y += dy;
page.Canvas.DrawString("Имя: " + entranceTestsProtocol.Abiturient.AppUser.FirstName,
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
20, y,
new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle));
y += dy;
page.Canvas.DrawString("Отчество: " + entranceTestsProtocol.Abiturient.AppUser.Patronymic,
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
20, y,
new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle));
y += dy;
page.Canvas.DrawString("Дата выдачи: " + entranceTestsProtocol.DataVidachi.ToString("dd.MM.yyyy"),
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
20, y,
new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle));
//Draw the image
if (!string.IsNullOrWhiteSpace(userPhotoPath))
{
PdfImage image = PdfImage.FromFile(Path.Combine(_appEnvironment.WebRootPath, userPhotoPath));
float y_to_x_coeff = (float)image.Height / image.Width;
page.Canvas.DrawImage(image, 40, 290, 100, 100 * y_to_x_coeff);
}
y += 50;
page.Canvas.DrawString("и.о. Ответственный секретарь приёмной комиссии",
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
160, y,
new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle));
y += 50;
page.Canvas.DrawString("______________________________ В.П. Скворцов",
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
160, y,
new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle));
y += 110;
page.Canvas.DrawString("РЕЗУЛЬТАТЫ ВСТУПИТЕЛЬНЫХ ИСПЫТАНИЙ",
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
280, y,
new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle));
y += 40;
page.Canvas.DrawString("Предмет",
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
60, y,
new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle));
page.Canvas.DrawString("Результаты вступительных",
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
230, y - 7,
new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle));
page.Canvas.DrawString("испытаний, баллов",
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
230, y + 7,
new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle));
page.Canvas.DrawString("Дата проведения",
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
420, y - 7,
new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle));
page.Canvas.DrawString("вступительных испытаний",
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
420, y + 7,
new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle));
int y_top_line = y - 15;
page.Canvas.DrawLine(new PdfPen(new PdfRGBColor(0, 0, 0)), 20, y_top_line, 510, y_top_line);
page.Canvas.DrawLine(new PdfPen(new PdfRGBColor(0, 0, 0)), 20, y + 15, 510, y + 15);
for (int i = 0; i < (entranceTestsProtocol.Abiturient.EntranceTestRegistrationForms?.Count ?? 0); i++)
{
y += dy;
page.Canvas.DrawString(entranceTestsProtocol.Abiturient.EntranceTestRegistrationForms[i].DisciplineName,
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
25, y,
new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle));
page.Canvas.DrawString(entranceTestsProtocol.Abiturient.EntranceTestRegistrationForms[i].EntranceTestResult ?? "",
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
230, y,
new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle));
page.Canvas.DrawString(entranceTestsProtocol.Abiturient.EntranceTestRegistrationForms[i].Date.ToString("dd.MM.yyyy"),
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
420, y,
new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle));
page.Canvas.DrawLine(new PdfPen(new PdfRGBColor(0, 0, 0)), 20, y + 15, 510, y + 15);
// Формируем вертикальные линии
if (i == entranceTestsProtocol.Abiturient.EntranceTestRegistrationForms.Count - 1)
{
page.Canvas.DrawLine(new PdfPen(new PdfRGBColor(0, 0, 0)), 20, y_top_line, 20, y + 15);
page.Canvas.DrawLine(new PdfPen(new PdfRGBColor(0, 0, 0)), 140, y_top_line, 140, y + 15);
page.Canvas.DrawLine(new PdfPen(new PdfRGBColor(0, 0, 0)), 330, y_top_line, 330, y + 15);
page.Canvas.DrawLine(new PdfPen(new PdfRGBColor(0, 0, 0)), 510, y_top_line, 510, y + 15);
}
}
/////////////////////////////////////////////////////////////////////////////////////
y += dy * 2;
page.Canvas.DrawString("Члены комиссии",
FontUtf_TNR_14,
new PdfSolidBrush(new PdfRGBColor(0, 0, 0)),
20, y,
new PdfStringFormat(PdfTextAlignment.Left, PdfVerticalAlignment.Middle));
y += 10;
for (int i = 0; i < 7; i++)
{
page.Canvas.DrawLine(new PdfPen(new PdfRGBColor(0, 0, 0)), 220, y, 320, y);
page.Canvas.DrawLine(new PdfPen(new PdfRGBColor(0, 0, 0)), 350, y, 510, y);
y += 15;
}
///////////////////////////////////////////////////////////////////////////////////////
string fileName = "EntranceTestsProtocol_" +
Guid.NewGuid().ToString() +
".pdf";
// путь к папке files
string[] paths = { _appEnvironment.WebRootPath, "tmp", fileName };
string pathToDirectory = Path.Combine(paths[0], paths[1]);
if (!Directory.Exists(pathToDirectory))
{
Directory.CreateDirectory(pathToDirectory);
}
string path = Path.Combine(paths);
doc.SaveToFile(path);
doc.Close();
// Если файл существует, удаляем его
if (!string.IsNullOrWhiteSpace(entranceTestsProtocol.FileName))
{
string oldFilePath = Path.Combine(paths[0], entranceTestsProtocol.FileName);
if (File.Exists(oldFilePath))
{
File.Delete(oldFilePath);
}
}
string newFileName = Path.Combine(paths[1], paths[2]);
entranceTestsProtocol.FileName = newFileName;
_context.SaveChanges();
return(newFileName);
#endregion
}
/// <summary>
/// Обновляет закрепление дисциплины за преподавателем
/// </summary>
/// <param name="teacherDisciplineNameEntry"></param>
public void UpdateTeacherDisciplineName(TeacherEduProfileDisciplineName teacherDisciplineNameEntry)
{
_context.Update(teacherDisciplineNameEntry);
_context.SaveChanges();
}
/// <summary>
/// Добавляет статью пользователя userName
/// </summary>
/// <param name="article"></param>
/// <param name="userName"></param>
public void CreateArticle(Article article, string userName)
{
if (article.ArticleId != 0)
{
return;
}
AppUser appUser = GetAppUser(userName);
Author author = appUser.Author.FirstOrDefault();
if (author == null)
{
author = new Author
{
AppUserId = appUser.Id,
AuthorName = appUser.GetFullName
};
_context.Author.Add(author);
//_context.SaveChanges();
}
if (author.AuthorId == 0)
{
return;
}
_context.Articles.Add(article);
ArticleAuthor articleAuthor = new ArticleAuthor
{
ArticleId = article.ArticleId,
AuthorId = author.AuthorId,
AuthorPart = 1
};
_context.ArticleAuthors.Add(articleAuthor);
_context.SaveChanges();
}
/// <summary>
/// Добавляет монографию
/// </summary>
/// <returns></returns>
public void AddMonograf(Monograf monograf)
{
_context.Monografs.Add(monograf);
_context.SaveChanges();
}