/// Manipulation of the information held within the list.
public void LoadCustomerList()
{
Database db = new BWDatabase.Database();
{
foreach (var Row in db.GetCustomerList())
{
var Fields = Row as IDictionary <string, object>;
FName = Fields["FullName"].ToString();
this.lstCustomers.Items.Add(FName);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (lstCustomers.SelectedIndex < 0)
{
MessageBox.Show("No Selection.");
}
else
{
Database db = new BWDatabase.Database();
CustNumber = Int32.Parse(txtCustNumber.Text);
db.DeleteEntry(CustNumber, txtFullName.Text);
ClearCustomerList();
ClearCustomerValues();
LoadCustomerList();
}
}
public void SaveNewEntry(int CustNum)
{
gTitle = txtTitle.Text;
gFullName = txtFullName.Text;
gTelephone = txtTelephone.Text;
gAddTelephone = txtAddTelephone.Text;
gMobile = txtMobile.Text;
gEmail = txtEmail.Text;
gFullAddress = txtFullAddress.Text;
gPostCode = txtPostcode.Text;
gArea = txtArea.Text;
gFacebook = txtFacebookName.Text;
gLanguage = txtLanguage.Text;
gNotes = txtNotes.Text;
Database db = new BWDatabase.Database();
db.SaveEntry(CustNum, gTitle, gFullName, gTelephone, gAddTelephone, gMobile, gEmail,
gFullAddress, gPostCode, gArea, gFacebook, gLanguage, gNotes);
}
public void LoadCustomerValues()
{
Database db = new BWDatabase.Database();
{
string getValue = lstCustomers.SelectedItem.ToString();
foreach (var Row in db.GetCustomerDetails(getValue))
{
var Fields = Row as IDictionary <string, object>;
txtCustNumber.Text = Fields["CustomerNumber"].ToString();
txtTitle.Text = Fields["Title"].ToString();
txtFullName.Text = Fields["FullName"].ToString();
txtTelephone.Text = Fields["Telephone"].ToString();
txtAddTelephone.Text = Fields["AddTelephone"].ToString();
txtMobile.Text = Fields["Mobile"].ToString();
txtEmail.Text = Fields["Email"].ToString();
txtFullAddress.Text = Fields["FullAddress"].ToString();
txtPostcode.Text = Fields["Postcode"].ToString();
txtArea.Text = Fields["Area"].ToString();
txtFacebookName.Text = Fields["Facebook"].ToString();
txtLanguage.Text = Fields["Language"].ToString();
txtNotes.Text = Fields["Notes"].ToString();
}
}
if (txtTelephone.Text == "0")
{
txtTelephone.Text = "";
}
if (txtAddTelephone.Text == "0")
{
txtAddTelephone.Text = "";
}
if (txtMobile.Text == "0")
{
txtMobile.Text = "";
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
switch (btnCreate.Text)
{
case CreateNew:
{
btnCreate.Text = Save;
btnEdit.Enabled = false;
btnDelete.Enabled = false;
btnAllCancel.Visible = true;
lstCustomers.Enabled = false;
AddDefaultClearValues();
ClearCustomerValues();
Database db = new BWDatabase.Database();
int x = 1;
foreach (var Row in db.GetCustomerNumber())
{
var Fields = Row as IDictionary <string, object>;
string objNumber = Fields["CustomerNumber"].ToString();
CustomerNumber = Int32.Parse(objNumber);
if (x != CustomerNumber)
{
CustomerNumber = x;
break;
}
else
{
x = x + 1;
CustomerNumber = x;
}
}
txtCustNumber.Text = CustomerNumber.ToString();
LockOrUnlockFields(true);
break;
}
case Save:
{
if (ValidateNameFields())
{
if (ValidateContactFields())
{
SaveNewEntry(CustomerNumber);
ClearCustomerList();
LoadCustomerList();
lstCustomers.Enabled = true;
btnCreate.Text = CreateNew;
btnEdit.Enabled = true;
btnDelete.Enabled = true;
btnAllCancel.Visible = false;
LockOrUnlockFields(false);
string Identifier = gFullName;
lstCustomers.SelectedIndex = FindIndex(Identifier);
System.Threading.Thread.Sleep(100);
break;
}
else
{
var ErrorResult = ($"Please validate the numbers in the contact fields.");
var Caption = "Contact Field Error.";
MessageBox.Show(ErrorResult, Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
}
}
else
{
var ErrorResult = ($"The Name field must be filled.");
var Caption = "Name Required.";
MessageBox.Show(ErrorResult, Caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
//Do Nothing
}
}
default:
{
break;
}
}
}
