protected void Page_Load(object sender, EventArgs e)
{
KodProblemu = Request.QueryString["KodProblemu"];
if (!Page.IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
}
var db = new DataBase.DataClasses1DataContext();
//wypisanie języków
var query2 = from n in db.Languages select n.Name;
foreach (var jezyk in query2)
{
Languages.Items.Add(jezyk);
}
///////////////////
if (KodProblemu != null)
{
var query1 = from n in db.Problems where n.ProblemsCode == KodProblemu select n;
DataBase.Problem ExistingProblem = query1.First();
ProblemsCode.Text = ExistingProblem.ProblemsCode;
}
}
protected void Page_Load(object sender, EventArgs e)
{
KodProblemu = Request.QueryString["KodProblemu"];
if (KodProblemu == null)
{
Response.Redirect("~/Default.aspx");
return;
}
SolveProblemLink.NavigateUrl = "~/User/SolveProblem.aspx?KodProblemu=" + KodProblemu;
var db = new DataBase.DataClasses1DataContext();
var query = from n in db.Problems where n.ProblemsCode == KodProblemu select n;
var ExistingProblem = query.First();
ProblemsTitle.Text = ExistingProblem.Title;
ProblemsCode.Text = ExistingProblem.ProblemsCode;
ProblemsDescription.Text = ExistingProblem.Description;
ProblemsInfo.Rows[0].Cells[1].Text = ExistingProblem.AddedBy;
ProblemsInfo.Rows[1].Cells[1].Text = ExistingProblem.AddingDate.ToShortDateString();
ProblemsInfo.Rows[2].Cells[1].Text = ExistingProblem.DifficultyLevel;
ProblemsInfo.Rows[3].Cells[1].Text = ExistingProblem.TimeLimit.ToString() + " s";
ProblemsInfo.Rows[4].Cells[1].Text = ExistingProblem.SizeLimit.ToString() + " B";
ProblemsInfo.Rows[5].Cells[1].Text = ExistingProblem.Languages.Replace(';', ' ');
}
protected void DropButton_Command(object sender, CommandEventArgs e)
{
using (var db = new DataBase.DataClasses1DataContext(WebConfigurationManager.ConnectionStrings["dziennikucznia_studentlive_plConnectionString"].ConnectionString))
{
var student = (from s in db.aspnet_Memberships where s.UserId == new Guid(e.CommandArgument.ToString()) select s).FirstOrDefault();
student.GroupId = -1;
db.SubmitChanges();
BindData();
}
}
protected void AddUserToGroup(object sender, CommandEventArgs e)
{
string id = Request.QueryString["id"];
using (var db = new DataBase.DataClasses1DataContext(WebConfigurationManager.ConnectionStrings["dziennikucznia_studentlive_plConnectionString"].ConnectionString))
{
var student = (from s in db.aspnet_Memberships where s.UserId == new Guid(e.CommandArgument.ToString()) select s).FirstOrDefault();
student.GroupId = Convert.ToInt32(id);
db.SubmitChanges();
BindData();
}
}
protected void AddGroupButton_Click(object sender, EventArgs e)
{
using (var db = new DataBase.DataClasses1DataContext(WebConfigurationManager.ConnectionStrings["dziennikucznia_studentlive_plConnectionString"].ConnectionString))
{
Group @group = new Group();
@group.Name = GroupNameTextBox.Text;
db.Groups.InsertOnSubmit(@group);
db.SubmitChanges();
GroupNameRepeater.DataBind();
}
}
private List<StudentInGroup> getStudentInGroup(int id)
{
List<StudentInGroup> list = new List<StudentInGroup>();
using (var db = new DataBase.DataClasses1DataContext(WebConfigurationManager.ConnectionStrings["dziennikucznia_studentlive_plConnectionString"].ConnectionString))
{
var students = from s in db.aspnet_Memberships where s.GroupId == id select s;
foreach (var s in students)
{
list.Add(new StudentInGroup(s.aspnet_User.UserName, s.Email, s.UserId));
}
}
return list;
}
protected void EditProblemX_Click(object sender, EventArgs e)
{
// dodawanie nowego zadania /////////////////////////////////////////////////////////////////
if (KodProblemu == null)
{
if (Page.IsValid)
{
string inputs = "";
string outputs = "";
if (CSVinputs != null && CSVoutputs != null)
{
inputs = CSVinputs;
outputs = CSVoutputs;
}
else
{
for (int i = 1; i < InOut.Rows.Count; i++)
{
TextBox Input = (TextBox)InOut.Rows[i].Cells[1].Controls[0];
TextBox Output = (TextBox)InOut.Rows[i].Cells[2].Controls[0];
if ((Input.Text == "" && Output.Text != "") || (Input.Text != "" && Output.Text == ""))
{
EditSuccessful.Text = "Niektóre z twoich par wej-wyj są niekompletne!";
EditSuccessful.Visible = true;
return;
}
else if (Input.Text == "" && Output.Text == "")
{
continue;
}
inputs += Input.Text + ";";
outputs += Output.Text + ";";
}
}
if (inputs == "")
{
EditSuccessful.Text = "Nie podałeś sekwencji wyjściowych!";
EditSuccessful.Visible = true;
return;
}
else if (outputs == "")
{
EditSuccessful.Text = "Nie podałeś sekwencji wejściowych!";
EditSuccessful.Visible = true;
return;
}
var db = new DataBase.DataClasses1DataContext();
DataBase.Problem NewProblem = new DataBase.Problem();
NewProblem.Title = ProblemsTitle.Text;
NewProblem.ProblemsCode = ProblemsCode.Text;
NewProblem.Description = Editor.Content;
NewProblem.DifficultyLevel = DifficultyLevel.SelectedItem.Text;
//pobranie dozwolonych języków programowania z kontrolki CheckBoxList do
//stringu languages
string languages = "";
for (int i = 0; i < Languages.Items.Count; i++)
{
if (Languages.Items[i].Selected)
{
languages += Languages.Items[i].Text + ";";
}
}
//zbieranie grup
string groups = "";
for (int i = 0; i < Groups.Items.Count; i++)
{
groups += Groups.Items[i].Text + ";";
}
//sprawdzenie czy został wybrany jakikolwiek język programowania
if (languages == "")
{
EditSuccessful.Text = "Wybierz przynajmniej jeden dozwolony język programowania";
EditSuccessful.Visible = true;
return;
}
NewProblem.Input = inputs;
NewProblem.Output = outputs;
NewProblem.Languages = languages;
NewProblem.TimeLimit = int.Parse(TimeLimit.Text);
NewProblem.SizeLimit = int.Parse(SizeLimit.Text);
NewProblem.OpeningDate = Convert.ToDateTime(OpeningDate.Text + " " + Convert.ToString(OpeningTime.Date.TimeOfDay));
NewProblem.ClosingDate = Convert.ToDateTime(ClosingDate.Text + " " + Convert.ToString(ClosingTime.Date.TimeOfDay));
NewProblem.AddingDate = DateTime.Now;
NewProblem.AddedBy = "Admin";
NewProblem.Groups = groups;
db.Problems.InsertOnSubmit(NewProblem);
db.SubmitChanges();
}
}
// edycja istniejącego zadania /////////////////////////////////////////////////////////////////////////
else
{
if (Page.IsValid)
{
string newInput = "";
string newOutput = "";
if (CSVinputs != null && CSVoutputs != null)
{
newInput = CSVinputs;
newOutput = CSVoutputs;
}
else
{
for (int i = 1; i < InOut.Rows.Count; i++)
{
TextBox Input = (TextBox)InOut.Rows[i].Cells[1].Controls[0];
TextBox Output = (TextBox)InOut.Rows[i].Cells[2].Controls[0];
if ((Input.Text == "" && Output.Text != "") || (Input.Text != "" && Output.Text == ""))
{
EditSuccessful.Text = "Niektóre z twoich par wej-wyj są niekompletne!";
EditSuccessful.Visible = true;
return;
}
else if (Input.Text == "" && Output.Text == "")
{
continue;
}
newInput += Input.Text + ";";
newOutput += Output.Text + ";";
}
}
if (newOutput == "")
{
EditSuccessful.Text = "Nie podałeś sekwencji wyjściowych!";
EditSuccessful.Visible = true;
return;
}
else if (newInput == "")
{
EditSuccessful.Text = "Nie podałeś sekwencji wejściowych!";
EditSuccessful.Visible = true;
return;
}
var db = new DataBase.DataClasses1DataContext();
var query = from n in db.Problems where n.ProblemsCode == KodProblemu select n;
var ExistingProblem = query.First();
ExistingProblem.Title = ProblemsTitle.Text;
ExistingProblem.ProblemsCode = ProblemsCode.Text;
ExistingProblem.Description = Editor.Content;
ExistingProblem.DifficultyLevel = DifficultyLevel.SelectedItem.Text;
ExistingProblem.Input = newInput;
ExistingProblem.Output = newOutput;
//pobranie dozwolonych języków programowania z kontrolki CheckBoxList do
//stringu languages
string languages = "";
for (int i = 0; i < Languages.Items.Count; i++)
{
if (Languages.Items[i].Selected == true)
{
languages += Languages.Items[i].Text + ";";
}
}
//sprawdzenie czy został wybrany jakikolwiek język programowania
if (languages == "")
{
EditSuccessful.Text = "Wybierz przynajmniej jeden dozwolony język programowania";
EditSuccessful.Visible = true;
return;
}
ExistingProblem.Languages = languages;
//zbieranie grup
string groups = "";
for (int i = 0; i < Groups.Items.Count; i++)
{
if (Groups.Items[i].Selected == true)
{
groups += Groups.Items[i].Text + ";";
}
}
ExistingProblem.Groups = groups;
ExistingProblem.TimeLimit = int.Parse(TimeLimit.Text);
ExistingProblem.SizeLimit = int.Parse(SizeLimit.Text);
ExistingProblem.OpeningDate = Convert.ToDateTime(OpeningDate.Text + " " + Convert.ToString(OpeningTime.Date.TimeOfDay));
ExistingProblem.ClosingDate = Convert.ToDateTime(ClosingDate.Text + " " + Convert.ToString(ClosingTime.Date.TimeOfDay));
ExistingProblem.AddingDate = DateTime.Now;
ExistingProblem.AddedBy = "Admin";
db.SubmitChanges();
}
}
MultiView1.ActiveViewIndex = 1;
}
protected void Page_Load(object sender, EventArgs e)
{
KodProblemu = Request.QueryString["KodProblemu"];
if (!Page.IsPostBack)
{
MultiView1.ActiveViewIndex = 0;
var db = new DataBase.DataClasses1DataContext();
// wypisanie grup ////////////////////////////////////////////////////////////////
var query1 = from n in db.Groups select n.Name;
foreach (var grupa in query1)
{
Groups.Items.Add(grupa);
}
//////////////////////////////////////////////////////////////////////////////////
//Groups.Items.Add("grupa 1");
//wypisanie języków //////////////////////////////////////////////////////////////
var query2 = from n in db.Languages select n.Name;
foreach (var jezyk in query2)
{
Languages.Items.Add(jezyk);
}
//////////////////////////////////////////////////////////////////////////////////
InOut.Rows[0].Cells[0].Text = "nr";
InOut.Rows[0].Cells[1].Text = "wejście";
InOut.Rows[0].Cells[2].Text = "wyjście";
for (int i = 1; i < InOut.Rows.Count; i++)
{
InOut.Rows[i].Cells[0].Text = Convert.ToString(i);
}
//dodawanie zadania /////////////////////////////////////////////////////////////////
if (KodProblemu == null)
{
FormType.Text = "Dodaj problem";
EditProblemX.Text = "Dodaj problem";
ObecnePary1.Visible = false;
GetCSVPairs.Visible = false;
}
//edycja istniejacego //////////////////////////////////////////////////////////////
else
{
var query = from n in db.Problems where n.ProblemsCode == KodProblemu select n;
var ExistingProblem = query.First();
ProblemsTitle.Text = ExistingProblem.Title;
ProblemsCode.Text = ExistingProblem.ProblemsCode;
DifficultyLevel.SelectedValue = ExistingProblem.DifficultyLevel;
foreach (ListItem checkbox in Languages.Items)
{
if (ExistingProblem.Languages.Contains(checkbox.Text))
{
checkbox.Selected = true;
}
}
for (int i = 0; i < Groups.Items.Count - 1; i++)
{
if (ExistingProblem.Groups.Contains(Groups.Items[i].Text))
{
Groups.Items[i].Selected = true;
}
}
TimeLimit.Text = ExistingProblem.TimeLimit.ToString();
SizeLimit.Text = ExistingProblem.SizeLimit.ToString();
Editor.Content = ExistingProblem.Description;
OpeningDate.Text = ExistingProblem.OpeningDate.Month.ToString() + "/" + ExistingProblem.OpeningDate.Day.ToString() + "/" + ExistingProblem.OpeningDate.Year.ToString();
ClosingDate.Text = ExistingProblem.ClosingDate.Month.ToString() + "/" + ExistingProblem.ClosingDate.Day.ToString() + "/" + ExistingProblem.ClosingDate.Year.ToString();
OpeningTime.Hour = ExistingProblem.OpeningDate.Hour;
OpeningTime.Minute = ExistingProblem.OpeningDate.Minute;
ClosingTime.Hour = ExistingProblem.ClosingDate.Hour;
ClosingTime.Minute = ExistingProblem.ClosingDate.Minute;
ProblemsTitle.Text = ExistingProblem.Title;
ProblemsCode.Text = ExistingProblem.ProblemsCode;
string[] inputs = ExistingProblem.Input.Split(';');
string[] outputs = ExistingProblem.Output.Split(';');
if (inputs.Length <= 20)
{
for (int i = 1; i < inputs.Length; i++)
{
InOut.Rows[i].Cells[0].Text = Convert.ToString(i);
TextBox Input = (TextBox)InOut.Rows[i].Cells[1].Controls[0];
Input.Text = inputs[i - 1];
InOut.Rows[i].Cells[1].Controls.Clear();
InOut.Rows[i].Cells[1].Controls.Add(Input);
TextBox Output = (TextBox)InOut.Rows[i].Cells[2].Controls[0];
Output.Text = outputs[i - 1];
InOut.Rows[i].Cells[2].Controls.Clear();
InOut.Rows[i].Cells[2].Controls.Add(Output);
InOut.Rows[i].Visible = true;
}
if (inputs.Length == 20)
{
AddNextInOut.Visible = false;
}
//for (int i = inputs.Length; i < inputs.Length + (5 - inputs.Length); i++)
//{
// InOut.Rows[i].v
//}
}
else
{
ObecnePary0.Text = "To zadanie posiada więcej niż 20 par wejścia-wyjścia. Zaimportuj plik z danymi w formacie *.csv (nr_pary;wejście;wyjście) aby je nadpisać.";
InOut.Visible = false;
}
}
}
}