private void btnSave_Click(object sender, EventArgs e)
{
if (MetroMessageBox.Show(this, "Are you sure you want to update this register?", "Update", MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
EntitiesContext context = new EntitiesContext();
ClientDAO cdao = new ClientDAO();
a = DateTime.Parse(mdtBirthClient.Text);
b = a.ToString("dd/MM/yyyy");
if (rbMale.Checked)
{
sexoption = rbMale.Text;
}
else
{
sexoption = rbFemale.Text;
}
Client client = cdao.FindId(global.idcli);
client.Cpf = txtCpfClient.Text;
client.Name = txtNameClient.Text;
client.Rg = txtRgClient.Text;
client.BirthDt = DateTime.Parse(b);
client.Tel = txtTelClient.Text;
client.Sex = sexoption;
cdao.Update();
MetroMessageBox.Show(this, "Register Successfully Updated", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
}
}
private void btnFilter_Click(object sender, EventArgs e)
{
if (mcbFilterBy.SelectedIndex == 0)
{
idcli = int.Parse(txtFilter.Text);
namecli = null;
}
if (mcbFilterBy.SelectedIndex == 1)
{
namecli = txtFilter.Text;
idcli = 0;
}
ClientDAO cdao = new ClientDAO();
var bindingList = new BindingList <Client>(cdao.Filter(idcli, namecli));
var source = new BindingSource(bindingList, null);
dgvClients.DataSource = source;
dgvClients.Columns[0].HeaderText = "Client ID";
dgvClients.Columns[1].HeaderText = "CPF";
dgvClients.Columns[2].HeaderText = "Full Name";
dgvClients.Columns[3].HeaderText = "Birth Date";
dgvClients.Columns[4].HeaderText = "RG";
dgvClients.Columns[5].HeaderText = "Sex";
dgvClients.Columns[6].HeaderText = "Cell Phone";
}
public void Prepare_Export(string path)
{
try
{
string fullPath = path + "liste_clients_SAIM_LTD.txt";
List<Client> clients = new ClientDAO().GetCustomers();
if (!Directory.Exists(path)) Directory.CreateDirectory(path);
if (File.Exists(fullPath)) File.Delete(fullPath);
using (StreamWriter writer = new StreamWriter(fullPath))
{
foreach(Client client in clients)
{
string line = "denomination=" + client.GetDenomination() + "|";
line += "adresse=" + client.GetAdresse() + "|";
line += "telephone=" + client.GetTelephone() + "|";
line += "mail=" + client.GetMail() + "|";
line += "siren=" + client.GetSiren() + "|";
line += "activite=" + client.GetActivite() + "|";
line += "capital=" + client.GetCapital() + "|";
line += "forme_juridique=" + client.GetFormeJuridique();
writer.WriteLine(line);
}
}
}
catch (Exception)
{
throw;
}
}
public ClientDTO GetById(int id)
{
ClientDAO resultClientDAO = clientRepository.GetById(id).Result;
ClientDTO resultClientDTO = converter.fromDAOTodTO(resultClientDAO);
return(resultClientDTO);
}
//http://localhost:8080/api/login?clientNo=1001&key=K1001&userNo=1001&password=1
public Task <Token> Login(string clientNo, string key, string userNo, string password)
{
return(Task.Run(() =>
{
Client client = new ClientDAO().GetByClientNo(clientNo);
if (client == null)
{
throw new Exception("不存在的客户端编号!");
}
if (client.Key != key)
{
throw new Exception("客户端密钥错误!");
}
User u = new UserDAO().GetByUserNo(userNo);
if (null == u)
{
throw new Exception("用户不存在!");
}
if (u.Pass != password)
{
throw new Exception("用户密码错误!");
}
//生成Token,加入缓存
Token token = new TokenService().CreateToken(u, clientNo);
MemCache.Set(token.AccessToken, u, Convert.ToInt64((token.ExpiresUtc - token.IssuedUtc).TotalSeconds));
MemCache.Set(token.RefreshToken, token.AccessToken);
return token;
}));
}
public async Task <ClientDAO> Update(ClientDAO entity)
{
clientContext.Update(entity);
await clientContext.SaveChangesAsync();
return(entity);
}
public async Task <IActionResult> PutClient(int id, ClientDAO client)
{
if (id != client.Id)
{
return(BadRequest());
}
_context.Entry(client).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ClientExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <ClientDAO> > PostClient(ClientDAO client)
{
_context.Clients.Add(client);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetClient", new { id = client.Id }, client));
}
public void clientsPro()
{
ListeClientPro = new List <UnClientPROVM>();
try
{
List <Client> listedesclientproDTO = (List <Client>)ClientDAO.selectProClient();
if (listedesclientproDTO != null)
{
foreach (Client cl in listedesclientproDTO)
{
ListeClientPro.Add(new UnClientPROVM()
{
clt = cl
});
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex);
ListeClientPro.Add(new UnClientPROVM()
{
NomSociete_clientPro = "Error"
});
}
}
public OrderFullInfo NewOrder([FromBody] Client c)
{
// khassni nzidt JWT checking
FastFoodEntities db = new FastFoodEntities();
TORDER torder = new TORDER();
torder.order_state = OrderStates.choosing_food;
torder.id_client = c.id_client;
db.TORDERs.Add(torder);
db.SaveChanges();
OrderFullInfo order = new OrderFullInfo();
order.id_order = torder.id_order;
order.order_state = torder.order_state;
order.latitude = torder.latitude;
order.longitude = torder.longitude;
order.order_datetime = torder.order_datetime;
order.order_code = torder.order_code;
order.delivery_state = torder.delivery_state;
order.received_datetime = torder.received_datetime;
order.id_delivery_man = torder.id_delivery_man;
order.id_client = torder.id_client;
order.delivery_man = new Delivery_man();
order.client = ClientDAO.GetClient(torder.id_client);
return(order);
}
public void enregisterClient()
{
//client.nom = Txb_nouveauClientPro_nomSociete;
client.prenom = Txb_nouveauClientPro_nomSociete;
client.type = 1;
//client.dateNaissance = null;
//client.adresse = new Model.Adresse();
//client.adresse.numero = Txb_nouveauClientPro_numeroAdresse + "";
//client.adresse.rue = Txb_nouveauClientPro_rue_voie;
//client.adresse.codePostal = Txb_nouveauClientPro_bp;
//client.adresse.ville = Txb_nouveauClientPro_ville;
// client.telfix = Txb_nouveauClientPro_numeroFixe;
//client.telmob = Txb_nouveauClientPro_numeroPortable;
//client.email = Txb_nouveauClientPro_email;
index = 0;
index = ClientDAO.insertClient(client);
if (index != 0)
{
MessageBox.Show("Client pro enregistré");
}
else
{
MessageBox.Show("Client pro non enregistré");
}
}
public ActionResult Ajouterback(String id, String nom, String prenom, DateTime dateNaissance)
{
Client c = new Client(id, nom, prenom, dateNaissance);
ClientDAO.UpdateOrAddClient(c);
return(View("Index", ClientDAO.getAllClients()));
}
private void frmClients_Load(object sender, EventArgs e)
{
this.Text = Strings.Clients;
lblTitle.Text = Strings.Clients;
lblBack.Text = Strings.Back;
mt1.Text = Strings.Add;
mt2.Text = Strings.Query;
mt3.Text = Strings.Edit;
lblTitle.Text = Strings.Client_Query;
ucAddClient1.Visible = false;
ClientDAO cdao = new ClientDAO();
var bindingList = new BindingList <Client>(cdao.List());
var source = new BindingSource(bindingList, null);
ucQueryClient1.dgvClients.DataSource = source;
ucQueryClient1.dgvClients.Columns[0].HeaderText = "Client ID";
ucQueryClient1.dgvClients.Columns[1].HeaderText = "CPF";
ucQueryClient1.dgvClients.Columns[2].HeaderText = "Full Name";
ucQueryClient1.dgvClients.Columns[3].HeaderText = "Birth Date";
ucQueryClient1.dgvClients.Columns[4].HeaderText = "RG";
ucQueryClient1.dgvClients.Columns[5].HeaderText = "Sex";
ucQueryClient1.dgvClients.Columns[6].HeaderText = "Cell Phone";
ucEditClient1.dgvClients.DataSource = source;
ucEditClient1.dgvClients.Columns[0].HeaderText = "Client ID";
ucEditClient1.dgvClients.Columns[1].HeaderText = "CPF";
ucEditClient1.dgvClients.Columns[2].HeaderText = "Full Name";
ucEditClient1.dgvClients.Columns[3].HeaderText = "Birth Date";
ucEditClient1.dgvClients.Columns[4].HeaderText = "RG";
ucEditClient1.dgvClients.Columns[5].HeaderText = "Sex";
ucEditClient1.dgvClients.Columns[6].HeaderText = "Cell Phone";
ucQueryClient1.Visible = true;
}
public async Task <ClientDAO> Create(ClientDAO clientDAO)
{
clientContext.Add(clientDAO);
await clientContext.SaveChangesAsync();
return(clientDAO);
}
private void btnRegistrer_Click(object sender, EventArgs e)
{
if (MetroMessageBox.Show(this, Strings.ConfRegister, Strings.Register, MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
EntitiesContext context = new EntitiesContext();
ClientDAO cdao = new ClientDAO();
a = DateTime.Parse(mdtBirthClient.Text);
b = a.ToString("dd/MM/yyyy");
if (rbMale.Checked)
{
sexoption = rbMale.Text;
}
else
{
sexoption = rbFemale.Text;
}
Client client = new Client()
{
Cpf = txtCpfClient.Text,
Name = txtNameClient.Text,
Rg = txtRgClient.Text,
BirthDt = DateTime.Parse(b),
Tel = txtTelClient.Text,
Sex = sexoption
};
cdao.Add(client);
MetroMessageBox.Show(this, Strings.SuccessRegistered, Strings.Registered, MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
}
}
private void Form5_Load(object sender, EventArgs e)
{
if (Global.Modification == true)
{
BtnModifClient.Visible = true;
BtnSupClient.Visible = false;
BtnValider.Visible = false;
}
if (Global.Supprime == true)
{
BtnModifClient.Visible = false;
BtnSupClient.Visible = true;
BtnValider.Visible = false;
}
else if (Global.Recherche == true)
{
BtnSupClient.Visible = false;
BtnModifClient.Visible = false;
BtnValider.Visible = true;
}
ClientDAO repo2 = new ClientDAO();
dataGridView1.DataSource = repo2.ListClientNum(Global.ID);
for (int i = 4; i < 21; i++)
{
dataGridView1.Columns[i].Visible = false;
}
ParamDataGrid(dataGridView1);
dataGridView1.Columns[13].Visible = true;
dataGridView1.Columns[0].HeaderText = "Référence Client";
}
private void addClient_Click(object sender, EventArgs e)
{
try
{
string code = this.clientCode.Text;
string clientName = this.clientName.Text;
string clientLastName = this.clientLastName.Text;
string email = this.clientEmail.Text;
int tel = int.Parse(this.clientTel.Text);
string adress = this.clientAdress.Text;
ClientDAO clientDAO = new ClientDAO();
Client client = new Client(code, clientName, clientLastName, email, tel, adress);
Boolean response = clientDAO.setClient(client);
this.message.Visible = true;
this.errorLabel.Visible = false;
if (response)
{
this.message.Text = "Client Was Added With Success";
}
else
{
this.message.Text = "An Error Has Occured While Adding The Client";
throw (new ClIENT_EXISTE_EXCEPTION("There's already a client with the mentioned ID"));
}
}
catch (ClIENT_EXISTE_EXCEPTION exception)
{
string title = "Exception";
string message = exception.Message;
MessageBox.Show(message, title);
Console.WriteLine(exception.Message);
}
}
//type = 0 : Lecture X
//type = 1 : lecture Z
public LectureExcel(int type)
{
this.type = type;
error = 0;
try
{
listUsedDepartements = new List <Departement>();
caTTCDep = new List <float>();
listUsedTypePaiement = PayementDAO.listSommePaiementToday(1);
DepartmentTTC(ArticleDAO.selectArticlePayeeByDateNoCleanWay(1));
List <Commande> listCommandeRecuToday = CommandeDAO.listCommandeRecuToday(1);
listUsedTypeArticle = new List <string>();
reçutArticle = new List <int>();
renduArticle = new List <int>();
TypeArticlesRendu(ArticleDAO.selectArticleRenduByDate(1), listCommandeRecuToday);
nbNewCommande = listCommandeRecuToday.Count;
nbNewClient = ClientDAO.listClientAddToday(1).Count;
}
catch (Exception e)
{
if (error == 0)
{
MessageBox.Show("Erreur dans la récupération des données pour l'impression de la facture: /n" + e);
}
error = 1;
}
}
public EntryClient(string name, string password)
{
_clientDAO = new ClientDAO();
if (CheckClient(name, password))
{
Entry(name);
}
}
// GET: Reservations/ReservationsAdd
public ActionResult ReservationsAdd()
{
//send to reservationAdd form
var clients = ClientDAO.GetClients();
var halls = HallDAO.GetHalls();
return(View());
}
public ClientDTO Update(ClientDTO entity)
{
ClientDAO clientDAO = converter.fromDTOTodAO(entity);
ClientDAO resultClientDAO = clientRepository.Update(clientDAO).Result;
ClientDTO resultClientDTO = converter.fromDAOTodTO(resultClientDAO);
return(resultClientDTO);
}
public OrderBusiness()
{
_orderDAO = new OrderDAO();
_productDAO = new ProductDAO();
_clientDAO = new ClientDAO();
_clientBus = new ClientBusiness();
_orderStatusDAO = new OrderStatusDAO();
}
private void Form1_Load(object sender, EventArgs e)
{
ClientDAO data = new ClientDAO();
listBox1.DisplayMember = "Nom";
listBox1.ValueMember = "Id";
listBox1.DataSource = data.List();
Width = 254;
}
public async Task <ClientDAO> Delete(int id)
{
ClientDAO ClientDAO = clientContext.Clients.Find(id);
clientContext.Remove(id);
await clientContext.SaveChangesAsync();
return(ClientDAO);
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MetroMessageBox.Show(this, "Are you sure you want to delete this register?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Stop, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
ClientDAO cdao = new ClientDAO();
Client client = cdao.FindId(global.idcli);
cdao.Remove(client);
MetroMessageBox.Show(this, "Register Successfully Deleted", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
ClientDAO.Delete_client(int.Parse(txt_ID.Text));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public ActionResult Edit(int id)
{
var client = ClientDAO.GetClient(id);
if (client == null)
{
return(HttpNotFound());
}
return(View("ClientAdd", client));
}
private void Form1_Load(object sender, EventArgs e)
{
ClientDAO repo = new ClientDAO();
listBox1.DisplayMember = "Nom";
listBox1.DataSource = repo.List();
dataGridView1.DataSource = repo.List();
dataGridView1.Columns[0].Visible = false;
}
public ActionResult Delete(int id)
{
var client = ClientDAO.GetClient(id);
if (client == null)
{
return(HttpNotFound());
}
ClientDAO.Delete(client);
return(RedirectToAction("ClientList"));
}
private void TxtBoxMail_Validating(object sender, CancelEventArgs e)
{
ClientDAO test = new ClientDAO();
if (test.TestMail(TxtBoxMail.Text) != "")
{
MessageBox.Show("Une erreur a été détectée : " + test.TestMail(TxtBoxMail.Text), "Erreur adresse E-mail", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
}
}
public ClientBUS()
{
ctDao = new ClientDAO();
}
