private void NewPerson_User_Signature_Office_Activated(object sender, EventArgs e)
{
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
person_userComboBox.Items.Clear();
Person_User person_user = new Person_User();
User user = new User();
Person person = new Person();
person_user.findAll();
foreach (Person_User person_userList in person_user.persons_users)
{
user.iduser = person_userList.iduser;
user.findByIdUser();
person_user.user = user;
person.idperson = person_userList.idperson;
person.findByIdperson();
person_user.person = person;
person_userComboBox.Items.Add(person_user.user.username + " - " + person_user.person.personname);
}
signatureComboBox.Items.Clear();
Signature signature = new Signature();
signature.findAll();
foreach (Signature signatureList in signature.signatures)
{
signatureComboBox.Items.Add(signatureList.signaturename);
}
officeComboBox.Items.Clear();
Office office = new Office();
office.findAll();
foreach (Office officeList in office.offices)
{
officeComboBox.Items.Add(officeList.officedescription);
}
this.Cursor = System.Windows.Forms.Cursors.Default;
}
private void button4_Click(object sender, EventArgs e)
{
if (verificationTextBox())
{
foreach (object itemChecked in personCheckedListBox.CheckedItems)
{
Person person = new Person();
Person_User person_user = new Person_User();
User user = new User();
Person_User_Computer person_user_computer = new Person_User_Computer();
person.personname = itemChecked.ToString();
person.findByPersonname();
Console.WriteLine("IDperson: " + person.idperson);
Console.WriteLine("personname: " + person.personname);
Console.WriteLine("personemail: " + person.personemail);
person_user.idperson = person.idperson;
person_user.findByIdPerson();
Console.WriteLine("IDperson_user: "******"IDperson: " + person_user.idperson);
Console.WriteLine("IDuser: "******"IDperson_user: "******"IDcomputer: " + person_user_computer.idcomputer);
Console.WriteLine("computername: " + person_user_computer.computername);
user.iduser = person_user.iduser;
user.findByIdUser();
Console.WriteLine("IDuser: "******"username: "******"useremail: " + user.useremail);
Console.WriteLine("IDDepartmant: " + user.iddepartment);
destinationUserPath = @"\\"+person_user_computer.computername+@"\c$\Users\"+user.username+@"\AppData\Roaming\Microsoft\Signatures\";
Console.WriteLine(destinationUserPath);
sourcePath = System.IO.Path.Combine(textBox2.Text);
sourcePathsParts = sourcePath.Split('\\');
destinationBackupPath = System.IO.Path.Combine(textBox1.Text);
destinationBackupPath = destinationBackupPath + @"\" + person.personname + @"\" + sourcePathsParts.Last();
Console.WriteLine(destinationBackupPath);
if (!System.IO.Directory.Exists(destinationBackupPath))
{
System.IO.Directory.CreateDirectory(destinationBackupPath);
}
/*if (Directory.Exists(textBox2.Text))
{
filesSignatures = Directory.GetFiles(textBox2.Text);
foreach (string file in filesSignatures)
{
fileName = Path.GetFileName(file);
destinationFileBackupPath = Path.Combine(destinationBackupPath, fileName);
File.Copy(file, destinationFileBackupPath, true);
destinationFileUserPath = Path.Combine(destinationUserPath, fileName);
File.Copy(file, destinationFileUserPath, true);
}
}
else
{
MessageBox.Show("O caminho " + textBox2.Text + " não existe.", "Erro");
}*/
}
}
else
{
MessageBox.Show("Tem que selecionar algo!!");
}
}
public void Save(string exporttype)
{
int i = 0;
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
if (xlApp == null)
{
Console.WriteLine("EXCEL could not be started. Check that your office installation and project references are correct.");
return;
}
xlApp.Visible = true;
Workbook wb = xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
Worksheet ws = (Worksheet)wb.Worksheets[1];
if (ws == null)
{
Console.WriteLine("Worksheet could not be created. Check that your office installation and project references are correct.");
}
/*string sheet_name = DateTime.Now.ToString("MM-dd-yy");
Excel.Worksheet sheet = FindSheet(workbook, sheet_name);
if (sheet == null)
{
// Add the worksheet at the end.
sheet = (Excel.Worksheet)workbook.Sheets.Add(
Type.Missing, workbook.Sheets[workbook.Sheets.Count],
1, Excel.XlSheetType.xlWorksheet);
sheet.Name = DateTime.Now.ToString("MM-dd-yy");
}*/
switch (exporttype)
{
case "person":
Person person = new Person();
person.findAll();
ws.Cells[1, 1] = "Nome";
ws.Cells[1, 2] = "Email";
i = 2;
foreach (Person personList in person.persons)
{
if (personList.personstate == true)
{
ws.Cells[i, 1] = personList.personname;
ws.Cells[i, 2] = personList.personemail;
i++;
}
}
break;
case "user":
User user = new User();
Department department = new Department();
user.findAll();
ws.Cells[1, 1] = "Nome Utilizador";
ws.Cells[1, 2] = "Email";
ws.Cells[1, 3] = "Departamento";
i = 2;
foreach (User userList in user.users)
{
//if (computerList.personstate == true)
//{
ws.Cells[i, 1] = userList.username;
ws.Cells[i, 2] = userList.useremail;
department.iddepartment = userList.iddepartment;
department.findByIdDepartment();
ws.Cells[i, 3] = department.departmentname;
i++;
//}
}
break;
case "computer":
Computer computer = new Computer();
Type type = new Type();
Brand brand = new Brand();
ws.Cells[1, 1] = "Número Computador";
ws.Cells[1, 2] = "Estado";
i = 2;
foreach (Computer computerList in computer.computers)
{
//if (computerList.personstate == true)
//{
ws.Cells[i, 1] = computerList.idcomputer;
ws.Cells[i, 2] = computerList.computerstate;
i++;
//}
}
break;
case "vendor":
Vendor vendor = new Vendor();
vendor.findAll();
ws.Cells[1, 1] = "Fornecedor";
i = 2;
foreach (Vendor vendorList in vendor.vendors)
{
//if (computerList.personstate == true)
//{
ws.Cells[i, 1] = vendorList.vendorname;
i++;
//}
}
break;
case "category":
Category category = new Category();
category.findAll();
ws.Cells[1, 1] = "Categoria";
i = 2;
foreach (Category categoryList in category.categories)
{
//if (computerList.personstate == true)
//{
ws.Cells[i, 1] = categoryList.categorydescription;
i++;
//}
}
break;
default:
break;
}
//int l = person.persons.Count;
//string a = "B" + l;
// Select the Excel cells, in the range c1 to c7 in the worksheet.
//Range aRange = ws.get_Range("A2", a);
//if (aRange == null)
//{
// Console.WriteLine("Could not get a range. Check to be sure you have the correct versions of the office DLLs.");
//}
// Fill the cells in the C1 to C7 range of the worksheet with the number 6.
//Object[] args = new Object[1];
//args[0] = 6;
//aRange.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, aRange, args);
// Change the cells in the C1 to C7 range of the worksheet to the number 8.
//aRange.Value2 = values;
// Save the changes and close the workbook.
//wb.Close(true, Type.Missing, Type.Missing);
// Close the Excel server.
//xlApp.Quit();
//MessageBox.Show("Done");
}
public void findAll()
{
db = new Database();
person_user_computerQuery = new MySqlCommand();
person_user_computerQuery.Connection = db.Connection();
person_user_computerQuery.CommandText = "SELECT * FROM person_user_computer";
person_user_computerResult = person_user_computerQuery.ExecuteReader();
while (person_user_computerResult.Read())
{
if (!person_user_computerResult.IsDBNull(0))
{
idperson_user = person_user_computerResult.GetInt32(0);
}
if (!person_user_computerResult.IsDBNull(1))
{
person = new Person();
person.idperson = person_user_computerResult.GetInt32(1);
person.findByIdperson();
}
if (!person_user_computerResult.IsDBNull(2))
{
user = new User();
user.iduser = person_user_computerResult.GetInt32(2);
user.findByIdUser();
}
//if (!person_user_computerResult.IsDBNull(3))
//{
// person_userstart = person_user_computerResult.GetDateTime(3);
//}
//else
//{
// person_userstart = null;
//}
//if (!person_user_computerResult.IsDBNull(4))
//{
// person_userfinish = person_user_computerResult.GetDateTime(4);
//}
//else
//{
// person_userfinish = null;
//}
persons_users_computers.Add(new Person_User_Computer { idperson_user = this.idperson_user, person = this.person, user = this.user });
}
db.Close();
}