public static void Csv(int StudentID, int GrupaID, int Semestru, string FileName) { using (var context = new CatalogEntities1()) { try { var tabel = context.usp_catalog_sesiunea_x(StudentID, GrupaID, Semestru).ToList(); var csv = new StringBuilder(); csv.AppendLine("Disciplina,NotaCurs,NotaLaborator,NotaProiect,NotaFinala,Credite"); for (int i = 0; i < tabel.Count; i++) { csv.AppendLine(tabel[i].NumeMaterie.ToString() + "," + tabel[i].NotaCurs.ToString() + "," + tabel[i].NotaLaborator.ToString() + "," + tabel[i].NotaProiect.ToString() + "," + tabel[i].NotaFinala.ToString() + "," + tabel[i].Credite.ToString()); } string path = System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); File.WriteAllText(path + "\\" + FileName + " Semestrul " + Semestru.ToString() + ".csv", csv.ToString()); } catch (Exception ex) { throw new Exception("Csv: Csv file could not be saved! Check filepath.\n" + ex.Message); } } }
public static void Pdf(int StudentID, int GrupaID, int Semestru, string FileName) { using (var context = new CatalogEntities1()) { try { var tabel = context.usp_catalog_sesiunea_x(StudentID, GrupaID, Semestru).ToList(); string path = System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); Document document = new Document(); PdfWriter writer = PdfWriter.GetInstance(document, new FileStream(path + "\\" + FileName + " Semestrul " + Semestru.ToString() + ".pdf", FileMode.Create)); document.Open(); iTextSharp.text.Font font5 = iTextSharp.text.FontFactory.GetFont(FontFactory.HELVETICA, 5); PdfPTable table = new PdfPTable(6); PdfPRow row = null; float[] widths = new float[] { 4f, 4f, 4f, 4f, 4f, 4f }; table.SetWidths(widths); table.WidthPercentage = 100; int iCol = 0; string colname = ""; PdfPCell cell = new PdfPCell(new Phrase("Note pe semestrul" + Semestru.ToString())); cell.Colspan = 6; table.AddCell(new Phrase("Disciplina", font5)); table.AddCell(new Phrase("NotaCurs", font5)); table.AddCell(new Phrase("NotaLaborator", font5)); table.AddCell(new Phrase("NotaProiect", font5)); table.AddCell(new Phrase("NotaFinala", font5)); table.AddCell(new Phrase("Credite", font5)); for (int i = 0; i < tabel.Count; i++) { table.AddCell(new Phrase(tabel[i].NumeMaterie.ToString(), font5)); table.AddCell(new Phrase(tabel[i].NotaCurs.ToString(), font5)); table.AddCell(new Phrase(tabel[i].NotaFinala.ToString(), font5)); table.AddCell(new Phrase(tabel[i].NotaProiect.ToString(), font5)); table.AddCell(new Phrase(tabel[i].NotaFinala.ToString(), font5)); table.AddCell(new Phrase(tabel[i].Credite.ToString(), font5)); } document.Add(table); document.Close(); } catch (Exception e) { Console.Out.WriteLine(e.ToString()); } } }
public void ResetAllTools() { bunifuCheckbox1.Checked = false; bunifuCheckbox2.Checked = false; bunifuCustomDataGrid1.Rows.Clear(); bunifuMaterialTextbox1.Text = ""; bunifuMaterialTextbox2.Text = ""; bunifuMaterialTextbox3.Text = ""; //adaugam toti profesorii in dataGrid (Nume,Prenume,Materie) var catalog = new CatalogEntities1(); //luam toti profesorii si dupaia pentru fiecare profesor il cautam in materii var profi = from p in catalog.Cadrus select p; foreach (var p in profi) { this.AddProfesorDataGrid(p.Nume, p.Prenume); } }
public static void Excel(int StudentID, int GrupaID, int Semestru, string FileName) { using (var context = new CatalogEntities1()) { try { var tabel = context.usp_catalog_sesiunea_x(StudentID, GrupaID, Semestru).ToList(); // load excel, and create a new workbook var excelApp = new Excel.Application(); excelApp.Workbooks.Add(); // single worksheet Excel._Worksheet workSheet = excelApp.ActiveSheet; // column headings workSheet.Cells[1, 1] = "Disciplina"; workSheet.Cells[1, 2] = "NotaCurs"; workSheet.Cells[1, 3] = "NotaLaborator"; workSheet.Cells[1, 4] = "NotaProiect"; workSheet.Cells[1, 5] = "NotaFinala"; workSheet.Cells[1, 6] = "Credite"; for (int i = 0; i < tabel.Count; i++) { workSheet.Cells[i + 2, 1] = tabel[i].NumeMaterie.ToString(); workSheet.Cells[i + 2, 2] = tabel[i].NotaCurs.ToString(); workSheet.Cells[i + 2, 3] = tabel[i].NotaLaborator.ToString(); workSheet.Cells[i + 2, 4] = tabel[i].NotaProiect.ToString(); workSheet.Cells[i + 2, 5] = tabel[i].NotaFinala.ToString(); workSheet.Cells[i + 2, 6] = tabel[i].Credite.ToString(); } if (!string.IsNullOrEmpty(FileName + " Semestrul " + Semestru.ToString() + ".xlsx")) { try { workSheet.SaveAs(FileName + " Semestrul " + Semestru.ToString() + ".xlsx"); excelApp.Quit(); } catch (Exception ex) { throw new Exception("ExportToExcel: Excel file could not be saved! Check filepath.\n" + ex.Message); } } else { excelApp.Visible = true; } } catch (Exception ex) { throw new Exception("ExportToExcel: \n" + ex.Message); } } }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { try { if (bunifuMaterialTextbox1.Text != "" && bunifuMaterialTextbox2.Text != "" && bunifuMaterialTextbox3.Text != "" && bunifuMaterialTextbox1.Text != "Cadrul Exista!") { string NumeCadru = bunifuMaterialTextbox1.Text; string PrenumeCadru = bunifuMaterialTextbox2.Text; string CNPCadru = bunifuMaterialTextbox3.Text; using (var catalog = new CatalogEntities1()) { var Cadre = from c in catalog.Cadrus where c.CNP.Equals(CNPCadru) select c; if (Cadre.Count() == 0) { //adica nu mai exista bool SefDepartament = false; bool Decan = false; if (bunifuCheckbox1.Checked == true) { SefDepartament = true; } if (bunifuCheckbox2.Checked == true) { Decan = true; } //parola random string new_pass = Form1.gui.GenerareParola(3, 3, 4); //3litere mici, 3litere mari, 4cifre //salvam in fisier this.AddtoFile(NumeCadru, PrenumeCadru, CNPCadru, new_pass); //criptam parola string new_pass_encrypted = Form1.gui.Criptare_string(new_pass); using (var dbCatalogTransaction = catalog.Database.BeginTransaction()) { //adaugam in baza de date try { Cadru newCadru = new Cadru { Nume = NumeCadru, Prenume = PrenumeCadru, CNP = CNPCadru, SefDepartament = SefDepartament, Decan = Decan, Password = new_pass_encrypted//o adaugam pe cea criptata }; catalog.Cadrus.Add(newCadru); catalog.SaveChanges(); dbCatalogTransaction.Commit(); //adaugam in gridview AddProfesorDataGrid(NumeCadru, PrenumeCadru); } catch (Exception ex) { dbCatalogTransaction.Rollback(); FormError newForm = new FormError(); newForm.SetText(ex.ToString()); newForm.ShowDialog(); } } } else { bunifuMaterialTextbox1.Text = "Cadrul Exista!"; bunifuMaterialTextbox2.Text = ""; bunifuMaterialTextbox3.Text = ""; } } } } catch (Exception ex) { FormError newForm = new FormError(); newForm.SetText(ex.ToString()); newForm.ShowDialog(); } }