private void btnDelete_Click(object sender, EventArgs e)
{
try
{
sqlAccess sqldeletecustomer = new sqlAccess();
int itemno = (int)customerDataGrid[0, customerDataGrid.CurrentCell.RowIndex].Value;
string membercard = _customerlist.Getacustomer(customerDataGrid.CurrentCell.RowIndex).MemberCard.ToString();
//delete membership
var confirmfeedback = MessageBox.Show("[Warning!] Do you want to delete customer: (No." + itemno + ") information?", "Information deleted!", MessageBoxButtons.YesNo);
if (confirmfeedback == DialogResult.Yes)
{
sqldeletecustomer.DeleteRecord(itemno);
updatathedatagrid(this, null);
}
//delete account
//1. check exists?
if (sqldeletecustomer.IsUserExist(membercard))
{
//2. delete account
confirmfeedback = MessageBox.Show("[Warning!] Do you want to delete customer account (MemberID." + membercard + ")?", "account deleted!", MessageBoxButtons.YesNo);
if (confirmfeedback == DialogResult.Yes)
{
sqldeletecustomer.DeleteAccount(membercard);
}
}
}
catch
{
MessageBox.Show("There is no data from database yet!");
}
}
private void customerDataGrid_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
//Method 1 - by qurey to sort
try
{
sqlAccess sqlcustomerlist = new sqlAccess();
_desc = (!_desc);
_customerlist = sqlcustomerlist.RetrievalCustomerList((customerDataGrid.Columns[e.ColumnIndex].DataPropertyName != null)? customerDataGrid.Columns[e.ColumnIndex].DataPropertyName : sqlAccess.CUSTOMERID, _desc);// argu sortitem, argu
customerDataGrid.DataSource = _customerlist.Getcustomerlist();
}
catch
{
MessageBox.Show("[Error] SQL access issue!");
}
//Method 2 - by
//_desc = (!_desc);
//try
//{
// customerDataGrid.Sort(customerDataGrid.Columns[1], (_desc == true) ? ListSortDirection.Descending : ListSortDirection.Ascending);
//}
//catch
//{
// MessageBox.Show("Oops, something worng!");
//}
}
private void btnSave_Click(object sender, EventArgs e)
{
//Todo: create a customer class and set up the vaild data.
if (isInformationVaild == true && textBoxMemberCard.Text != null)
{
customer.FirstName = textBoxFirstName.Text;
customer.LastName = textBoxLastName.Text;
customer.Email = textBoxEmail.Text;
customer.Website = textBoxwebsite.Text;
customer.DOB = dateTimePickerDOB.Value.ToString("yyyy-MM-dd"); // make it fit to MS SQL
customer.MemberCard = textBoxMemberCard.Text;
customer.LoyaltyMember = (checkBoxLoyaltyMember.Checked)?"true":"false";
customer.Phone = textBoxPhone.Text;
customer.Mobile = textBox1moblie.Text;
customer.Fax = textBoxFax.Text;
//2. Update
if (customer.SaveCustomer())
{
System.Windows.Forms.MessageBox.Show("Record was updated sucessful!");
CloseSave(sender, e);
// 3. Check for account, if user does not have one, ask for create one
// 3.1 check data base by membercard
try
{
sqlAccess useraccountcheck = new sqlAccess();
if (!useraccountcheck.IsUserExist(customer.MemberCard))
{
var confirmfeedback = MessageBox.Show("The member do not have a account. Do you want to create it?", "User create!", MessageBoxButtons.YesNo);
if (confirmfeedback == DialogResult.Yes)
{
CreateNewUserAccount newuseracc = new CreateNewUserAccount(customer.MemberCard);
newuseracc.Owner = this;
newuseracc.ShowDialog();
}
}
}
catch
{
MessageBox.Show("Cannot connect with sql server!");
}
this.Close();
}
else
{
System.Windows.Forms.MessageBox.Show("Record was updated failed!");
}
}
else
{
System.Windows.Forms.MessageBox.Show("There is/are some data invaild. Please check the data again!");
}
}
private void updatathedatagrid(object sender, EventArgs e)
{
try
{
sqlAccess sqlcustomerlist = new sqlAccess();
_customerlist = sqlcustomerlist.SearchRecord(sqlAccess.MEMBERCARD, _membercardnumber);
this.CustomerdataGridView.AutoGenerateColumns = false;
this.CustomerdataGridView.DataSource = _customerlist.Getcustomerlist();
}
catch
{
MessageBox.Show("[Error] SQL access issue!");
}
}
protected void updatathedatagrid(object sender, EventArgs e)
{
try
{
sqlAccess sqlcustomerlist = new sqlAccess();
_customerlist = sqlcustomerlist.RetrievalCustomerList();
this.customerDataGrid.AutoGenerateColumns = false;
customerDataGrid.DataSource = _customerlist.Getcustomerlist();
}
catch
{
MessageBox.Show("[Error] SQL access issue!");
}
}
private void searchtextBox_TextChanged(object sender, EventArgs e)
{
sqlAccess sqlfindcustomer = new sqlAccess();
try
{
_customerlist = sqlfindcustomer.SearchRecord(searchcomboBox.Text, searchtextBox.Text);
customerDataGrid.DataSource = _customerlist.Getcustomerlist();
}
catch
{
MessageBox.Show("SQL data access fail!");
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
try
{
sqlAccess sqladduseraccount = new sqlAccess();
// data check
if (textBoxuser.Text.Length > 4 && textBoxuser.Text.Length <= 20)
{
_username = textBoxuser.Text;
}
else
{
MessageBox.Show("User name include at least 5 char!");
}
if (textBoxpassword.Text.Length > 4 && textBoxpassword.Text.Length <= 20)
{
_userpassword = textBoxpassword.Text;
}
else
{
MessageBox.Show("User password include at least 5 char!");
}
if (_username != null && _userpassword != null)
{
if (sqladduseraccount.CreateUserAccount(_username, _userpassword, _authority, _membercard))
{
MessageBox.Show("User account has been created!");
this.Close();
}
else
{
MessageBox.Show("User account was created fail!");
}
}
}
catch
{
MessageBox.Show("??");
}
}
private void buttonOK_Click(object sender, EventArgs e)
{
// create sql access class and check login data
try
{
sqlAccess sqllogin = new sqlAccess();
string result = sqllogin.LoginCheck(textBox1.Text, textBox2.Text);
// two models for login
if (result.CompareTo("2") == 0)
{
AdministratorInterface administrator = new AdministratorInterface();
administrator.Owner = this;
administrator.Show();
textBox1.Clear();
textBox2.Clear();
Hide();
}
else if (result.Substring(0, 1).CompareTo("1") == 0)
{
CustomerInterface customer = new CustomerInterface(result.Substring(2, (result.Length - 2)));
customer.Owner = this;
customer.Show();
textBox1.Clear();
textBox2.Clear();
Hide();
}
else
{
System.Windows.Forms.MessageBox.Show("Invaild account! Please try again.");
}
}
catch
{
System.Windows.Forms.MessageBox.Show("Sql access error!");
}
}
