private void limpiar() { TxtNit.Clear(); TxtDir.Clear(); TxtTel.Clear(); TxtNom.Clear(); }
private void limpiar() { TxtNom.Clear(); TxtCre.Clear(); TxtDir.Clear(); TxtDpi.Clear(); TxtTel.Clear(); TxtNit.Clear(); BtnGuardar.Text = "Guardar"; TxtNom.Tag = "0"; }
private void Btnmodifica_Click(object sender, EventArgs e) { OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + @"\Locadora.mdb"); try { conn.Open(); String SQL; SQL = "update clientes set nome='" + TxtNome.Text + "',"; SQL += "CPF='" + TxtCpf.Text + "',"; SQL += "Rg='" + TxtRG.Text + "',"; SQL += "DataNasc='" + TxtNasc.Text + "',"; SQL += "Telefone='" + TxtTel.Text + "',"; SQL += "Celular='" + TxtCel.Text + "',"; SQL += "Email='" + TxtEmail.Text + "',"; SQL += "Endereco='" + TxtEndereco.Text + "',"; SQL += "Bairro='" + TxtBairro.Text + "',"; SQL += "Complemento='" + TxtComplem.Text + "' "; SQL += "where Codigo=" + Codigo; OleDbCommand cmd = new OleDbCommand(SQL, conn); MetroMessageBox.Show(this, "Dados alterados com sucesso", "Dados cadastrados", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); cmd.ExecuteNonQuery(); conn.Close(); TxtNome.Clear(); TxtCpf.Clear(); TxtRG.Clear(); TxtNasc.Clear(); TxtTel.Clear(); TxtCel.Clear(); TxtEmail.Clear(); TxtEndereco.Clear(); TxtBairro.Clear(); TxtComplem.Clear(); TxtCnh.Clear(); } catch (Exception erro) { MessageBox.Show(erro.Message); } }
private void button1_Click(object sender, EventArgs e) { OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + @"\Locadora.mdb"); try { conn.Open(); String SQL; SQL = "insert into Funcionarios(Nome,CPF,Rg,DataNasc,Telefone,Celular,Email,Endereco,Bairro,Complemento,DataContrato,SalarioHora) Values('" + TxtNome.Text + "','" + TxtCpf.Text + "','" + TxtRG.Text + "','" + TxtNasc.Text + "','" + TxtTel.Text + "','" + TxtCel.Text + "','" + TxtEmail.Text + "','" + TxtEndereco.Text + "','" + TxtBairro.Text + "','" + TxtComplem.Text + "',+'" + TxtContrato2.Text + "','" + TxtSala + "')"; OleDbCommand cmd = new OleDbCommand(SQL, conn); MetroMessageBox.Show(this, "Cadastro realizado com sucesso", "Dados cadastrados", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); cmd.ExecuteNonQuery(); conn.Close(); TxtNome.Clear(); TxtCpf.Clear(); TxtRG.Clear(); TxtNasc.Clear(); TxtTel.Clear(); TxtCel.Clear(); TxtEmail.Clear(); TxtEndereco.Clear(); TxtBairro.Clear(); TxtComplem.Clear(); TxtSala.Clear(); } catch (Exception erro) { MessageBox.Show(erro.Message); } }
private void ClientClick(UInt32 ClientID_UL) { // Load client info in each control String SQLRequest_ST; SqlDataReader SqlDataReader_O; UInt32 TypeSocID_UL = 0; UInt32 CPID_UL = 0; int RappConf_i = 0, NoteEnvoi_i = 0, Certif_i = 0; // Fill info in panel edit controls mInitializingData_b = true; TxtClientNumber.Clear(); TxtClientName.Clear(); TxtTel.Clear(); TxtFax.Clear(); TxtAdressFact.Clear(); TxtAdressLivr.Clear(); TxtContactMail.Clear(); TxtContactTel.Clear(); TxtContactName.Clear(); TxtTVA.Clear(); TxtMail.Clear(); TxtRem.Clear(); CheckBoxRappConf.Checked = false; CheckBoxNE.Checked = false; CheckBoxCertif.Checked = false; DBComboxTypeSoc.ClearSelectedItem(); DBComboxCPFact.ClearSelectedItem(); DBComboxCPLivr.ClearSelectedItem(); DBComboxCPLibFact.ClearSelectedItem(); DBComboxCPLibLivr.ClearSelectedItem(); mInitializingData_b = false; if (mDBManager_O != null && mDBManager_O.mConnected_b) { SQLRequest_ST = "SELECT * FROM Client WHERE ClientID=" + ClientID_UL; SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST); mInitializingData_b = true; while (SqlDataReader_O.Read()) { int.TryParse(SqlDataReader_O["RappConf"].ToString(), out RappConf_i); int.TryParse(SqlDataReader_O["NoteEnvoi"].ToString(), out NoteEnvoi_i); int.TryParse(SqlDataReader_O["Certif"].ToString(), out Certif_i); // Fill info in panel edit controls TxtClientNumber.Text = SqlDataReader_O["NumClientInterne"].ToString(); TxtClientName.Text = SqlDataReader_O["ClientNom"].ToString(); TxtTel.Text = SqlDataReader_O["ClientTel"].ToString(); TxtFax.Text = SqlDataReader_O["ClientFax"].ToString(); TxtAdressFact.Text = SqlDataReader_O["AdresseFact"].ToString(); TxtAdressLivr.Text = SqlDataReader_O["AdresseLivraison"].ToString(); TxtContactMail.Text = SqlDataReader_O["ContactEmail"].ToString(); TxtContactTel.Text = SqlDataReader_O["ContactTel"].ToString(); TxtContactName.Text = SqlDataReader_O["Contact"].ToString(); TxtTVA.Text = SqlDataReader_O["NrTVA"].ToString(); TxtMail.Text = SqlDataReader_O["ClientMail"].ToString(); TxtRem.Text = SqlDataReader_O["ClientRem"].ToString(); CheckBoxRappConf.Checked = RappConf_i != 0 ? true : false; CheckBoxNE.Checked = NoteEnvoi_i != 0 ? true : false; CheckBoxCertif.Checked = Certif_i != 0 ? true : false; if (UInt32.TryParse(SqlDataReader_O["TypeSocID"].ToString(), out TypeSocID_UL)) { DBComboxTypeSoc.SelectItemByID(TypeSocID_UL); } if (UInt32.TryParse(SqlDataReader_O["CodePostalFactID"].ToString(), out CPID_UL)) { DBComboxCPFact.SelectItemByID(CPID_UL); DBComboxCPLibFact.SelectItemByID(CPID_UL); } else { DBComboxCPFact.ClearSelectedItem(); DBComboxCPLibFact.ClearSelectedItem(); } if (UInt32.TryParse(SqlDataReader_O["CodePostalLivraisonID"].ToString(), out CPID_UL)) { DBComboxCPLivr.SelectItemByID(CPID_UL); DBComboxCPLibLivr.SelectItemByID(CPID_UL); } else { DBComboxCPLivr.ClearSelectedItem(); DBComboxCPLibLivr.ClearSelectedItem(); } // Refresh job recap if (!String.IsNullOrEmpty(SqlDataReader_O["ClientNom"].ToString())) { DBListViewComjobRecap.SetInitialFilter("ClientNom='" + SqlDataReader_O["ClientNom"].ToString() + "'", "DelaiPromis desc"); DBListViewComjobRecap.Refresh(); } } SqlDataReader_O.Close(); mInitializingData_b = false; } }
private void MemberClick(UInt32 MemberID_UL) { // Load client info in each control String SQLRequest_ST; SqlDataReader SqlDataReader_O; UInt32 CPID_UL = 0; UInt32 PersStatusID_UL = 0; mInitializingData_b = true; TxtTel.Clear(); DTPBirthdate.Value = DTPBirthdate.MinDate; DTPEntryDate.Value = DTPEntryDate.MinDate; TxtCost.Clear(); TxtBankAccount.Clear(); TxtRegNumber.Clear(); TxtChilds.Clear(); TxtAdress.Clear(); ComBoxFamilyState.SelectedItem = null; CheckBoxActivePartner.Checked = false; DBComboxStatus.ClearSelectedItem(); ComboxPostalCode.ClearSelectedItem(); ComboxLocality.ClearSelectedItem(); LblMemberName.Text = ""; CheckBoxActivePartner.Checked = false; DepartmentSelector.Clear(); MemberDayChickingViewer.ChangePers(0, true); TxtLogin.Clear(); bool ActivePartner_b = false; if (mDBManager_O != null && mDBManager_O.mConnected_b) { // Fill fields of member SQLRequest_ST = "SELECT * FROM Pers WHERE PersID=" + MemberID_UL; SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST); while (SqlDataReader_O.Read()) { bool.TryParse(SqlDataReader_O["ConjActif"].ToString(), out ActivePartner_b); // Fill info in panel edit controls TxtTel.Text = SqlDataReader_O["NumTel"].ToString(); try { DTPBirthdate.Value = Convert.ToDateTime(SqlDataReader_O["DateNaissance"].ToString()); } catch (FormatException e) { DTPBirthdate.Value = DTPBirthdate.MinDate; } try { DTPEntryDate.Value = Convert.ToDateTime(SqlDataReader_O["DateEntreeService"].ToString()); } catch (FormatException e) { DTPEntryDate.Value = DTPEntryDate.MinDate; } TxtCost.Text = SqlDataReader_O["CoutHeure"].ToString() + "\u20AC"; TxtBankAccount.Text = SqlDataReader_O["CompteBanq"].ToString(); TxtRegNumber.Text = SqlDataReader_O["NumRegNat"].ToString(); TxtChilds.Text = SqlDataReader_O["NbrEnfCharge"].ToString(); TxtAdress.Text = SqlDataReader_O["Adresse"].ToString(); ComBoxFamilyState.Text = SqlDataReader_O["SitFam"].ToString(); TxtLogin.Text = SqlDataReader_O["UserLogin"].ToString(); CheckBoxActivePartner.Checked = ActivePartner_b; if (UInt32.TryParse(SqlDataReader_O["PersStatutID"].ToString(), out PersStatusID_UL)) { DBComboxStatus.SelectItemByID(PersStatusID_UL); } if (UInt32.TryParse(SqlDataReader_O["CodePostalID"].ToString(), out CPID_UL)) { ComboxPostalCode.SelectItemByID(CPID_UL); ComboxLocality.SelectItemByID(CPID_UL); } else { ComboxPostalCode.ClearSelectedItem(); ComboxLocality.ClearSelectedItem(); } // Fill info in panel check controls LblMemberName.Text = SqlDataReader_O["PersNom"].ToString(); CheckBoxActivePartner.Checked = ActivePartner_b; // Refresh checking recap //int NbDays = DateTime.Today.DayOfWeek - DayOfWeek.Monday; if (!String.IsNullOrEmpty(SqlDataReader_O["PersNom"].ToString())) { MemberDayChickingViewer.ChangePers(MemberID_UL, true); } } SqlDataReader_O.Close(); // Fill associated departments SQLRequest_ST = "SELECT DepID FROM RelDepPers WHERE PersID=" + MemberID_UL; SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST); List <UInt32> DepID_UL = new List <UInt32>(); UInt32 ID_UL; while (SqlDataReader_O.Read()) { if (UInt32.TryParse(SqlDataReader_O["DepID"].ToString(), out ID_UL)) { DepID_UL.Add(ID_UL); } } DepartmentSelector.CheckDepartments(DepID_UL); SqlDataReader_O.Close(); } mInitializingData_b = false; }
private void ProviderClick(UInt32 ProviderID_UL) { // Load provider info in each control String SQLRequest_ST; SqlDataReader SqlDataReader_O; UInt32 TypeSocID_UL = 0; UInt32 CPID_UL = 0; mInitializingData_b = true; TxtProviderNumber.Clear(); TxtProviderName.Clear(); TxtTel.Clear(); TxtFax.Clear(); TxtAdressFact.Clear(); TxtContactMail.Clear(); TxtContactTel.Clear(); TxtContactName.Clear(); TxtTVA.Clear(); TxtMail.Clear(); TxtRem.Clear(); DBComboxTypeSoc.ClearSelectedItem(); DBComboxCPFact.ClearSelectedItem(); DBComboxCPLibFact.ClearSelectedItem(); mInitializingData_b = false; if (mDBManager_O != null && mDBManager_O.mConnected_b) { SQLRequest_ST = "SELECT * FROM Fourn WHERE FournID=" + ProviderID_UL; SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST); mInitializingData_b = true; while (SqlDataReader_O.Read()) { // Fill info in panel edit controls TxtProviderNumber.Text = SqlDataReader_O["NumFournInterne"].ToString(); TxtProviderName.Text = SqlDataReader_O["FournNom"].ToString(); TxtTel.Text = SqlDataReader_O["FournTel"].ToString(); TxtFax.Text = SqlDataReader_O["FournFax"].ToString(); TxtAdressFact.Text = SqlDataReader_O["Adresse"].ToString(); TxtContactMail.Text = SqlDataReader_O["ContactEmail"].ToString(); TxtContactTel.Text = SqlDataReader_O["ContactTel"].ToString(); TxtContactName.Text = SqlDataReader_O["Contact"].ToString(); TxtTVA.Text = SqlDataReader_O["NrTVA"].ToString(); TxtMail.Text = SqlDataReader_O["FournMail"].ToString(); TxtRem.Text = SqlDataReader_O["FournRem"].ToString(); if (UInt32.TryParse(SqlDataReader_O["TypeSocID"].ToString(), out TypeSocID_UL)) { DBComboxTypeSoc.SelectItemByID(TypeSocID_UL); } if (UInt32.TryParse(SqlDataReader_O["CodePostalID"].ToString(), out CPID_UL)) { DBComboxCPFact.SelectItemByID(CPID_UL); DBComboxCPLibFact.SelectItemByID(CPID_UL); } else { DBComboxCPFact.ClearSelectedItem(); DBComboxCPLibFact.ClearSelectedItem(); } } SqlDataReader_O.Close(); mInitializingData_b = false; } }