/*
* -------------------------------------------------------------------------
*/
/*
* [ INICIO ] METODO PARA FECHAR A FORM TECLANDO "ESC" Escape
*/
public void deletarComDEL(object sender, KeyEventArgs e)
{
fecharFormComEsc(sender, e);
if ((e.KeyCode == Keys.Delete))
{
int idExclusao = int.Parse(listView_servicos.SelectedItems[0].SubItems[0].Text);
if (idExclusao > 0)
{
DialogResult dialogResult = MessageBox.Show("Deseja realmente excluir o item selecionado?", "Excluir item?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
ServicosController servicosController = new ServicosController();
servicosController.deletarServico(idExclusao, listView_servicos);
}
//else if (dialogResult == DialogResult.No)
//{
// faça algo...
//}
}
}
else
if ((e.KeyCode == Keys.Escape))
{
Close();
}
}
static public void importarExcel(Servico servico, ServicosController servicosController, String folhaDoExcel)
{
OleDbConnection conexao = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\prontovetdb_backup\\Pagos.xlsx;Extended Properties='Excel 12.0 Xml;HDR = YES';");
OleDbDataAdapter adapter = new OleDbDataAdapter("select * from[" + folhaDoExcel + "$]", conexao);
DataSet ds = new DataSet();
try
{
conexao.Open();
adapter.Fill(ds);
foreach (DataRow linha in ds.Tables[0].Rows)
{
String[] list = linha["PET - PROPRIETÁRIO"].ToString().Split('-');
try
{
if (linha["PET - PROPRIETÁRIO"].ToString() != "")
{
servico.Nome_pet = list[0].ToString().ToUpper();
servico.Nome_proprietario = list[1].ToString().ToUpper();
servico.Valor = linha["VALOR"].ToString().ToUpper();
servico.Forma_pagamento = linha["FORMA DE PAGAMENTO"].ToString().ToUpper();
servico.Observacoes = linha["OBSERVAÇÃO"].ToString().ToUpper();
servico.Data = linha["DATA"].ToString().ToUpper();
servico.Hora = DateTime.Now.Hour.ToString() + ":" + DateTime.Now.Minute.ToString();
servicosController.SalvarServicoExcel(servico);
}
}
catch (Exception e)
{
MessageBox.Show("Erro (importarExcel - Util): " + e);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Erro (importarExcel catch - Util): " + ex);
}
finally
{
conexao.Close();
}
}