private DataBaseConnection() { LoginForm logf = new LoginForm(); string Dir = logf.GetHomeDirectory(); string connectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString + "Data Source ='" + @Dir + "\\DataBase.sdf'"; connection = new SqlCeConnection(connectionString); connection.Open(); }
private void PrintStatisticTeacherRoundedButton_Click(object sender, EventArgs e) { int columnNumber = 6; PdfPTable table = new PdfPTable(columnNumber) { //actual width of table in points TotalWidth = 400f, //fix the absolute width of the table LockedWidth = true }; //relative col widths in proportions - 1/3 and 2/3 float[] widths = new float[] { 1f, 1f, 1f, 1f, 1f, 1f }; table.SetWidths(widths); table.HorizontalAlignment = 0; //leave a gap before and after the table table.SpacingBefore = 20f; table.SpacingAfter = 30f; PdfPCell cell = new PdfPCell(new Phrase("Ucenici")) { Colspan = columnNumber, Border = 0, HorizontalAlignment = 1 }; table.AddCell(cell); table.AddCell("Ime"); table.AddCell("Prezime"); table.AddCell("Odsustva(U)"); table.AddCell("Odsustva(O)"); table.AddCell("Odsustva(N)"); table.AddCell("Prosjek"); int TeacherId = CurrentTeacher.Id; int DepartmentId = DepartmentsRepository.GetIdByTeacherId(TeacherId); string StudentsQuery = StudentRepository.GetQuery(DepartmentId); SqlCeCommand cmd = new SqlCeCommand(StudentsQuery, Connection); SqlCeDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { int justifiedAbsents = AbsentsRepository.GetAbsents((int)reader["Id"], 1); int unJustifiedAbsents = AbsentsRepository.GetAbsents((int)reader["Id"], 0); int sum = justifiedAbsents + unJustifiedAbsents; string CoursesId = CoursesRepository.GetCoursesId(); string[] parts = CoursesId.Split(','); int suum = 0; for (int i = 0; i < parts.Length; i++) { string marks = MarksRepository.GetMarks((int)reader["Id"]); string[] particles = marks.Split(','); double mark = Math.Round(float.Parse(CalculateAverageGrade(particles)), MidpointRounding.AwayFromZero); suum += (int)mark; } float average = suum / (parts.Length); string averageMark = average.ToString("0.00") + "(" + Math.Round(average, MidpointRounding.AwayFromZero) + ")"; table.AddCell(reader["Name"].ToString()); table.AddCell(reader["Surname"].ToString()); table.AddCell(sum.ToString()); table.AddCell(justifiedAbsents.ToString()); table.AddCell(unJustifiedAbsents.ToString()); table.AddCell(averageMark); } } catch (Exception ex) { MessageBox.Show(ex.Message); } LoginForm logf = new LoginForm(); string Dir = logf.GetHomeDirectory(); FileStream fs = new FileStream("report.pdf", FileMode.Create); Document doc = new Document(PageSize.A4); PdfWriter pdfWriter = PdfWriter.GetInstance(doc, fs); doc.Open(); doc.Add(table); while (reader.Read()) { doc.Add(new Paragraph(reader[0].ToString() + reader[1].ToString() + reader[2].ToString())); } pdfWriter.CloseStream = true; doc.Close(); Process.Start("report.pdf"); }
public void CheckLogin(TextBox Username, TextBox Password) { LoginForm logf = new LoginForm(); string Dir = logf.GetHomeDirectory(); string connectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString + "Data Source ='" + @Dir + "\\DataBase.sdf'"; using (SqlCeConnection Connection = new SqlCeConnection()) { if (Username.TextLength > 0 && Password.TextLength > 0) { try { Connection.ConnectionString = connectionString; Connection.Open(); SqlCeCommand logincommand = new SqlCeCommand(@"SELECT Id,UserName,Password FROM Users WHERE UserName=@uname and Password=@pass", Connection); logincommand.Parameters.AddWithValue("@uname", Username.Text); logincommand.Parameters.AddWithValue("@pass", Password.Text); SqlCeDataReader loginReader = logincommand.ExecuteReader(); if (loginReader.Read() && loginReader["UserName"].ToString() == Username.Text && loginReader["Password"].ToString() == Password.Text) { SqlCeCommand admincommand = new SqlCeCommand(@"SELECT Name,Surname,UsersId FROM Administration WHERE UsersId =@LoggedId", Connection); admincommand.Parameters.AddWithValue("@LoggedId", loginReader["Id"]); SqlCeDataReader adminReader = admincommand.ExecuteReader(); //ADMIN SqlCeCommand teachercommand = new SqlCeCommand(@"SELECT Name,Surname,UsersId FROM Teachers WHERE UsersId =@LoggedId", Connection); teachercommand.Parameters.AddWithValue("@LoggedId", loginReader["Id"]); SqlCeDataReader teacherReader = teachercommand.ExecuteReader(); //TEACHER SqlCeCommand directorcommand = new SqlCeCommand(@"SELECT Name,Surname,UsersId FROM Directors WHERE UsersId =@LoggedId", Connection); directorcommand.Parameters.AddWithValue("@LoggedId", loginReader["Id"]); SqlCeDataReader directorReader = directorcommand.ExecuteReader(); //DIRECTOR if (adminReader.Read() && loginReader["Id"].ToString() == adminReader["UsersId"].ToString()) { flag = true; Form newform = new AdministrationForm(); newform.Show(); } else if (teacherReader.Read() && loginReader["Id"].ToString() == teacherReader["UsersId"].ToString()) { flag = true; Form newform = new TeacherForm(); newform.Show(); } else if (directorReader.Read() && loginReader["Id"].ToString() == directorReader["UsersId"].ToString()) { flag = true; Form newform = new DirectorForm(); newform.Show(); } else { flag = false; MessageBox.Show("Netacni podaci"); } } else { flag = false; MessageBox.Show("Netacni podaci"); Username.Text = ""; Password.Text = ""; } } catch (Exception ex) { flag = false; MessageBox.Show("Neočekivana greška:" + ex.Message); } } } }