public void loadCustomers()
{//loading everything from database for load existing customers
customerCount = 0;
dbcon = new DatabaseConnector();
dbcon.OpenConnection();
customerCount = dbcon.GetData("SELECT * FROM customer ORDER BY cid ASC").Rows.Count;
//customerCount = dbcon.dataSetMain.Tables[0].Rows.Count;
custObject = new CustomerClass[customerCount]; //so now array size will depend on number of records
for (int i = 0; i < customerCount; i++) //same as loadseat method in seatclass
{
custObject[i] = new CustomerClass();
dbcon.dataRowMain = dbcon.dataSetMain.Tables[0].Rows[i];
custObject[i].Cid = Convert.ToInt32(dbcon.dataRowMain[0]);
custObject[i].Fname = Convert.ToString(dbcon.dataRowMain[1]);
custObject[i].Lname = Convert.ToString(dbcon.dataRowMain[2]);
custObject[i].Nic = Convert.ToString(dbcon.dataRowMain[3]);
custObject[i].Gender = Convert.ToChar(dbcon.dataRowMain[4].ToString());
custObject[i].Dob = Convert.ToDateTime(dbcon.dataRowMain[5].ToString());
custObject[i].Add1 = Convert.ToString(dbcon.dataRowMain[6]);
custObject[i].Add2 = Convert.ToString(dbcon.dataRowMain[7]);
custObject[i].Phone = Convert.ToString(dbcon.dataRowMain[8]);
custObject[i].Email = Convert.ToString(dbcon.dataRowMain[9]);
dbcon.CloseConnection();
}
}
//edit button
private void button4_Click(object sender, EventArgs e)
{
try
{
var controls = new[] { txtFname.Text, txtLname.Text, txtNic.Text, txtAdd1.Text, txtAdd2.Text, txtEmail.Text, txtPhn.Text };
if (!controls.All(x => string.IsNullOrEmpty(x))) //if its not null or empty do not enter the details to database
{ //Validation^^^^^^^
if (dateTimePicker1.Value < DateTime.Today) //validation for date must be in past
{
if ((Regex.IsMatch(txtFname.Text, @"^[a-zA-Z]+$")) || (Regex.IsMatch(txtLname.Text, @"^[a-zA-Z]+$")))
{
customerObject = new CustomerClass();
//customerID = comboBox1.SelectedIndex;
string cmbText = comboBox1.Text;
//im gonna use regex to extract only number(cid) from cmbtext
customerID = Convert.ToInt32(Regex.Match(cmbText, @"\d+").Value);
customerObject.Fname = txtFname.Text;
customerObject.Lname = txtLname.Text;
customerObject.Nic = txtNic.Text;
//gender
if (rbMale.Checked)
{
customerObject.Gender = Convert.ToChar(rbMale.Tag); //male
}
else
{
customerObject.Gender = Convert.ToChar(rbFemale.Tag); //female
}
customerObject.Dob = Convert.ToDateTime(dateTimePicker1.Value.ToString("yyyy-MM-dd"));
customerObject.Add1 = txtAdd1.Text;
customerObject.Add2 = txtAdd2.Text;
customerObject.Phone = txtPhn.Text;
customerObject.Email = txtEmail.Text;
//MessageBox.Show(updCust.Dob.ToString());
customerObject.updateDetails(customerID);
MessageBox.Show("Details have been successfully modified", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("date should be in past", "Invalid Date", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
MessageBox.Show("Make sure first name and last name contain only letters", "Format Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
MessageBox.Show("Please make sure that all fields are filled", "Empty Fields", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
MessageBox.Show("Exception Error occured " + ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}