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