/// <summary>
/// Constructor.
/// Connects to the Controller Layer
/// Retrieves from the controller layer all order headers and shows them in the datagrid
/// </summary>
public MainView()
{
InitializeComponent();
this.layer = new LogicLayer();
allOrderHeaders = layer.GetOrderHeaders();
dgMainMenu.ItemsSource = allOrderHeaders;
this.Topmost = true;
}
public DataTable gun(LogicLayer li)
{
cmd = new SqlCommand("select * from student where userid=@def", cn);
cmd.Parameters.AddWithValue("@def", li.unm);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public void p_add_def(LogicLayer li)
{
cmd = new SqlCommand(@"INSERT INTO p_defination(def_name,def_description) VALUES (@dfn,@des)", cn);
cmd.Parameters.AddWithValue("@dfn", li.pdefname);
cmd.Parameters.AddWithValue("@des", li.pdefdesc);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
public DataTable getname(LogicLayer li)
{
cmd = new SqlCommand("select * from p_defination", cn);
// cmd.Parameters.AddWithValue("@un", li.unme);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable getuser(LogicLayer li)
{
cmd = new SqlCommand("select * from student where cardno=@aid", cn);
cmd.Parameters.AddWithValue("@aid", li.cardno);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable team(LogicLayer li)
{
cmd = new SqlCommand("select * from mdef where @m IN(member_1,member_2)", cn);
cmd.Parameters.AddWithValue("@m", li.get);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable s_login(LogicLayer li)
{
cmd = new SqlCommand("select * from student where userid=@username and password=@password", cn);
cmd.Parameters.AddWithValue("@username", li.username);
cmd.Parameters.AddWithValue("@password", li.password);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable dattview4(LogicLayer li)
{
cmd = new SqlCommand("select * from CJT where userid=@guname", cn);
cmd.Parameters.AddWithValue("@guname", li.attd);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public void GenerateGridTest()
{
logic = new LogicLayer();
bool[,] verify = new bool[5, 5];
Assert.IsTrue(logic.grid.GetLength(0) == 5);
Assert.IsTrue(logic.grid.GetLength(1) == 5);
var x = logic.grid.GetType();
Assert.IsTrue(logic.grid.GetType() == verify.GetType());
}
public DataTable checkcjt(LogicLayer li)
{
cmd = new SqlCommand("select * from CJT where userid=@un", cn);
cmd.Parameters.AddWithValue("@sub", li.attvalue);
cmd.Parameters.AddWithValue("@un", li.unme);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable p_login(LogicLayer li)
{
SqlCommand cmd = new SqlCommand("select * from faculty where funame =@username and Password=@f_password", cn);
cmd.Parameters.AddWithValue("@username", li.username);
cmd.Parameters.AddWithValue("@f_password", li.password);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
/// <summary>
/// Add FIRST List For Example
/// </summary>
static void AddNEWListForExample()
{
LogicLayer.AddTeacher(new Teacher("Anders Hejlsberg", TypeTeacher.Docent));
LogicLayer.AddStudent(new Student("Jone White", new Group("Group C#"), 25));
LogicLayer.AddGroup(new Group("Group C#", new Teacher("Anders Hejlsberg", TypeTeacher.Docent)));
LogicLayer.AddTeacher(new Teacher("James Arthur Gosling", TypeTeacher.Accictent));
LogicLayer.AddStudent(new Student("Smith Red", new Group("Group Java"), 30));
LogicLayer.AddGroup(new Group("Group Java", new Teacher("James Arthur Gosling", TypeTeacher.Accictent)));
LogicLayer.AddTeacher(new Teacher("Tim Berners-Lee", TypeTeacher.Lector));
LogicLayer.AddStudent(new Student("Dan Black", new Group("Group HTML"), 41));
LogicLayer.AddGroup(new Group("Group HTML", new Teacher("Tim Berners-Lee", TypeTeacher.Lector)));
}
public FormBestSleep()
{
InitializeComponent();
this.Business = new LogicLayer();
this.Load += FormBestSleep_Load;
this.btnAdd.Click += btnAdd_Click;
this.btnDel.Click += btnDel_Click;
this.grdBestSleep.DoubleClick += grdBestSleep_DoubleClick;
}
public void insert(LogicLayer li)
{
cmd = new SqlCommand(@"INSERT INTO A_system.dbo.student(sname,userid,roll_no,email,parent_email,password,cardno) VALUES(@sn,@uid,@rno,@mail,@pmail,@pass,@cn)", cn);
cmd.Parameters.AddWithValue("@sn", li.fullname);
cmd.Parameters.AddWithValue("@uid", li.userid);
cmd.Parameters.AddWithValue("@rno", li.rollno);
cmd.Parameters.AddWithValue("@mail", li.email);
cmd.Parameters.AddWithValue("@pmail", li.parentmail);
cmd.Parameters.AddWithValue("@pass", li.upassword);
cmd.Parameters.AddWithValue("@cn", li.card_no);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
public void res(LogicLayer li)
{
cn.Open();
cmd = new SqlCommand("update AMP set checks=0", cn);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("update DBMS set checks=0", cn);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("update DAA set checks=0", cn);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("update CJT set checks=0", cn);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("update TAFL set checks=0", cn);
cmd.ExecuteNonQuery();
cn.Close();
}
/// <summary>
/// Add FIRST List For Example
/// </summary>
static void AddNEWListForExample()
{
// магические числа в коде , сейчас мы знаем что означает 25 30 41 итд а через пол года вспомнишь ? выност в переменые\сетинги\константы с самодокументируемым названием
LogicLayer.AddTeacher(new Teacher("Anders Hejlsberg", TypeTeacher.Docent));
LogicLayer.AddStudent(new Student("Jone White", new Group("Group C#", new Teacher("Anders Hejlsberg", TypeTeacher.Docent)), 25));
LogicLayer.AddGroup(new Group("Group C#", new Teacher("Anders Hejlsberg", TypeTeacher.Docent)));
LogicLayer.AddTeacher(new Teacher("James Arthur Gosling", TypeTeacher.Accictent));
LogicLayer.AddStudent(new Student("Smith Red", new Group("Group Java", new Teacher("James Arthur Gosling", TypeTeacher.Accictent)), 30));
LogicLayer.AddGroup(new Group("Group Java", new Teacher("James Arthur Gosling", TypeTeacher.Accictent)));
LogicLayer.AddTeacher(new Teacher("Tim Berners-Lee", TypeTeacher.Lector));
LogicLayer.AddStudent(new Student("Dan Black", new Group("Group HTML", new Teacher("Tim Berners-Lee", TypeTeacher.Lector)), 41));
LogicLayer.AddGroup(new Group("Group HTML", new Teacher("Tim Berners-Lee", TypeTeacher.Lector)));
}
public void ins_att(LogicLayer li)
{
if (li.attvalue == "amp")
{
cmd = new SqlCommand("update AMP set attend=(attend+1),checks=1 where userid=@crdno", cn);
cmd.Parameters.AddWithValue("@crdno", li.unme);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
if (li.attvalue == "dbms")
{
cmd = new SqlCommand("update DBMS set attend=(attend+1),checks=1 where userid=@crdno", cn);
cmd.Parameters.AddWithValue("@crdno", li.unme);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
if (li.attvalue == "daa")
{
cmd = new SqlCommand("update DAA set attend=(attend+1),checks=1 where userid=@crdno", cn);
cmd.Parameters.AddWithValue("@crdno", li.unme);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
if (li.attvalue == "cjt")
{
cmd = new SqlCommand("update CJT set attend=(attend+1),checks=1 where userid=@crdno", cn);
cmd.Parameters.AddWithValue("@crdno", li.unme);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
if (li.attvalue == "tafl")
{
cmd = new SqlCommand("update TAFL set attend=(attend+1),checks=1 where userid=@crdno", cn);
cmd.Parameters.AddWithValue("@crdno", li.unme);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
/// <summary>
/// Add New Student
/// </summary>
private static void addNewStudent()
{
try
{
int Age;
string Name;
Group Group;
//Name
Console.Write("\t Write Name Student:");
Name = Console.ReadLine();
//Age
bool pr = false;
do
{
Console.Write("\t Write Age:");
pr = int.TryParse(Console.ReadLine(), out Age);
if (Age <= 0)
{
pr = false;
}
} while (!pr);
//Group
int index = 0;
foreach (Group spw in LogicLayer.GetGroup)
{
Console.WriteLine($"[{index++}] \t {spw.Id} \t {spw.Name} \t {spw.Teacher.Name} \t {spw.CountStudents}");
}
int NomerGroup;
do
{
Console.Write("\t Write Group №:");
} while (!Int32.TryParse(Console.ReadLine(), out NomerGroup));
LogicLayer.AddStudent(new Student(Name, Group._modelGroup[NomerGroup], Age));
LogicLayer.AddGroupStudentsCount(NomerGroup);
Console.WriteLine("\tSuccessfully");
}
catch (Exception e)
{
Console.WriteLine("\tError. Something went wrong!)", e.Message);
}
}
public void sdef_insert(LogicLayer li)
{
cn.Open();
cmd = new SqlCommand("insert into selectdef(def_id,member_1,member_2) values(@def,@m1,@m2)", cn);
cmd.Parameters.AddWithValue("@def", li.sdefid);
cmd.Parameters.AddWithValue("@m1", li.roll_no);
cmd.Parameters.AddWithValue("@m2", li.roll_no1);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("update mdef set member_1=@m1,member_2=@m2 where def_id=@def", cn);
cmd.Parameters.AddWithValue("@def", li.sdefid);
cmd.Parameters.AddWithValue("@m1", li.roll_no);
cmd.Parameters.AddWithValue("@m2", li.roll_no1);
cmd.ExecuteNonQuery();
cn.Close();
}
/// <summary>
///
/// </summary>
/// <param name="args"></param>
static void Main(string[] args)
{
int[] Arr = new int[10];
Arr = LogicLayer.AddArr();
for (int i = 0; i < Arr.GetLength(0); i++)
{
Console.WriteLine(Arr[i]);
}
Console.WriteLine($"Sum:{LogicLayer.SumAll(Arr)}");
Console.WriteLine($"Sum negative:{LogicLayer.SumNeg(Arr)}");
Console.ReadKey();
}
public void adds(LogicLayer li)
{
if (li.subc == "dbms")
{
cmd = new SqlCommand("update DBMS set total=(total+1)", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
else if (li.subc == "amp")
{
cmd = new SqlCommand("update AMP set total=(total+1)", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
else if (li.subc == "daa")
{
cmd = new SqlCommand("update DAA set total=(total+1)", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
else if (li.subc == "tafl")
{
cmd = new SqlCommand("update TAFL set total=(total+1)", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
else if (li.subc == "cjt")
{
cmd = new SqlCommand("update CJT set total=(total+1)", cn);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
public void onClickTest()
{
logic = new LogicLayer();
int[] clickPosition = new int[2] {
3, 2
};
bool aboveStateInit = logic.grid[2, 2];
bool belowStateInit = logic.grid[4, 2];
bool rightStateInit = logic.grid[3, 3];
bool leftStateInit = logic.grid[3, 1];
bool middleStateinit = logic.grid[3, 2];
logic.onClick(clickPosition);
// Assert that the initial state of the cell has been changed
Assert.IsFalse(aboveStateInit == logic.grid[2, 2]);
Assert.IsFalse(belowStateInit == logic.grid[4, 2]);
Assert.IsFalse(rightStateInit == logic.grid[3, 3]);
Assert.IsFalse(leftStateInit == logic.grid[3, 1]);
Assert.IsFalse(middleStateinit == logic.grid[3, 2]);
}
public DataTable checkamp(LogicLayer li)
{
return(dl.checkamp(li));
}
public DataTable checkcjt(LogicLayer li)
{
return(dl.checkcjt(li));
}
public DataTable checktafl(LogicLayer li)
{
return(dl.checktafl(li));
}
public DataTable gettitle(LogicLayer li)
{
return(dl.getname(li));
}
public DataTable team(LogicLayer li)
{
return(dl.team(li));
}
public DataTable sroll(LogicLayer li)
{
return(dl.sroll(li));
}
public DataTable checkdbms(LogicLayer li)
{
return(dl.checkdbms(li));
}
public DataTable plogin(LogicLayer li)
{
return(dl.p_login(li));
}
