private void tbcDevolucao_Enter(object sender, EventArgs e)
{
conexaoBanco rel = new conexaoBanco();
dgvDevolucao.DataSource = rel.GridEmp();
dgvDevolucao.Columns[1].Width = 300;
}
public void AChaEmprestado()
{
conexaoBanco pega = new conexaoBanco();
List<string> armazenaEmprestado = new List<string>();
foreach (ListViewItem itens in lsvPrincipal.Items)
armazenaEmprestado.Add(itens.Text);
if (armazenaEmprestado.ToString() != null)
{
List<string> pegaEmprestado = pega.pesqtemEmprestimo(armazenaEmprestado);
foreach (ListViewItem itens in lsvPrincipal.Items)
{
for (int j = 0; j < pegaEmprestado.Count; j++)
{
if (pegaEmprestado[j].ToString() == itens.Text)
itens.BackColor = Color.LightBlue;
}
}
}
}
// Use this for initialization
void Start()
{
conexao = FindObjectOfType(typeof(conexaoBanco)) as conexaoBanco;
}
private void tbcEmprestados_Enter(object sender, EventArgs e)
{
conexaoBanco rel = new conexaoBanco();
dgvEmprestados.DataSource = rel.GridDev();
}
private void lsvPrincipal_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Delete)
{
List<string> apagar = new List<string>();
for (int i = lsvPrincipal.SelectedItems.Count - 1; i >= 0; i--)
{
ListViewItem remove = lsvPrincipal.SelectedItems[i];
apagar.Add(remove.Text);
}
conexaoBanco apaga = new conexaoBanco();
List<string> armazena = apaga.AchaItemEmprestimo(apagar);
List<string> armazenaEmprestado = apaga.pesqtemEmprestimo(apagar);
bool avisa = false;
string nome = null;
List<string> pegaNome = new List<string>();
if (armazenaEmprestado.Count != 0)
{
for (int j = 0; j < armazenaEmprestado.Count; j++)
{
for (int i = lsvPrincipal.SelectedItems.Count - 1; i >= 0; i--)
{
if (armazenaEmprestado[j].ToString() == lsvPrincipal.SelectedItems[i].Text)
{
avisa = true;
}
}
}
if (avisa == true)
{
if (MessageBox.Show("Você selecionou Iten(s) Emprestados, Deseja Realmente Excluir", "Aviso", MessageBoxButtons.YesNo, MessageBoxIcon.Information)
== DialogResult.Yes)
{
for (int j = 0; j < armazenaEmprestado.Count; j++)
{
for (int i = lsvPrincipal.SelectedItems.Count - 1; i >= 0; i--)
{
if (armazenaEmprestado[j].ToString() == lsvPrincipal.SelectedItems[i].Text)
{
apaga.excluiItensEmprestimo(armazenaEmprestado);
apaga.removeItemBanco(armazenaEmprestado);
ListViewItem remove = lsvPrincipal.SelectedItems[i];
remove.Remove();
}
}
}
}
}
}
if (armazena.Count != 0)
{
apaga.removeItemBanco(armazena);
for (int j = 0; j < armazena.Count; j++)
{
for (int i = lsvPrincipal.SelectedItems.Count - 1; i >= 0; i--)
{
if (armazena[j].ToString() == lsvPrincipal.SelectedItems[i].Text)
{
ListViewItem remove = lsvPrincipal.SelectedItems[i];
remove.Remove();
}
}
}
}
}
}
private void frmPrincipal_Load(object sender, EventArgs e)
{
preenchelist();
AChaEmprestado();
conexaoBanco pega = new conexaoBanco();
cbxTipoMidia1.DataSource = pega.prCombo_Midia();
txbAutor1.Enabled = false;
txbIterprete1.Enabled = false;
txbOrigem1.Enabled = false;
dtpDataAlbum1.Value = Convert.ToDateTime("01/01/1953");
dtpDataAlbum2.Value = DateTime.Now;
dtpDataAlbum1.Enabled = false;
dtpDataAlbum2.Enabled = false;
dtpDataCompra1.Value = Convert.ToDateTime("01/01/1953");
dtpDataCompra1.Enabled = false;
dtpDataCompra2.Value = DateTime.Now;
dtpDataCompra2.Enabled = false;
txbPesquisa.Text = "";
ckbTipoMidia.Checked = true;
}
private void btnFiltrar_Click(object sender, EventArgs e)
{
if (Convert.ToDateTime(dtpDataAlbum1.Value.ToShortDateString()) > Convert.ToDateTime(dtpDataAlbum2.Value.ToShortDateString()))
{
eprError.SetError(dtpDataAlbum1, "A primeira data deve ser menor que a segunda data");
}
else
{
eprError.Clear();
if (Convert.ToDateTime(dtpDataCompra1.Value.ToShortDateString()) > Convert.ToDateTime(dtpDataCompra2.Value.ToShortDateString()))
{
eprError.SetError(dtpDataCompra1, "A primeira data deve ser menor que a segunda data");
}
else
{
SqlDataReader drf;
conexaoBanco f = new conexaoBanco();
bool espera = false;
SqlCommand fi = f.filtro(espera, txbPesquisa.Text, cbxTipoMidia1.Text, txbIterprete1.Text, txbAutor1.Text, txbOrigem1.Text,dtpDataAlbum1.Value,dtpDataAlbum2.Value, dtpDataCompra1.Value,dtpDataCompra2.Value );
drf = fi.ExecuteReader();
lsvPrincipal.Clear();
lsvPrincipal.View = View.Details;
lsvPrincipal.FullRowSelect = true;
lsvPrincipal.GridLines = true;
lsvPrincipal.Columns.Add(drf.GetName(0), 0, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(drf.GetName(2), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(drf.GetName(3), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(drf.GetName(4), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(drf.GetName(5), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(drf.GetName(6), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(drf.GetName(7), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(drf.GetName(8), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(drf.GetName(9), 120, HorizontalAlignment.Center);
while (drf.Read())
{
ListViewItem teste = new ListViewItem();
teste.Text = drf[0].ToString();
if (drf[2].ToString() != "Nada Consta")
{
teste.SubItems.Add(drf[2].ToString());
}
else
{
teste.SubItems.Add("");
}
teste.SubItems.Add(drf[3].ToString());
teste.SubItems.Add(drf[4].ToString());
teste.SubItems.Add(drf[5].ToString());
teste.SubItems.Add(drf[6].ToString());
teste.SubItems.Add(drf[7].ToString());
teste.SubItems.Add(drf[8].ToString());
teste.SubItems.Add(drf[9].ToString());
teste.Group = lsvPrincipal.Groups[drf[1].ToString()];
lsvPrincipal.Items.Add(teste);
}
espera = true;
drf.Close();
f.filtro(espera, null, null, null, null, null, Convert.ToDateTime(null), Convert.ToDateTime(null), Convert.ToDateTime(null), Convert.ToDateTime(null));
AChaEmprestado();
}
}
}
public void preenchelist()
{
SqlDataReader dr;
conexaoBanco s = new conexaoBanco();
bool espera = false;
bool visibol = Visible = true;
SqlCommand epa = s.lv(espera);
dr = epa.ExecuteReader();
lsvPrincipal.Clear();
lsvPrincipal.View = View.Details;
lsvPrincipal.FullRowSelect = true;
lsvPrincipal.GridLines = true;
lsvPrincipal.Columns.Add(dr.GetName(0), 0, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(dr.GetName(2), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(dr.GetName(3), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(dr.GetName(4), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(dr.GetName(5), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(dr.GetName(6), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(dr.GetName(7), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(dr.GetName(8), 120, HorizontalAlignment.Center);
lsvPrincipal.Columns.Add(dr.GetName(9), 120, HorizontalAlignment.Center);
while (dr.Read())
{
string nome = dr[0].ToString();
ListViewItem teste = new ListViewItem(nome, 0);
if (dr[2].ToString() != "Nada Consta")
teste.SubItems.Add(dr[2].ToString());
else
teste.SubItems.Add("");
teste.SubItems.Add(dr[3].ToString());
teste.SubItems.Add(dr[4].ToString());
teste.SubItems.Add(dr[5].ToString());
teste.SubItems.Add(dr[6].ToString());
teste.SubItems.Add(dr[7].ToString());
teste.SubItems.Add(dr[8].ToString());
teste.SubItems.Add(dr[9].ToString());
teste.Group = lsvPrincipal.Groups[dr[1].ToString()];
lsvPrincipal.Items.Add(teste);
}
espera = true;
dr.Close();
s.lv(espera);
}
