private void backbtn_Click(object sender, EventArgs e)
{
b_home b = new b_home();
b.Show();
this.Hide();
}
private void btnAdd_Click(object sender, EventArgs e)
{
this.buyerId = Functions.getNextID("CustomerId", "Customer", "CUS");
this.buyerName = customerName.Text;
this.buyerContact = customerContact.Text;
this.buyerEmail = customerEmail.Text;
string secondaryAddress = "";
if (customerAddress2.Text != "" || !string.IsNullOrEmpty(customerAddress2.Text) || !string.IsNullOrWhiteSpace(customerAddress2.Text))
{
secondaryAddress += ", " + customerAddress2.Text;
}
if (customerAddress3.Text != "" || !string.IsNullOrEmpty(customerAddress3.Text) || !string.IsNullOrWhiteSpace(customerAddress3.Text))
{
secondaryAddress += ", " + customerAddress3.Text;
}
if (customerAddress4.Text != "" || !string.IsNullOrEmpty(customerAddress4.Text) || !string.IsNullOrWhiteSpace(customerAddress4.Text))
{
secondaryAddress += ", " + customerAddress4.Text;
}
this.buyerAddress = customerAddress1.Text + secondaryAddress + ".";
if (
!string.IsNullOrEmpty(this.buyerId) &&
(customerName.Text != "" || !string.IsNullOrEmpty(this.buyerName) || !string.IsNullOrWhiteSpace(this.buyerName)) &&
(!string.IsNullOrEmpty(this.buyerAddress) || !string.IsNullOrWhiteSpace(this.buyerAddress)) &&
(!string.IsNullOrEmpty(this.buyerContact) || customerContact.Text == "" || !string.IsNullOrWhiteSpace(this.buyerContact))
&& Functions.isText(this.buyerName) &&
Functions.isValid(this.buyerEmail) &&
Functions.isContact(this.buyerContact)
)
{
string query_ = "INSERT into Customer values ('" + buyerId + "','" + buyerName + "','" + buyerAddress + "','" + buyerContact + "','" + buyerEmail + "')";
Functions.ExecuteQuery(query_);
Functions.ClearAllText(this);
this.Close();
b_home bh = new b_home();
bh.Show();
}
else
{
MessageBox.Show("Please fill correct information before saving");
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
this.buyerId = Functions.getNextID("CustomerId", "Customer", "CUS");
this.buyerName = customerName.Text;
this.buyerContact = customerContact.Text;
this.buyerEmail = customerEmail.Text;
string secondaryAddress = "";
if (customerAddress2.Text != "" || !string.IsNullOrEmpty(customerAddress2.Text) || !string.IsNullOrWhiteSpace(customerAddress2.Text))
{
secondaryAddress += ", " + customerAddress2.Text;
}
if (customerAddress3.Text != "" || !string.IsNullOrEmpty(customerAddress3.Text) || !string.IsNullOrWhiteSpace(customerAddress3.Text))
{
secondaryAddress += ", " + customerAddress3.Text;
}
if (customerAddress4.Text != "" || !string.IsNullOrEmpty(customerAddress4.Text) || !string.IsNullOrWhiteSpace(customerAddress4.Text))
{
secondaryAddress += ", " + customerAddress4.Text;
}
this.buyerAddress = customerAddress1.Text + secondaryAddress + ".";
if (this.buyerName != "")
{
if (Functions.isName(this.buyerName))
{
this.checker = true;
}
else
{
this.checker = false;
}
}
if (this.buyerAddress != ".")
{
this.checker = true;
}
else
{
this.checker = false;
}
if (this.buyerContact != "")
{
if (Functions.isContact(this.buyerContact))
{
this.checker = true;
}
}
else
{
this.checker = false;
}
if ((this.buyerName != "" && Functions.isName(this.buyerName)) && (this.buyerAddress != ".") && ((this.buyerContact != "") && (Functions.isContact(this.buyerContact))))
{
if (this.buyerEmail != "")
{
if (Functions.EmailIsValid(this.buyerEmail))
{
string mailYesQuery = "INSERT into Customer values ('" + buyerId + "','" + buyerName + "','" + buyerAddress + "','" + buyerContact + "','" + buyerEmail + "')";
Functions.ExecuteQuery(mailYesQuery);
Functions.ClearAllText(this);
this.Close();
b_home bh1 = new b_home();
bh1.Show();
}
else
{
MessageBox.Show("Please recheck your Email address");
}
}
else if (this.buyerEmail == "" || this.buyerEmail == null)
{
try
{
string query_ = "INSERT into Customer (CustomerId, CustomerName, Address, Contact) values ('" + buyerId + "','" + buyerName + "','" + buyerAddress + "','" + buyerContact + "')";
Functions.ExecuteQuery(query_);
Functions.ClearAllText(this);
this.Close();
b_home bh = new b_home();
bh.Show();
}
catch (Exception ex)
{
MessageBox.Show("Some Error");
}
}
}
else
{
MessageBox.Show("Please recheck your entry!");
}
}
