private void Login_Load(object sender, EventArgs e)
{
(new ShowHelper()).ShowDialog();
var chkDoNotLogin = GetConfigData("ChkDoNotLogin");
ChkDoNotLogin.Checked = chkDoNotLogin == true.ToString();
var idSave = GetConfigData("CbIdSave");
if (idSave == true.ToString())
{
CbIdSave.Checked = true;
var id = GetConfigData("TxtId");
if (!string.IsNullOrEmpty(id))
{
TxtId.Text = id;
}
else
{
TxtId.Text = IdText;
}
}
else
{
TxtId.Text = IdText;
}
TxtPw.Text = PwText;
TxtId.Focus();
TxtPw.Focus();
TxtId.Focus();
}
public override int GetHashCode()
{
int hash = 1;
if (TxtId != 0)
{
hash ^= TxtId.GetHashCode();
}
if (Count != 0)
{
hash ^= Count.GetHashCode();
}
if (En.Length != 0)
{
hash ^= En.GetHashCode();
}
if (Cn.Length != 0)
{
hash ^= Cn.GetHashCode();
}
hash ^= fontsize_.GetHashCode();
hash ^= fonttype_.GetHashCode();
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
public void LimpiarTextBox()
{
TxtId.Clear();
TxtNombre.Clear();
TxtDireccion.Clear();
TxtDui.Clear();
}
private void BtnAdicionar_Click(object sender, EventArgs e)
{
//OK ADICIONANDO NA LISTA
LBITEM.Items.Clear();
VendaController venda = new VendaController();
VendaModel vendaM = new VendaModel();
vendaM = venda.ListarVendasPendentesPorId(TxtId.Text);
if (String.IsNullOrEmpty(vendaM.ValorPendente))
{
MessageBox.Show("Venda não encontrada");
}
else
{
LBITEM.Items.Add(vendaM.ValorPendente);
IdParaDecrementar = Convert.ToString(vendaM.Id);
TxtId.Text = "";
TxtId.Focus();
//CALCULAR TOTAL
Decimal VT = 0;
VT = Convert.ToDecimal(vendaM.ValorPendente);
TxtTotal.Text = Convert.ToString(VT);
}
}
private void BtnAdicionar_Click(object sender, EventArgs e)
{
//OK ADICIONANDO NA LISTA
ProdutoController produto = new ProdutoController();
ProdutoModel produtoM = new ProdutoModel();
produtoM = produto.ExibirProduto(TxtId.Text);
if (produtoM.Nome == null)
{
MessageBox.Show("Produto não encontrado");
}
else
{
LBITEM.Items.Add(produtoM.Nome);
//CALCUAR POR QUANTIDADE
VendaController v = new VendaController();
VT += v.CalcularPorQuantidade(produtoM.Nome, TxtNumQuant.Value);
TxtTotal.Text = Convert.ToString(VT);
TxtId.Text = "";
TxtId.Focus();
//MANDA PRO BANCO TEMP
produto.PreparaBanco(produtoM.Nome, TxtNumQuant.Value);
}
}
private void BtnBuscar_Click_1(object sender, EventArgs e)
{
const string buscar = "SELECT * FROM Vendedores WHERE IdVendedor=@Id";
var cmdBuscar = new OleDbCommand(buscar, Cnx)
{
CommandType = CommandType.Text
};
cmdBuscar.Parameters.AddWithValue("@Id", TxtId.Text);
Cnx.Open();
var lectura = cmdBuscar.ExecuteReader();
if (lectura != null && lectura.Read() == true)
{
TxtNombre.Text = lectura[1].ToString();
TxtFechaAlta.Text = lectura[2].ToString();
TxtNIF.Text = lectura[3].ToString();
TxtFechaNac.Text = lectura[4].ToString();
TxtDireccion.Text = lectura[5].ToString();
TxtPoblacion.Text = lectura[6].ToString();
TxtTelefono.Text = lectura[7].ToString();
TxtEstadoCivil.Text = lectura[8].ToString();
pictureBox1.ImageLocation = lectura[9].ToString();
}
else
{
MessageBox.Show(@"Los Datos a Buscar No Estan Registrados");
TxtId.Clear();
TxtId.Focus();
}
Cnx.Close();
}
private void Limpiar()
{
TxtBuscar.Clear();
TxtNombre.Clear();
TxtId.Clear();
TxtCodigo.Clear();
PanelCodigo.BackgroundImage = null;
BtnGuardarCodigo.Enabled = true;
TxtPrecioVenta.Clear();
TxtStock.Clear();
TxtImagen.Clear();
PicImagen.Image = null;
TxtDescripcion.Clear();
BtnInsertar.Visible = true;
BtnActualizar.Visible = false;
ErrorIcono.Clear();
this.RutaDestino = "";
this.RutaOrigen = "";
DgvListado.Columns[0].Visible = false;
BtnActivar.Visible = false;
BtnDesactivar.Visible = false;
BtnEliminar.Visible = false;
ChkSeleccionar.Checked = false;
}
private void BtnEliminar_Click(object sender, EventArgs e)
{
try
{
const string eliminar = "DELETE FROM Vendedores WHERE IdVendedor=@Id";
var cmd = new OleDbCommand(eliminar, Cnx)
{
CommandType = CommandType.Text
};
cmd.Parameters.AddWithValue("@Id", TxtId.Text);
Cnx.Open();
cmd.ExecuteNonQuery();
Cnx.Close();
MessageBox.Show(@"El Contacto Fue Eliminado....");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, null, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
TxtId.Clear();
TxtNombre.Clear();
TxtFechaAlta.Clear();
TxtNIF.Clear();
TxtFechaNac.Clear();
TxtDireccion.Clear();
TxtPoblacion.Clear();
TxtTelefono.Clear();
TxtEstadoCivil.Clear();
pictureBox1.ImageLocation = "";
TxtId.Focus();
}
private void Limpiar()
{
TxtRut.Clear();
TxtNombre.Clear();
TxtApellidoPaterno.Clear();
TxtApellidoMaterno.Clear();
TxtBuscar.Clear();
TxtId.Clear();
TxtDireccion.Clear();
TxtTelefono.Clear();
TxtEmail.Clear();
TxtImagen.Clear();
BtnInsertar.Visible = true;
BtnActualizar.Visible = false;
ErrorIcono.Clear();
TxtImagen.Clear();
PicImagen.Image = null;
this.RutaDestino = "";
this.RutaOrigen = "";
DgvListado.Columns[0].Visible = false;
BtnActivar.Visible = false;
BtnDesactivar.Visible = false;
BtnEliminar.Visible = false;
ChkSeleccionar.Checked = false;
}
private void BtnPesquisarL_Click(object sender, EventArgs e)
{
if (TxtId.Text != " ")
{
try
{
livro = Funcoes.PesquisarLivro(TxtId.Text);
if (livro != null)
{
TxtNome.Text = livro.Nome;
TxtAutor.Text = livro.Autor;
TxtEditora.Text = livro.Editora;
}
else
{
MessageBox.Show("Livro não encontrado!", "Cadastro de livros", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
ResetaForm();
TxtId.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("Ocorreu um erro na pesquisa do livro!" + "\n\nErro: " + ex.Message, "Cadastro de Livro", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(TxtName.Text) && !string.IsNullOrEmpty(TxtBudget.Text) && !string.IsNullOrEmpty(TxtName.Text) && comboBoxInstructors.Text != null)
{
using (var db = new SchoolEntities())
{
// parsing budget if correct
decimal budget = default;
decimal.TryParse(TxtBudget.Text, out budget);
if (budget.ToString() == "0")
{
MessageBox.Show("Invalid budget value.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
// parsing deptid if correct
int deptID = default;
int.TryParse(TxtId.Text, out deptID);
if (deptID.ToString() == "0")
{
MessageBox.Show("Invalid department ID value.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
// getting dept admin id from name + surname
var findAdmin = from o in db.Person
where (o.FirstName + " " + o.LastName).Equals(comboBoxInstructors.Text)
select o.PersonID;
var dept = new Department()
{
Name = TxtName.Text,
Budget = budget,
DepartmentID = deptID,
StartDate = dateTimeStart.Value,
Administrator = findAdmin.First()
};
TxtId.ResetText();
TxtBudget.ResetText();
TxtName.ResetText();
dateTimeStart.ResetText();
comboBoxInstructors.SelectedItem = null;
db.Department.Add(dept);
db.SaveChanges();
dataGridViewDepartments.DataSource = db.Department.ToList();
}
}
else
{
MessageBox.Show("Please enter missing information.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
void clear()
{
TxtId.Clear();
TxtNameUser.Clear();
TxtApellido.Clear();
TxtEdad.Clear();
TxtPass.Clear();
}
void Clear()
{
TxtId.Clear();
TxtNombre.Clear();
TxtApellido.Clear();;
TxtEdad.Clear();
TxtPass.Clear();
}
private void BtnTemizle_Click(object sender, EventArgs e)
{
TxtAd.Clear();
TxtAdres.Clear();
TxtId.Clear();
MskTel.Clear();
listBox1.Items.Clear();
}
private void ResetaForm()
{
TxtId.Clear();
TxtNome.Clear();
TxtAutor.Clear();
TxtEditora.Clear();
TxtNome.Focus();
}
private bool ValidateInput()
{
if (TxtLoginId.Text == "")
{
MessageBox.Show("请输入用户名", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
TxtLoginId.Focus();
return(false);
}
if (TxtLoginPwdAgain.Text == "")
{
MessageBox.Show("请输入密码", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
TxtLoginPwdAgain.Focus();
return(false);
}
if (TxtLoginPwdAgain.Text == "")
{
MessageBox.Show("请输入密码", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
TxtLoginPwdAgain.Focus();
return(false);
}
if (!(TxtLoginPwd.Text == TxtLoginPwdAgain.Text))
{
MessageBox.Show("两次输入密码不一致", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
TxtLoginPwdAgain.Focus();
return(false);
}
if (!RadioActive.Checked && !RadioInActive.Checked)
{
MessageBox.Show("请设置用户状态", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
RadioActive.Focus();
return(false);
}
if (TxtStudentName.Text == "")
{
MessageBox.Show("请输入学员姓名", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
TxtStudentName.Focus();
return(false);
}
if (TxtId.Text == "")
{
MessageBox.Show("请输入学员学号", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
TxtId.Focus();
return(false);
}
if (!RadioMale.Checked && !RadioFemale.Checked)
{
MessageBox.Show("请选择学员性别", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
RadioMale.Focus();
return(false);
}
if (CboClass.Text == "")
{
MessageBox.Show("请选择学员班级", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
CboClass.Focus();
return(false);
}
return(true);
}
private void Limpiar()
{
TxtBuscar.Clear();
TxtId.Clear();
BtnInsertar.Visible = true;
ErrorIcono.Clear();
DgvListado.Columns[0].Visible = false;
BtnAnular.Visible = false;
ChkSeleccionar.Checked = false;
}
private void MostraTodos()
{
BtnNovoL.Enabled = true;
btnGravarl.Enabled = true;
BtnCancelarL.Enabled = true;
btnExcluirL.Enabled = true;
BtnVoltarL.Enabled = true;
BtnPesquisarL.Enabled = true;
TxtId.Enabled = true;
TxtId.Focus();
}
private void Limpiar()
{
TxtId.Clear();
TxtDescripcion.Clear();
BtnInsertar.Visible = true;
BtnActualizar.Visible = false;
ErrorIcono.Clear();
DgvListado.Columns[0].Visible = false;
BtnEliminar.Visible = false;
}
private void BtnSil_Click(object sender, EventArgs e)
{
//Brans Silme işlemi
SqlCommand komutSil = new SqlCommand("Delete from Tbl_Brans where BransId=@p1", bgl.baglanti());
komutSil.Parameters.AddWithValue("@p1", TxtId.Text);
komutSil.ExecuteNonQuery();
bgl.baglanti().Close();
MessageBox.Show("Deleted");
TxtBrans.Clear();
TxtId.Clear();
}
private void Limpiar()
{
TxtNombre.Clear();
TxtId.Clear();
BtnInsertar.Visible = true;
BtnActualizar.Visible = false;
DgvListado.Columns[0].Visible = false;
BtnActivar.Visible = false;
BtnDesactivar.Visible = false;
BtnEliminar.Visible = false;
ChkSeleccionar.Checked = false;
}
private void BtnLimpiar_Click_1(object sender, EventArgs e)
{
TxtId.Clear();
TxtNombre.Clear();
TxtFechaAlta.Clear();
TxtNIF.Clear();
TxtFechaNac.Clear();
TxtDireccion.Clear();
TxtPoblacion.Clear();
TxtTelefono.Clear();
TxtEstadoCivil.Clear();
pictureBox1.ImageLocation = "";
TxtId.Focus();
}
private void BtNuevo_Click(object sender, EventArgs e)
{
//Limpiar de manera rapida
foreach (Control c in this.Controls)
{
if (c is TextBox)
{
c.Text = "";
c.Enabled = true;
//Enfoco en el primer TextBox
TxtId.Focus();
}
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
try
{
ClassCategory.AddCategory(Convert.ToInt32(TxtId.Text), TxtName.Text);
MessageBox.Show("تم اضافة اسم المجموعة", "Super market", MessageBoxButtons.OK, MessageBoxIcon.Information);
BtnNew.Enabled = true;
BtnAdd.Enabled = false;
TxtId.Clear();
TxtName.Clear();
DataPreview();
}
catch
{
}
}
//Este Metodo Limpia los campos
private void Limpiar()
{
TxtBuscar.Clear();
TxtNombre.Clear();
TxtId.Clear();
TxtDescripcion.Clear();
BtnInsertar.Visible = true;
BtnActualizar.Visible = false;
Erroricono.Clear();
//Limpiar para seleccionar
DgvListado.Columns[0].Visible = false;
BtnActivar.Visible = false;
BtnDesactivar.Visible = false;
BtnEliminar.Visible = false;
ChkSeleccionar.Checked = false;
}
private void Limpiar()
{
TxtBuscar.Clear();
TxtNombre.Clear();
TxtId.Clear();
TxtTelefono.Clear();
TxtDireccion.Clear();
TxtNumDocumento.Clear();
TxtEmail.Clear();
BtnInsertar.Visible = true;
BtnActualizar.Visible = false;
ErrorIcono.Clear();
DgvListado.Columns[0].Visible = false;
BtnEliminar.Visible = false;
ChkSeleccionar.Checked = false;
}
private void BtnEdit_Click(object sender, EventArgs e)
{
try
{
int id = Convert.ToInt32(TxtId.Text);
ClassCategory.UpdateCategory(TxtName.Text, id);
MessageBox.Show("تم تحديث اسم المجموعة", "Super market", MessageBoxButtons.OK, MessageBoxIcon.Information);
BtnEdit.Enabled = false;
BtnDelete.Enabled = false;
TxtId.Clear();
TxtName.Clear();
DataPreview();
}
catch
{
return;
}
}
private void Limpiar()
{
TxtBuscar.Clear();
TxtId.Clear();
TxtCodigo.Clear();
TxtIdCliente.Clear();
TxtNombreCliente.Clear();
TxtSerieComprobante.Clear();
TxtNumComprobante.Clear();
DtDetalle.Clear();
TxtSubtotalI.Text = "0.00";
TxtTotalImpuesto.Text = "0.00";
TxtTotal.Text = "0.00";
DgvListado.Columns[0].Visible = false;
BtnAnular.Visible = false;
ChkSeleccionar.Checked = false;
}
private void checkValues()
{
bool emailCheck = checkValiditEmail(TxtEmail.Text);
if (emailCheck == false)
{
TxtEmail.Focus();
showErrorMwssage(3010);
return;
}
if (TxtPhone.Text.Length < 9 || TxtPhone.Text.Length > 11)
{
TxtPhone.Focus();
showErrorMwssage(3011);
return;
}
string m_PERID = TxtId.Text;
char[] digits = m_PERID.PadLeft(9, '0').ToCharArray();
int[] oneTwo = { 1, 2, 1, 2, 1, 2, 1, 2, 1 };
int[] multiply = new int[9];
int[] oneDigit = new int[9];
for (int i = 0; i < 9; i++)
{
multiply[i] = Convert.ToInt32(digits[i].ToString()) * oneTwo[i];
}
for (int i = 0; i < 9; i++)
{
oneDigit[i] = (int)(multiply[i] / 10) + multiply[i] % 10;
}
int sum = 0;
for (int i = 0; i < 9; i++)
{
sum += oneDigit[i];
}
if (sum % 10 != 0)
{
showErrorMwssage(3012);
TxtId.Focus();
return;
}
}
private void BtnAgregar_Click(object sender, EventArgs e)
{
try
{
const string insertar = @"Insert Into Vendedores Values (@IdVendedor, @NombreVendedor,
@FechaAlta, @NIF, @FechaNac,@Direccion,@Poblacion,@Telefono,@EstadoCivil,@Fotografia)";
var cmd = new OleDbCommand(insertar, Cnx)
{
CommandType = CommandType.Text
};
cmd.Parameters.AddWithValue("@IdVendedor", TxtId.Text);
cmd.Parameters.AddWithValue("@NombreVendedor", TxtNombre.Text);
cmd.Parameters.AddWithValue("@FechaAlta", TxtFechaAlta.Text);
cmd.Parameters.AddWithValue("@NIF", TxtNIF.Text);
cmd.Parameters.AddWithValue("@FechaNac", TxtFechaNac.Text);
cmd.Parameters.AddWithValue("@Direccion", TxtDireccion.Text);
cmd.Parameters.AddWithValue("@Poblacion", TxtPoblacion.Text);
cmd.Parameters.AddWithValue("@Telefono", TxtTelefono.Text);
cmd.Parameters.AddWithValue("@EstadoCivil", TxtEstadoCivil.Text);
pictureBox1.ImageLocation = StrFileName;
cmd.Parameters.AddWithValue("@Fotografia", pictureBox1.ImageLocation);
Cnx.Open();
cmd.ExecuteNonQuery();
Cnx.Close();
MessageBox.Show(@"El Contacto Fue Registrado");
}
catch (Exception ex)
{
MessageBox.Show(@"La Clave a Registrar Ya Existe", ex.Message);
}
TxtId.Clear();
TxtNombre.Clear();
TxtFechaAlta.Clear();
TxtNIF.Clear();
TxtFechaNac.Clear();
TxtDireccion.Clear();
TxtPoblacion.Clear();
TxtTelefono.Clear();
TxtEstadoCivil.Clear();
pictureBox1.ImageLocation = "";
TxtId.Focus();
}
