/// <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)); }