internal void saveDissertation(Dissertation dissertation)
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("sp_StudentCreateDissertation", sqlConnection))
{
try
{
sqlConnection.Open();
command.CommandType = CommandType.StoredProcedure;
if (dissertation.Id == null)
command.Parameters.AddWithValue("@Id", DBNull.Value);
else
command.Parameters.AddWithValue("@Id", dissertation.Id);
command.Parameters.AddWithValue("@Attachement", dissertation.Attachement);
command.Parameters.AddWithValue("@StudentId", dissertation.StudentId);
command.Parameters.AddWithValue("@SubjectId", dissertation.SubjectId);
command.Parameters.AddWithValue("@Title", dissertation.Title);
command.Parameters.AddWithValue("@ShortDescription", dissertation.ShortDescription);
command.Parameters.AddWithValue("@Status", dissertation.Status);
command.Parameters.AddWithValue("@Category", dissertation.Category);
command.Parameters.AddWithValue("@Design", dissertation.Design);
//command.Parameters.AddWithValue("@DateBirth", user.DateBirth);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
}
}
public JsonResult FinalUpload(Dissertation newDissertation)
{
try
{
HttpPostedFile file = null;
if (System.Web.HttpContext.Current.Request.Files.AllKeys.Any())
{
file = System.Web.HttpContext.Current.Request.Files["HttpPostedFileBase"];
}
string stamp = string.Format("{0:yyyy-MM-dd_hh-mm-ss-tt}", DateTime.Now);
string filename = file.FileName.Split('.')[0] + stamp + "." + file.FileName.Split('.')[1];
string pic = System.IO.Path.GetFileName(filename);
string path = System.IO.Path.Combine(
Server.MapPath("~/Files/dissertations"), pic);
// file is uploaded
file.SaveAs(path);
newDissertation.Attachement = pic;
newDissertation.StudentId = User.Identity.GetUserId();
newDissertation.Save();
// after successfully uploading redirect the user
return(Json("Research uploaded", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("Failed!"));
}
}
public async Task Post([FromForm] Dissertation _dissertation)
{
if (Request.Form.Files.Count > 0)
{
File _file = new File
{
Name = await Classes.FileSave.Save(Request.Form.Files[0], 0).ConfigureAwait(false),
Type = 1,
CreateDate = GetDate,
StatusId = 1,
UserId = User_Id
};
await aztuAkademik.File.AddAsync(_file).ConfigureAwait(false);
await aztuAkademik.SaveChangesAsync().ConfigureAwait(false);
await Classes.TLog.Log("File", "", _file.Id, 1, User_Id, IpAdress, AInformation).ConfigureAwait(false);
_dissertation.FileId = _file.Id;
}
_dissertation.CreateDate = GetDate;
await aztuAkademik.Dissertation.AddAsync(_dissertation).ConfigureAwait(false);
await aztuAkademik.SaveChangesAsync().ConfigureAwait(false);
await Classes.TLog.Log("Dissertation", "", _dissertation.Id, 1, User_Id, IpAdress, AInformation).ConfigureAwait(false);
}
public ActionResult SetFinalStatus(int id)
{
try
{
DissertationViewModel dissertation = Dissertation.GetDissertationById(id);
dissertation.SaveStatus();
Certificate cert = new Certificate();
cert.StudentId = dissertation.StudentId;
cert.SubjectId = dissertation.SubjectId;
int certId = cert.Save();
var user = UserManager.FindById(dissertation.StudentId);
UserManager.AddToRole(user.Id, "Teacher");
var callbackUrl = Url.Action("Certificates", "Teacher", new { certId = certId }, protocol: Request.Url.Scheme);
string email = dissertation.Student.Email;
string body = string.Format("Dear {0} {1}, Your research was approved by administrator:</br> Follow the <a href='{2}'>link</a> to generate a certificate", dissertation.Student.Name, dissertation.Student.SurName, callbackUrl);
string subject = "SortIt.Research approved";
SendMailModel.SendMail(email, body, subject);
return(Json("Research approved"));
}
catch (Exception ex)
{
return(Json("Fail!", JsonRequestBehavior.AllowGet));
}
}
public static void Main()
{
JournalPaper paper = new JournalArticle();
paper.addAuthor(new Person("Ivan", "Ivanovich", "Ivanov"));
paper.Title = "Introduction to C#";
paper.PageCount = 90;
paper.Label = Labels.LabelNames.Electronic;
paper.JournalNumber = 15;
paper.JournalTitle = "Applied programming";
paper.Year = 2014;
paper.FirstPage = "51";
Dissertation disser = new Dissertation();
disser.Title = "First disser";
disser.addAuthor(new Person("Сергей", "Васильевич", "Петров"));
disser.Year = 2010;
disser.PageCount = 100;
disser.Degree = "Проф.";
disser.Publisher = "СПбГУ";
TexBibliographyWriter writer = TexBibliographyWriter.Instance;
writer.FileName = "test1.tex";
writer.PrepareBibliography(new Paper[] { paper, disser });
Console.WriteLine(disser.Title);
//Console.ReadKey(false);
}
public ActionResult Finals(int?id)
{
if (id == null)
{
id = Models.Subject.GetSubject(null).First().Id;
}
var finals = Dissertation.GetDissertationBySubjectId(Convert.ToInt32(id));
return(View(finals));
}
/// <summary>
/// Обработка изменения типа издания в выпадающем списке.
/// Отвечает за отображение нужных полей конкретного типа издания
/// </summary>
private void cmbEditionTypes_SelectedIndexChanged(object sender, EventArgs e)
{
editionType = (EditionTypes)(cmbEditionTypes.SelectedItem);
if (editionType == EditionTypes.Book)
{
lblUniversity.Visible = false;
txtUniversity.Visible = false;
lblDegree.Visible = false;
txtDegree.Visible = false;
lblSpecialityCode.Visible = false;
txtSpecialityCode.Visible = false;
lblPublishingHouse.Visible = true;
txtPublishingHouse.Visible = true;
lblLanguage.Visible = true;
cmbLanguages.Visible = true;
lblAuthors.Location = new Point(12, 175);
gridAuthors.Location = new Point(128, 172);
btnAddAuthor.Location = new Point(128, 172 + 92);
btnRemoveAuthor.Location = new Point(345, 172 + 92);
edition = new Book();
}
else
{
lblUniversity.Visible = true;
txtUniversity.Visible = true;
lblDegree.Visible = true;
txtDegree.Visible = true;
lblSpecialityCode.Visible = true;
txtSpecialityCode.Visible = true;
lblPublishingHouse.Visible = false;
txtPublishingHouse.Visible = false;
lblLanguage.Visible = false;
cmbLanguages.Visible = false;
lblAuthors.Location = new Point(12, 202);
gridAuthors.Location = new Point(128, 199);
btnAddAuthor.Location = new Point(128, 199 + 92);
btnRemoveAuthor.Location = new Point(345, 199 + 92);
while (dtAuthors.Rows.Count > 1)
{
dtAuthors.Rows.RemoveAt(dtAuthors.Rows.Count - 1);
}
edition = new Dissertation();
}
CheckAuthorsCount();
}
/// <summary>
/// Используется для создания диссертации
/// </summary>
/// <returns>Созданная диссертация</returns>
private static Dissertation CreateDissertation()
{
Dissertation disser = new Dissertation();
ShowInfo("Создание диссертации\n");
Person author = CreateAuthor();
disser.Authors = new List <Person> {
author
};
Console.WriteLine();
SetProperties(ref disser, new string[] { nameof(disser.Authors) });
return(disser);
}
/// <summary>
/// Получить диссертацию
/// </summary>
/// <returns>диссертация</returns>
private static IEdition GetRandomDissertation()
{
List <Author> authors = new List <Author>();
authors.Add(new Author(GetSurname(), GetInitials()));
var dissertation = new Dissertation()
{
Title = GetTitle(),
City = GetCity(),
Date = GetDate(),
Pages = _random.Next(1, 1000),
SpecialityCode = GetCode(),
Speciality = GetSpeciality(),
University = GetUniversity(),
Authors = authors
};
return(dissertation);
}
private void buttonGateDescription_Click(object sender, EventArgs e)
{
Model.ICatalogue catalogModel = null;
switch (_catalogue)
{
case 0:
catalogModel = new Standard(Convert.ToString(textBox1.Text), Convert.ToString(textBox2.Text), Convert.ToString(textBox3.Text), Convert.ToString(textBox4.Text), Convert.ToString(textBox23.Text), Convert.ToInt32(textBox5.Text), Convert.ToInt32(textBox6.Text));
break;
case 1:
catalogModel = new ElectronicResource(Convert.ToString(textBox7.Text), Convert.ToString(textBox8.Text), Convert.ToString(textBox9.Text), Convert.ToString(textBox10.Text), Convert.ToString(textBox11.Text), Convert.ToString(textBox12.Text), Convert.ToInt32(textBox13.Text), Convert.ToString(textBox14.Text));
break;
case 2:
catalogModel = new Dissertation(Convert.ToString(textBox15.Text), Convert.ToString(textBox16.Text), Convert.ToString(textBox17.Text), Convert.ToString(textBox18.Text), Convert.ToString(textBox19.Text), Convert.ToString(textBox20.Text), Convert.ToInt32(textBox21.Text), Convert.ToInt32(textBox22.Text));
break;
}
Catalog = catalogModel;
DialogResult = DialogResult.OK;
this.Close();
}
/// <summary>
/// Ввод параметров диссертации
/// </summary>
/// <returns>заполненное описание диссертации</returns>
private static Dissertation EnterDissertation()
{
var dissertation = new Dissertation();
var edition = EnterEdition(dissertation);
dissertation.Title = edition.Title;
dissertation.City = edition.City;
dissertation.Date = edition.Date;
dissertation.Pages = edition.Pages;
var authors = new List <Author>();
var actions = new List <Action>()
{
new Action(() =>
{
authors.Add(EnterAuthor());
dissertation.Authors = authors;
}),
new Action(() =>
{
Console.WriteLine("Введите код специальности " +
"(например 13.03.02)");
dissertation.SpecialityCode = Console.ReadLine();
}),
new Action(() =>
{
Console.WriteLine("Введите название специальности");
dissertation.Speciality = Console.ReadLine();
}),
new Action(() =>
{
Console.WriteLine("Введите название университета");
dissertation.University = Console.ReadLine();
}),
};
actions.ForEach(SetParameters);
return(dissertation);
}
internal Dissertation getDissertationByStudent(int subjectId, string studentId)
{
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("sp_UserGetDissertationByStudent", sqlConnection))
{
try
{
sqlConnection.Open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@SubjectId", subjectId);
command.Parameters.AddWithValue("@StudentId", studentId);
SqlDataReader rdr = command.ExecuteReader();
Dissertation dissertation = new Dissertation();
while (rdr.Read())
{
dissertation.Id = Convert.ToInt32(rdr["Id"]);
dissertation.StudentId = rdr["StudentId"].ToString();
dissertation.Attachement = rdr["Attachement"].ToString();
dissertation.SubjectId = Convert.ToInt32(rdr["SubjectId"]);
dissertation.Accepted = Convert.ToBoolean(rdr["Accepted"] == DBNull.Value ? false : rdr["Accepted"]);
dissertation.Category = rdr["Category"].ToString();
dissertation.Design = rdr["Design"].ToString();
dissertation.Title = rdr["Title"].ToString();
dissertation.ShortDescription = rdr["ShortDescription"].ToString();
dissertation.Status= rdr["Status"].ToString();
dissertation.CreateDate = Convert.ToDateTime(rdr["CreateDate"]);
}
return dissertation;
}
catch (Exception ex)
{
throw ex;
}
}
}
}
private void buttonFill_Click(object sender, EventArgs e)
{
Random rnd = new Random();
int style;
for (int i = 0; i < 3; i++)
{
style = rnd.Next(0, 3);
Model.ICatalogue catalogModel = null;
switch (_catalog)
{
case 0:
catalogModel = new Standard(Convert.ToString("ГОСТ 1759. 5 – 87"), Convert.ToString("Гайки. Механические свойства и методы"), Convert.ToString("Взамен ГОСТ 1759 – 70"), Convert.ToString("Введ. с 01.01.89 по 01.01.94"), Convert.ToString("Москва"), Convert.ToInt32("1998"), Convert.ToInt32("14"));
break;
case 1:
catalogModel = new ElectronicResource(Convert.ToString("Родников А.Р"), Convert.ToString("Логистика [Электронный ресурс]"), Convert.ToString("терминологический словарь"), Convert.ToString("А.Р. Родников"), Convert.ToString("Электронные данные"), Convert.ToString("Москва: ИНФРА - М"), Convert.ToInt32("2000"), Convert.ToString("1 эл. опт. диск (CD- ROM)"));
break;
case 2:
catalogModel = new Dissertation(Convert.ToString("Александров А.А"), Convert.ToString("Анализ и оценка оперативной обстановки в республике, крае, области (правовые и организационные аспекты)"), Convert.ToString("автореф. дис. на соиск. учен. степ. канд. юрид. наук"), Convert.ToString("12.00.11"), Convert.ToString("Александров Александр Александрович"), Convert.ToString("Москва"), Convert.ToInt32("2004"), Convert.ToInt32("2004"));
break;
}
Catalog = catalogModel;
DialogResult = DialogResult.OK;
_catalog = (rnd.Next(0, 3));
ICatalogue catalog = null;
catalog = Catalog;
ListCatalog.list.Add(catalog);
var row = _datatable.NewRow();
row[0] = catalog.Name;
row[1] = catalog.YearPublishing;
row[2] = catalog.GetDescription();
_datatable.Rows.Add(row);
}
}
static void Main(string[] args)
{
IBibliographicDescription[] figure = new IBibliographicDescription[4];
try
{
figure[0] = new Book("NTVP", "Metoda", "Garays D.V.", "TUSUR", "100");
figure[1] = new Collection("NTVP", "сб. основных нормативно-техн. док., действующих в обл. учета электроэнергии", "Garays D.V.", "TUSUR", "100");
figure[2] = new Dissertation("Исследование и разработка какой-то фигни", "дис. …канд. техн. наук", "Меркулов В.А.", "защищена 28.06.04", "утв. 10.09.04", "178");
figure[3] = new Magazine("Эксергетический метод", "основа анализа систем теплофикации с целью повышения их эффективности и конкурентоспособности", "Промышленная энергетика", "3", "17");
for (int i = 0; i < 4; i++)
{
Console.WriteLine(figure[i].Print);
}
}
catch (BibliographicExeption e)
{
Console.WriteLine("{0} Exception caught.", e);
}
//Console.WindowWidth = 120;
//Console.BufferWidth = 120;
//Console.WindowHeight = 40;
//Console.BufferHeight = 40;
Console.ReadKey();
}
private void buttonOK_Click(object sender, EventArgs e)
{
switch (ComboBoxSelected.SelectedIndex)
{
case 0:
{
Book book = new Book(this);
book.Show();
Hide();
break;
}
case 1:
{
MagazineArticle article = new MagazineArticle(this);
article.Show();
Hide();
break;
}
case 2:
{
DigestArticle article = new DigestArticle(this);
article.Show();
Hide();
break;
}
case 3:
{
NewspaperArticle article = new NewspaperArticle(this);
article.Show();
Hide();
break;
}
case 4:
{
Dissertation dis = new Dissertation(this);
dis.Show();
Hide();
break;
}
case 5:
{
Abstract abs = new Abstract(this);
abs.Show();
Hide();
break;
}
case 6:
{
InternetResource res = new InternetResource(this);
res.Show();
Hide();
break;
}
default:
break;
}
}
public void AddDissertation(Dissertation dissertation)
{
_dissertations.Add(dissertation);
}
public void EditDissertation(Dissertation dissertation)
{
_dissertations.AddOrUpdate(c => c.Id, dissertation);
}
