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