/// <summary> /// Update a Client /// </summary> /// <param name="client"></param> private void updateClient(ClientDB client) { this.client = client; Data.db.SaveChanges(); //Update tabPage tabControlClients.updateTab(client); }
private void closingTab(ClientDB client) { if (client != null) { tabControlClients.removeTab(client); } }
/// <summary> /// Delete a client upon confirmation calls the method deleteClient(Client client) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSupprimer_Click(object sender, EventArgs e) { //Check whether the client isn't null if (client != null) { //Show dialog to confirm before deleting DialogResult result = MessageBox.Show("Voulez-vous supprimer le client " + client.raisonSocial, "Supprimer", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { //Deleting the client deleteClient(client); //check if the grdclient isn't empty if (grdClient.Rows.Count > 0) { //set the selected row to the first one grdClient.Rows[0].Selected = true; } else { //if no more row in the gridView then set the client to null after deleting the last client client = null; } } } }
/// <summary> /// Добавить новую запись в БД асинхронно. /// </summary> /// <param name="account1CDB">Новая запись</param> /// <param name="cancellationToken">Токен отмены</param> private async Task AddNewAccountRecordAsync(Account1C account1CDB, CancellationToken cancellationToken) { using (MKKContext dbSource = new MKKContext()) { ClientDB accountClientDB = await FindClientAndLogErrorAsync <EFService1C>(account1CDB.Client.Code1C, cancellationToken); OrganizationDB organizationDB = await FindRequiredDBRecordByNameAndLogErrorAsync <OrganizationDB, EFService1C>(account1CDB.Organization.Name, cancellationToken); SellPontDB sellPointDB = await FindRequiredDBRecordByNameAndLogErrorAsync <SellPontDB, EFService1C>(account1CDB.SellPont.Name, account1CDB.SellPont.Code1C, cancellationToken); TypeOfChargeDB typeOfCharge = await FindRequiredDBRecordByNameAndLogErrorAsync <TypeOfChargeDB, EFService1C>(account1CDB.TypeOfCharge.Name, cancellationToken); AttachAndLogError <OrganizationDB, EFService1C>(dbSource, organizationDB); AttachAndLogError <SellPontDB, EFService1C>(dbSource, sellPointDB); AttachAndLogError <ClientDB, EFService1C>(dbSource, accountClientDB); AttachAndLogError <TypeOfChargeDB, EFService1C>(dbSource, typeOfCharge); account1CDB.Organization = organizationDB; account1CDB.SellPont = sellPointDB; account1CDB.Client = accountClientDB; account1CDB.TypeOfCharge = typeOfCharge; await dbSource.Account1Cs.AddAsync(account1CDB, cancellationToken); await dbSource.SaveChangesAndLogErrorAsync <EFService1C>(new LogShortMessage( message : "/*Метод {methodName}, account1C {account1C}*/", "AddNewAccountRecordAsync", account1CDB), cancellationToken ); } }
public static DBTable GetTable(ClientDB table) { if (Tables.ContainsKey(table)) { return(Tables[table]); } return(null); }
public ActionResult DeleteConfirmed(int id) { ClientDB clientdb = db.ClientDBs.Single(x => x.ClientID == id); clientdb.cancelled = false; db.SaveChanges(); return(RedirectToAction("Index")); }
public void updateTab(ClientDB client) { if (openedTabs.ContainsKey(client.idClient)) { MyTabPage tabPage = openedTabs[client.idClient]; tabPage.Text = client.raisonSocial; } }
public ActionResult DeleteConfirmed(int id) { ClientDB clientDB = db.ClientDBs.Find(id); db.ClientDBs.Remove(clientDB); db.SaveChanges(); return(RedirectToAction("Index")); }
private void btnDelete_Click(object sender, EventArgs e) { string id = dgvResult.Rows[dgvResult.CurrentCell.RowIndex].Cells[0].Value.ToString(); DialogResult dr = new DialogResult(); dr = MessageBox.Show("Do you really want to delete a record, ID = " + id + " ?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if ((int)dr == 6) { if (frmRemax.formToManage == "house") { if (frmLogin.admin != null) { frmLogin.admin.Houses = Remax.TabHouses(); frmLogin.admin.DeleteHouse(id); HouseDB.UpdateHousesDB(frmLogin.admin.Houses); } if (frmLogin.agent != null) { house = HouseDB.getHouse(id); if (house.IdAgent != frmLogin.agent.Id) { MessageBox.Show("The house added by another agent.You can not delete."); } else { frmLogin.agent.Houses = Remax.TabHouses(); frmLogin.agent.DeleteHouse(id); HouseDB.UpdateHousesDB(frmLogin.agent.Houses); } } } else if (frmRemax.formToManage == "client") { if (frmLogin.admin != null) { frmLogin.admin.Clients = Remax.TabClients(); frmLogin.admin.DeleteClient(id); ClientDB.UpdateClientsDB(frmLogin.admin.Clients); } else { frmLogin.agent.Clients = Remax.TabClients(); frmLogin.agent.DeleteClient(id); ClientDB.UpdateClientsDB(frmLogin.agent.Clients); } } else if (frmRemax.formToManage == "employee") { frmLogin.admin.Employees = Remax.TabEmployees(); frmLogin.admin.Languages = Remax.TabLanguages(); frmLogin.admin.DeleteEmployee(id); EmployeeDB.UpdateEmployeesDB(frmLogin.admin.Employees, frmLogin.admin.Languages); } } }
public ActionResult Edit([Bind(Include = "ClientID,Name,Surname,Gender,Email,contact,DateTimeStamp,cancelled")] ClientDB clientdb) { if (ModelState.IsValid) { db.Entry(clientdb).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(clientdb)); }
/// <summary> /// Delete a reservation: /// 1. delete all RoomReservation /// 2. delete Reservation /// 3. delete Client /// </summary> public static void DeleteReservation(int idReservation) { Reservation reservation = ReservationDB.GetReservation(idReservation); ReservationDB.DeleteRoomReservation(idReservation); ReservationDB.DeleteReservation(idReservation); ClientDB.DeleteClient(reservation.Client.IdClient); }
/// <summary> /// Delete a client from the Tab and from the DB, if the client has Contacts, removes all his contacts too. /// </summary> /// <param name="client">Take a client as Parameter</param> private void deleteClient(ClientDB client) { Boolean canRemove = true; //Remove the tab from the TabControl tabControlClients.removeTab(client); //get the row of the selection to retrieve the client selected foreach (DataGridViewRow row in grdClient.SelectedRows) { //Get the id from the DataGridView Int32 id = (Int32)row.Cells[0].Value; //Find the client with the id from the DataGridView ClientDB c = Data.db.ClientDB.Find(id); //if client found if (c != null) { client = c; //Check whether the client has contacts if (client.ContactDB.Count > 0) { //confirmation to delete the client and all his contacts DialogResult result = MessageBox.Show("La suppression de " + client.raisonSocial + " entraîne la suppression de tous ses contacts \n" + "voulez-vous continuer ?", "Supprimer Contacts", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); //if confirmed if (result == DialogResult.Yes) { ////list all the contacts form the client //var L2EQuery = Data.db.ContactDB.Where(s => s.idClient == client.idClient); //List<ContactDB> listContact = L2EQuery.ToList<ContactDB>(); //for (Int32 j = 0; j < listContact.Count; j++) //{ // //Remove each contact from the DB // ContactDB contact = listContact[j]; // Data.db.ContactDB.Remove(contact); canRemove = true; //} } else { canRemove = false; } } if (canRemove) { //Remove the client Data.db.ClientDB.Remove(client); //Save all changes Data.db.SaveChanges(); //delete the reference of this client client = null; } } } }
public Main() { cdb = new ClientDB(); edb = new ExtinguisherDB(); InitializeComponent(); /*Client def = new Client(0, "Jose Manuel", "Perez Soza", "001-010190-0024G", "12345678", "*****@*****.**", * "de donde no hay luz, dos cuadras al este", "Managua", "Managua"); * cdb.create(def); * edb.create(new Extinguisher(0, 'A', "Amerex", 0, (float)12.5, "lt", "Sala de estar", DateTime.Now, def));*/ }
public ActionResult Create([Bind(Include = "ClientID,Name,Surname,Gender,Email,contact,DateTimeStamp,cancelled")] ClientDB clientdb) { if (ModelState.IsValid) { db.ClientDBs.Add(clientdb); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(clientdb)); }
//------------Events----------------------------- private void grdClient_SelectionChanged(object sender, EventArgs e) { if (grdClient.CurrentRow != null) { client = Data.db.ClientDB.Find((Int32)grdClient.CurrentRow.Cells[0].Value); } else { client = null; } }
public ActionResult Edit([Bind(Include = "ID,AccountID,PortfolioID")] ClientDB clientDB) { if (ModelState.IsValid) { db.Entry(clientDB).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AccountID = new SelectList(db.AccountDBs, "ID", "LastName", clientDB.AccountID); ViewBag.PortfolioID = new SelectList(db.PortfolioDBs, "ID", "Name", clientDB.PortfolioID); return(View(clientDB)); }
private frmDspClient detailClient(ClientDB client) { frmDspClient fdc = new frmDspClient(client); fdc.UpdatingClient += new ClientHandler(this.updateClient); fdc.DeletingClient += new ClientHandler(this.deleteClient); fdc.ClosingTab += new ClientHandler(this.closingTab); fdc.TopLevel = false; fdc.Dock = DockStyle.Fill; fdc.Show(); return(fdc); }
/// <summary> /// Remove the tab from the tabControl /// <para>Check whether the tab is already opened</para> /// </summary> public void removeTab(ClientDB client) { if (openedTabs.ContainsKey(client.idClient)) { MyTabPage tabPage = (MyTabPage)openedTabs[client.idClient]; if (tabPage != null) { this.TabPages.Remove(tabPage); openedTabs.Remove(client.idClient); } } }
/// <summary> /// Обновить информацию по договору асинхронно. /// </summary> /// <param name="account1CDB">новый договор</param> /// <param name="presentAccount1C">Договор в базе</param> /// <param name="cancellationToken">Токен отмены</param> /// <returns></returns> private static async Task UpdateAccountRecordAsync(Account1C account1CDB, Account1C presentAccount1C, CancellationToken cancellationToken) { using (IDBSource dbSource = new MKKContext()) { if (!presentAccount1C.Equals1CParams(account1CDB)) { AttachAndLogError <Account1C, EFService1C>((MKKContext)dbSource, presentAccount1C); if (presentAccount1C.Client != default) { dbSource.Entry(presentAccount1C.Client).State = EntityState.Detached; } presentAccount1C.DateTime = account1CDB.DateTime; ClientDB clientDB = await FindClientAndLogErrorAsync <EFService1C>(account1CDB.Client.Code1C, cancellationToken); dbSource.Entry(clientDB).State = EntityState.Unchanged; presentAccount1C.Client = clientDB; dbSource.Entry(presentAccount1C).State = EntityState.Modified; } if (presentAccount1C.Organization == default) { await UpdateAccountAsync(dbSource, presentAccount1C, account1CDB.Organization, cancellationToken); } if (presentAccount1C.SellPont == default) { await UpdateAccountAsync(dbSource, presentAccount1C, account1CDB.SellPont, cancellationToken); } if (presentAccount1C.TypeOfCharge == default && presentAccount1C.TypeOfCharge?.Name != account1CDB.TypeOfCharge.Name) { await UpdateAccountAsync(dbSource, presentAccount1C, account1CDB.TypeOfCharge, cancellationToken); } if (presentAccount1C.AdditionAgrement != account1CDB.AdditionAgrement) { presentAccount1C.AdditionAgrement = account1CDB.AdditionAgrement; dbSource.Entry(presentAccount1C).State = EntityState.Modified; } await dbSource.SaveChangesAndLogErrorAsync <EFService1C>(new LogShortMessage( message : "/*Метод {methodName}, document1C {document1C}, pdnValue {pdnValue}*/", "AddNewAccountRecordAsync", account1CDB, presentAccount1C, cancellationToken), cancellationToken ); } }
/// <summary> /// функция обновления данных клиента. /// </summary> /// <param name="clientTask">Задача с данными клиента</param> private static void UpdateClientFunction(ClientTask clientTask) { using (IDBSource dbSource = new MKKContext()) { if (clientTask.ClientDB.BirthDate < new DateTime(1920, 1, 1)) { LogAndThrowException <Exception, EFService1C>(_Logger, "", "Проверьте год рождения клиента {clientLastName} {clientFirstName} {clientSecondName}" + " (код клиента {clientID1C}). Год рождения: {clientBirthDate}./* Метод {methodName}.*/", clientTask.ClientDB.LastName, clientTask.ClientDB.FirstName, clientTask.ClientDB.SecondName, clientTask.ClientDB.Code1C, clientTask.ClientDB.BirthDate, "UpdateClientsInfo"); } ClientDB presentClient = clientTask.Task.ResultAndThrowException(); ICollection <GuarantorDB> guarantorDB = clientTask.ClientDB.GuarantorDBs; clientTask.ClientDB.GuarantorDBs = default; if (presentClient == default) { dbSource.Clients.Add(clientTask.ClientDB); presentClient = clientTask.ClientDB; } else { dbSource.Entry(presentClient).State = EntityState.Modified; } presentClient.BirthDate = clientTask.ClientDB.BirthDate; presentClient.FIO = clientTask.ClientDB.FIO; presentClient.FirstName = clientTask.ClientDB.FirstName; presentClient.LastName = clientTask.ClientDB.LastName; presentClient.SecondName = clientTask.ClientDB.SecondName; try { dbSource.SaveChanges(); } catch (Exception exception) { LogAndThrowException <Exception, EFService1C>(_Logger, "", "Не удалось обновить данные клиента по договору. Клиент {ClientDB}. Ошибка работы" + " с БД./* Метод {methodName}, исключение: {ContextException}*/", new ExLogValue() { LogValue = clientTask.ClientDB, ExValue = clientTask.ClientDB.Code1C }, "UpdateClientsInfo", exception); } clientTask.ClientDB.GuarantorDBs = guarantorDB; } }
/// <summary> /// Check data before inserting into database /// </summary> public static int AddReservation(string firstName, string lastName, DateTime arrival, DateTime departure, int[] roomIds) { //Insert the reservation int idClient = ClientDB.AddClient(firstName, lastName); int idReservation = ReservationDB.AddReservation(arrival, departure, idClient); foreach (int roomId in roomIds) { ReservationDB.AddRoomReservation(idReservation, roomId); } return(idReservation); }
// GET: /Client/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ClientDB clientdb = db.ClientDBs.Find(id); if (clientdb == null) { return(HttpNotFound()); } return(View(clientdb)); }
/// <summary> /// Save the client to the DB /// </summary> /// <param name="client"></param> /// <param name="toShow">To display the client TRUE otherwise FALSE</param> private void saveClient(ClientDB client, Boolean toShow) { if (client != null) { if (toShow) { if (!tabControlClients.displayTab(client)) { tabControlClients.addTab(detailClient(client)); } } Data.db.ClientDB.Add(client); Data.db.SaveChanges(); } }
// GET: /Client/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ClientDB clientdb = db.ClientDBs.Single(x => x.ClientID == id); if (clientdb == null) { return(HttpNotFound()); } return(View(clientdb)); }
// GET: ClientDBs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ClientDB clientDB = db.ClientDBs.Find(id); if (clientDB == null) { return(HttpNotFound()); } ViewBag.AccountID = new SelectList(db.AccountDBs, "ID", "LastName", clientDB.AccountID); ViewBag.PortfolioID = new SelectList(db.PortfolioDBs, "ID", "Name", clientDB.PortfolioID); return(View(clientDB)); }
private void frmManage_Load(object sender, EventArgs e) { mode = ""; house = null; employee = null; client = null; agent = null; if (frmLogin.employee == null) { User(); User user = new User(); } if (frmRemax.formToManage == "house") { if (frmLogin.admin != null) { dgvResult.DataSource = HouseDB.getViewHouses("admin"); } else { dgvResult.DataSource = HouseDB.getViewHouses("user or agent"); } } else if (frmRemax.formToManage == "client") { if (frmLogin.agent != null) { dgvResult.DataSource = ClientDB.getViewClients(frmLogin.agent.Name); } else { dgvResult.DataSource = ClientDB.getViewClients(""); } } else if (frmRemax.formToManage == "employee") { dgvResult.DataSource = EmployeeDB.getViewEmployees(""); } else if (frmRemax.formToManage == "agent") { dgvResult.DataSource = EmployeeDB.getViewEmployees("agent"); dgvResult.Columns["Image"].Visible = false; dgvResult.Columns["Role"].Visible = false; dgvResult.Columns["Password"].Visible = false; } }
private void btnCSave_Click(object sender, EventArgs e) { Client client = new Client(); if (frmManage.mode == "edit") { client.Id = frmManage.client.Id; } client.Name = txtCName.Text; client.Phone = txtCPhone.Text; client.Email = txtCEmail.Text; client.Comment = txtCComment.Text; client.IdAgent = (frmLogin.agent != null) ? frmLogin.agent.Id : cboAgent.SelectedValue.ToString(); client.Role = cboRole.Text; if (frmManage.mode == "add" && frmLogin.admin != null) { frmLogin.admin.Clients = Remax.TabClients(); frmLogin.admin.AddClient(client); ClientDB.UpdateClientsDB(frmLogin.admin.Clients); } if (frmManage.mode == "add" && frmLogin.agent != null) { frmLogin.agent.Clients = Remax.TabClients(); frmLogin.agent.AddClient(client); ClientDB.UpdateClientsDB(frmLogin.agent.Clients); } if (frmManage.mode == "edit" && frmLogin.admin != null) { client.Id = frmManage.client.Id; frmLogin.admin.Clients = Remax.TabClients(); frmLogin.admin.EditClient(client); ClientDB.UpdateClientsDB(frmLogin.admin.Clients); } if (frmManage.mode == "edit" && frmLogin.agent != null) { client.Id = frmManage.client.Id; frmLogin.agent.Clients = Remax.TabClients(); frmLogin.agent.EditClient(client); ClientDB.UpdateClientsDB(frmLogin.agent.Clients); } this.Close(); }
public Boolean displayTab(ClientDB client) { Boolean tabExist = false; if (openedTabs.ContainsKey(client.idClient)) { MyTabPage tabPage = (MyTabPage)openedTabs[client.idClient]; this.SelectTab(tabPage); tabExist = true; } else { tabExist = false; } return(tabExist); }
protected void GVClient_RowCommand(object sender, GridViewCommandEventArgs e) { var db = new ClientDB(); int index = Convert.ToInt32(e.CommandArgument); var row = GVClient.Rows[index]; int idClient = int.Parse(row.Cells[0].Text); Client client = db.SelectById(idClient); if (e.CommandName == "EXCLUIR") { db.Delete(client.Id); LoadGrid(); } else if (e.CommandName == "ALTERAR") { TxtName.Text = client.Name; TxtTelephone.Text = client.Telephone; HFId.Value = client.Id.ToString(); } }
private void btnRefresh_Click(object sender, EventArgs e) { checkBoxName.Checked = checkBoxID.Checked = false; txtSearch.Text = ""; if (frmRemax.formToManage == "house") { if (frmLogin.admin != null) { dgvResult.DataSource = HouseDB.getViewHouses("admin"); } else { dgvResult.DataSource = HouseDB.getViewHouses("user or agent"); } } if (frmRemax.formToManage == "client") { if (frmLogin.agent == null) { dgvResult.DataSource = ClientDB.getViewClients(""); } else { dgvResult.DataSource = ClientDB.getViewClients(frmLogin.agent.Name); } } if (frmRemax.formToManage == "employee") { dgvResult.DataSource = EmployeeDB.getViewEmployees(""); } if (frmRemax.formToManage == "agent") { dgvResult.DataSource = EmployeeDB.getViewEmployees("agent"); dgvResult.Columns["Image"].Visible = false; dgvResult.Columns["Role"].Visible = false; dgvResult.Columns["Password"].Visible = false; } }