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;
}
}
