public void TestSetWaiterRequest()
{
IndividualClient client1 = (IndividualClient) new FactoryClients().CreateIndividualClientInterface(1, 90, 1, false);
client1.WaiterRequest = true;
Assert.AreEqual(client1.WaiterRequest, true);
}
public void TestSetChoice()
{
IndividualClient client1 = (IndividualClient) new FactoryClients().CreateIndividualClientInterface(1, 90, 1, false);
client1.Choice = 2;
Assert.AreEqual(client1.Choice, 2);
}
public void InsertIndividualClient(IndividualClient client)
{
string query = $"insert into IndividualClients values" +
$"('{client.clientID}', " +
$"'{client.Name}', " +
$"'{client.Surname}', " +
$"{client.Phone}, " +
$"'{client.Email}', " +
$"'{client.AddressID}', " +
$"'{client.ContractID}')";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("ERROR: " + ex.Message);
}
finally
{
conn.Close();
}
}
public void UpdateIndividualClient(IndividualClient client)
{
string query = $"update IndividualClients set " +
$"ClientID = '{client.clientID}', " +
$"ClientName = '{client.Name}', " +
$"ClientSurname = '{client.Surname}', " +
$"Phone = {client.Phone}, " +
$"Email = '{client.Email}', " +
$"AddressID = '{client.AddressID}', " +
$"ContractID = '{client.ContractID}' where " +
$"ClientID = '{client.clientID}'";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("Updated Successfully");
}
catch (Exception ex)
{
MessageBox.Show("ERROR: " + ex.Message);
}
finally
{
conn.Close();
}
}
public List <IndividualClient> GetAllIndividualClients()
{
List <IndividualClient> individualClients = new List <IndividualClient>();
DataTable datatable = new DataTable();
string query = $"SELECT * FROM IndividualClients ";
try
{
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(query, conn);
adapter.Fill(datatable);
foreach (DataRow row in datatable.Rows)
{
IndividualClient individualClient = new IndividualClient();
individualClient.clientID = row["ClientID"].ToString();
individualClient.Name = row["EmployeeName"].ToString();
individualClient.Surname = row["EmployeeSurname"].ToString();
individualClient.Phone = row["Phone"].ToString();
individualClient.Email = row["Email"].ToString();
individualClient.AddressID = row["AddressID"].ToString();
individualClients.Add(individualClient);
}
}
catch (Exception ex)
{
MessageBox.Show("ERROR: " + ex.Message);
}
finally
{
conn.Close();
}
return(individualClients);
}
public IndividualClient GetIndividualClientByID(string id)
{
IndividualClientDAL clientData = new IndividualClientDAL();
IndividualClient client = clientData.SearchIndividualClientByID(id);
return(client);
}
public bool AddUpdateEmployee(Employees Employee, long clientId)
{
bool success = false;
if (Employee.EmployeeId > 0)
{
var empdetail = SubDataContext.Employees.Where(x => x.EmployeeId == Employee.EmployeeId).FirstOrDefault();
empdetail.Title = Employee.Title;
empdetail.FirstName = Employee.FirstName;
empdetail.Lastname = Employee.Lastname;
empdetail.HireDate = Employee.HireDate;
empdetail.TerminationDate = Employee.TerminationDate;
empdetail.Address = Employee.Address;
subuow.SaveChanges();
}
else
{
subuow.Repository <Employees>().Add(Employee);
subuow.SaveChanges();
}
IndividualClient iclient = new IndividualClient();
iclient.ClientRecordId = clientId;
iclient.EmployeeId = Employee.EmployeeId;
iclient.CreatedBy = SessionManagement.LoggedInUser.UserId;
iclient.CreatedDate = DateTime.Now;
iclient.IndividualClientRecordId = 1;
iclient.IndividualRecordId = 1;
iclient.IsActive = true;
iclient.IsDeleted = false;
subuow.Repository <IndividualClient>().Add(iclient);
subuow.SaveChanges();
success = true;
return(success);
}
private void btnDeleteI_Click(object sender, EventArgs e)
{
DialogResult deleteI = MessageBox.Show("Are you sure you want to delete this Client?", "WARNING: DELETE CLIENT",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (deleteI == DialogResult.Yes)
{
if (lstClientsI.SelectedItems.Count > 0)
{
//MessageBox.Show((lstClientsI.SelectedItems[0].Tag as Client).ToString());
IndividualClientController individualClientController = new IndividualClientController();
IndividualClient client = lstClientsI.SelectedItems[0].Tag as IndividualClient;
individualClientController.Delete(client);
lstClientsI.Items.Clear();
LoadIndividualClient();
MessageBox.Show("Client successfully deleted", "INDIVIDUAL CLIENT DELETED",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Client NOT deleted", "CLIENT UNCHANGED",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnRefresh_Click(object sender, EventArgs e)
{
IndividualClient client = new IndividualClient();
source.DataSource = client.GetCustomTable();
dgvIndividualClients.DataSource = source;
}
static void Main()
{
ClientRepository client = new IndividualClient();
DataObject obj = new PhysicalObject();
client.Buy(obj);
client.Borrow(obj);
}
public frmViewContract(IndividualClient indivClient)
{
InitializeComponent();
this.indivClient = indivClient;
tbIndivName.Text = indivClient.Name;
tbIndivSurname.Text = indivClient.Surname;
tbIndivContact.Text = indivClient.ContactNum;
}
private void btnUpdateClient_Click(object sender, EventArgs e)
{
panel3.Enabled = true;
panel3.Visible = true;
IndividualClient client = new IndividualClient();
source.DataSource = client.GetCustomTable();
dgvIndividualClients.DataSource = source;
}
public void TestSetTimeSpend()
{
IndividualClient client1 = (IndividualClient) new FactoryClients().CreateIndividualClientInterface(1, 90, 1, false);
client1.TimeSpend = 120;
Assert.AreEqual(client1.TimeSpend, 120);
client1.TimeSpend = 180;
Assert.AreEqual(client1.TimeSpend, 120);
}
public frmEditIndividualClient(IndividualClient individualClient)
{
InitializeComponent();
this.individualClient = individualClient;
tbName.Text = individualClient.Name;
tbSurname.Text = individualClient.Surname;
tbContactDetails.Text = individualClient.ContactNum;
tbClientID.Text = individualClient.ClientIdentifier;
}
public void UpdateIndividualClient(IndividualClient client)
{
try
{
IndividualClientDAL clientData = new IndividualClientDAL();
clientData.UpdateIndividualClient(client);
}
catch (Exception e)
{
MessageBox.Show($"Error: {e.Message}");
}
}
public Client ReadChild(Request parent)
{
DataHandler dh = new DataHandler();
string qry = string.Format
(
"SELECT R.ClientID, BC.name, IC.name, IC.surname, C.contactNum, C.ClientIdentifier " +
"FROM Request R " +
"LEFT OUTER JOIN Client C ON C.ClientID = R.ClientID " +
"LEFT OUTER JOIN IndividualClient IC ON IC.IndividualClientID = C.ClientID " +
"LEFT OUTER JOIN BusinessClient BC ON BC.BusinessClientID = C.ClientID " +
"WHERE RequestID = {0}", parent.Id
);
SqlDataReader read = dh.Select(qry);
Client newClient = null;
if (read.HasRows)
{
while (read.Read())
{
if (read.IsDBNull(1))
{
Console.WriteLine(read.GetInt32(0));
Console.WriteLine(read.GetString(2));
Console.WriteLine(read.GetString(3));
newClient = new IndividualClient(
read.GetString(4),
read.GetString(2),
read.GetString(3),
read.IsDBNull(5) ? null : read.GetString(5)
);
}
else
{
newClient = new BusinessClient(
read.GetString(4),
read.GetString(1),
read.IsDBNull(5) ? null : read.GetString(5)
);
}
newClient.Id = read.GetInt32(0);
}
}
dh.Dispose();
return(newClient);
}
public HttpResponseMessage UpdateIndividualClient([FromBody] IndividualClient changedClient)
{
IndClientRepository _repo = new IndClientRepository();
try
{
_repo.UpdateOfIndividualClient(changedClient);
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public HttpResponseMessage DetailsIndividualClient(int id)
{
IndClientRepository _repo = new IndClientRepository();
try
{
IndividualClient client = _repo.DetailsOfIndividualClient(id);
return(Request.CreateResponse(HttpStatusCode.OK, client));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
//allows to search the database for a client
string id = txtSearchClient.Text;
IndividualClientBLL bll = new IndividualClientBLL();
IndividualClient ic = bll.GetIndividualClientByID(id);
BindingSource source = new BindingSource();
source.Add(ic);
dgvClientDetails.DataSource = source;
}
public async Task <IHttpActionResult> AddIndividualClient([FromBody] IndividualClient individualClient)
{
IndClientRepository _repo = new IndClientRepository();
try
{
_repo.AddIndividualClient(individualClient);
return(StatusCode(HttpStatusCode.Created));
}
catch (Exception ex)
{
return(StatusCode(HttpStatusCode.BadRequest));
}
}
public bool AddClient(ClientViewModel model)
{
try
{
using (SubDataContext = new DmsSubDomainContext())
{
Clients objClient = new Clients();
objClient.AccountingFirmId = Convert.ToInt32(SessionManagement.LoggedInUser.FirmId);
objClient.ClientName = model.ClientName;
objClient.ClientAddress = model.ClientAddress;
objClient.Phone = model.PhoneNumber;
objClient.EmailAddress = model.EmailAddress;
objClient.FirstName = model.FirstName;
objClient.MiddleName = model.MiddleName;
objClient.LastName = model.LastName;
objClient.ClientType = model.ClientType;
objClient.BirthDate = Convert.ToDateTime(model.BirthDate);
objClient.SSN = Convert.ToString(model.SSN);
objClient.IsActive = true;
objClient.IsDeleted = false;
objClient.CreatedDate = DateTime.Now;
objClient.CreatedBy = SessionManagement.LoggedInUser.UserId;
subuow.Repository <Clients>().Add(objClient);
subuow.SaveChanges();
if (model.ClientType == 1)
{
IndividualClient objIndividualClient = new IndividualClient();
objIndividualClient.ClientRecordId = 1;
objIndividualClient.CreatedBy = SessionManagement.LoggedInUser.UserId;
objIndividualClient.CreatedDate = DateTime.Now;
// objIndividualClient.EmployeeId = null;
objIndividualClient.IndividualRecordId = 1;
objIndividualClient.IsActive = true;
objIndividualClient.IsDeleted = false;
objIndividualClient.IsIndividualClient = true;
objIndividualClient.ClientRecordId = objClient.ClientId;
subuow.Repository <IndividualClient>().Add(objIndividualClient);
subuow.SaveChanges();
}
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
void LoadServiceContractRequests()
{
lvServiceContractRequests.Items.Clear();
NewContractRequestController newContractRequestController = new NewContractRequestController();
foreach (NewContractRequest newContractRequest in newContractRequestController.Read())
{
if (newContractRequest.Status != "Open")
{
continue;
}
Client client = newContractRequest.Client;
if (client is IndividualClient)
{
IndividualClient iClient = client as IndividualClient;
ListViewItem listViewItem = new ListViewItem(new string[] {
String.Format("{0} {1}", iClient.Name, iClient.Surname),
"Individual Client",
newContractRequest.ServiceContract.Description,
newContractRequest.DateCreated.ToShortDateString(),
newContractRequest.Status
});
listViewItem.Tag = newContractRequest;
lvServiceContractRequests.Items.Add(listViewItem);
}
else
{
BusinessClient bClient = client as BusinessClient;
ListViewItem listViewItem = new ListViewItem(new string[] {
bClient.Name,
"Business Client",
newContractRequest.ServiceContract.Description,
newContractRequest.DateCreated.ToShortDateString(),
newContractRequest.Status
});
listViewItem.Tag = newContractRequest;
lvServiceContractRequests.Items.Add(listViewItem);
}
}
}
public void IdIsUsedForEquality(IndividualClient c1, IndividualClient c2)
{
bool b = c1.Equals(c2);
if (c1.ClientId == c2.ClientId)
{
Assert.True(c1 == c2);
Assert.True(c1.Equals(c2));
}
else
{
Assert.False(c1 == c2);
Assert.False(c1.Equals(c2));
}
}
private void btnViewContractI_Click(object sender, EventArgs e)
{
if (lstClientsI.SelectedItems.Count > 0)
{
IndividualClient client = lstClientsI.SelectedItems[0].Tag as IndividualClient;
//MessageBox.Show(this.ToString() + client.ToString());
frmViewContract viewContrFrm = new frmViewContract(client);
viewContrFrm.ShowDialog();
}
else
{
MessageBox.Show("Please select a field to view", "SELECT A FIELD",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnIndividualNew_Click(object sender, EventArgs e)
{
newcontact = txtContact.Text;
newclientname = txtNameNewI.Text;
newclientsurname = txtSurnameNewI.Text;
clientID = tbClientID.Text;
IndividualClientController individualClientController = new IndividualClientController();
IndividualClient individualClient = new IndividualClient(
newcontact,
newclientname,
newclientsurname,
clientID
);
if (newcontact.Equals(""))
{
MessageBox.Show("Please enter client contact details", "EMPTY FIELDS!!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (newclientname.Equals(""))
{
MessageBox.Show("Please enter a client name", "EMPTY FIELDS!!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (newclientsurname.Equals(""))
{
MessageBox.Show("Please enter a client name", "EMPTY FIELDS!!",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
individualClientController.Create(individualClient);
MessageBox.Show("Individual Client add successful, returning to Client Menu", "INDIVIDUAL CLIENT ADDED",
MessageBoxButtons.OK, MessageBoxIcon.Information);
Hide();
frmClientMenu form = new frmClientMenu();
form.ShowDialog();
Show();
}
}
private void btnEditI_Click(object sender, EventArgs e)
{
//Individual = true;
//Hide();
//frmEditClient form = new frmEditClient();
//form.ShowDialog();
if (lstClientsI.SelectedItems.Count > 0)
{
IndividualClient client = lstClientsI.SelectedItems[0].Tag as IndividualClient;
frmEditIndividualClient editFrm = new frmEditIndividualClient(client);
editFrm.ShowDialog();
LoadIndividualClient();
}
}
public void UpdateOfIndividualClient(IndividualClient changedClient)
{
using (OracleConnection SQLConnect =
new OracleConnection(ConfigurationManager.ConnectionStrings["OracleConnectionString"].ConnectionString))
{
var id = new OracleParameter("p_id", OracleDbType.Int32,
changedClient.ID, ParameterDirection.Input);
var name = new OracleParameter("p_name", OracleDbType.Varchar2,
changedClient.Name, ParameterDirection.Input);
var email = new OracleParameter("p_email", OracleDbType.Varchar2,
changedClient.EMail, ParameterDirection.Input);
var street = new OracleParameter("p_street", OracleDbType.Varchar2,
changedClient.Street, ParameterDirection.Input);
var city = new OracleParameter("p_city", OracleDbType.Varchar2,
changedClient.City, ParameterDirection.Input);
var zip = new OracleParameter("p_zip", OracleDbType.Varchar2,
changedClient.PostalCode, ParameterDirection.Input);
var type = new OracleParameter("p_type", OracleDbType.Int32,
changedClient.TypeId, ParameterDirection.Input);
var industryIds = new OracleParameter("p_IndustryIds", OracleDbType.Int32,
changedClient.Industries, ParameterDirection.Input);
industryIds.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
industryIds.Size = changedClient.Industries.Length;
SQLConnect.Open();
var com = SQLConnect.CreateCommand();
com.CommandText = "CRM_Package.Edit_IndividualClient2";
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(id);
com.Parameters.Add(name);
com.Parameters.Add(email);
com.Parameters.Add(street);
com.Parameters.Add(city);
com.Parameters.Add(zip);
com.Parameters.Add(type);
com.Parameters.Add(industryIds);
com.ExecuteNonQuery();
}
}
public IndividualClient SearchIndividualClientByID(string id)
{
IndividualClient myClient = new IndividualClient();
string query = $"SELECT * FROM IndividualClients WHERE ClientID = '{id}'";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
myClient.clientID = reader.GetString(0);
myClient.Name = reader.GetString(1);
myClient.Surname = reader.GetString(2);
myClient.Phone = reader.GetString(3);
myClient.Email = reader.GetString(4);
myClient.AddressID = reader.GetString(5);
myClient.ContractID = reader.GetString(6);
}
}
else
{
MessageBox.Show("No matches found");
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show("ERROR: " + ex.Message);
}
finally
{
conn.Close();
}
return(myClient);
}
private void btnAddIC_Click(object sender, EventArgs e)
{
try
{
IndividualClientBLL clientData = new IndividualClientBLL();
IndividualClient client = new IndividualClient();
client.clientID = txtID.Text;
client.Name = txtName.Text;
client.Surname = txtSurname.Text;
client.Phone = txtPhone.Text;
client.Email = txtEmail.Text;
client.AddressID = txtAddress.Text;
client.ContractID = txtContract.Text;
clientData.InsertIndividualClient(client);
}
catch (Exception exp)
{
MessageBox.Show($"Error AddClient Form {exp.Message}");
}
}
public void AddIndividualClient(IndividualClient individualClient)
{
using (OracleConnection SQLConnect =
new OracleConnection(ConfigurationManager.ConnectionStrings["OracleConnectionString"].ConnectionString))
{
var name = new OracleParameter("IC_Name", OracleDbType.Varchar2,
individualClient.Name, ParameterDirection.Input);
var email = new OracleParameter("IC_EMail", OracleDbType.Varchar2,
individualClient.EMail, ParameterDirection.Input);
var street = new OracleParameter("IC_Street", OracleDbType.Varchar2,
individualClient.Street, ParameterDirection.Input);
var city = new OracleParameter("IC_City", OracleDbType.Varchar2,
individualClient.City, ParameterDirection.Input);
var postalCode = new OracleParameter("IC_PostalCode", OracleDbType.Varchar2,
individualClient.PostalCode, ParameterDirection.Input);
var typeid = new OracleParameter("IC_TypeID", OracleDbType.Int32,
individualClient.TypeId, ParameterDirection.Input);
var industryIds = new OracleParameter("CI_IndustryIds", OracleDbType.Int32,
individualClient.Industries, ParameterDirection.Input);
industryIds.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
industryIds.Size = individualClient.Industries.Length;
SQLConnect.Open();
var com = SQLConnect.CreateCommand();
com.CommandText = "CRM_Package.Add_IndividualClient";
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add(name);
com.Parameters.Add(email);
com.Parameters.Add(street);
com.Parameters.Add(city);
com.Parameters.Add(postalCode);
com.Parameters.Add(typeid);
com.Parameters.Add(industryIds);
com.ExecuteNonQuery();
}
}
private void btnDeleteClient_Click(object sender, EventArgs e)
{
int ID = (int)dgvIndividualClients.Rows[dgvIndividualClients.CurrentRow.Index].Cells["ClientID"].Value;
DialogResult result = MessageBox.Show("Are you sure you want to delete Client " + ID, "Delete Client", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
IndividualClient client = new IndividualClient();
client.DeleteIndividualClient(ID);
MessageBox.Show("Client " + ID + " was deleted");
}
else
{
MessageBox.Show("Client was not deleted");
}
IndividualClient client1 = new IndividualClient();
source.DataSource = client1.GetCustomTable();
dgvIndividualClients.DataSource = source;
}
