private bool ValidateForm()
{
if (!Regex.Match(FirstNameTextBox.Text, @"^\D{1,30}$").Success)
{
MessageBox.Show("First name must consist of at least 1 character and not exceed 30 characters!");
FirstNameTextBox.Focus();
return(false);
}
if (!Regex.Match(LastNameTextBox.Text, @"^\D{1,30}$").Success)
{
MessageBox.Show("Last name must consist of at least 1 character and not exceed 30 characters!");
LastNameTextBox.Focus();
return(false);
}
if (!Regex.Match(AddressTextBox.Text, @"^(Вул\.\s\D{1,40}\,\s\d{1,3})$").Success)
{
MessageBox.Show("Address must consist of at least 1 character and not exceed 50 characters!");
AddressTextBox.Focus();
return(false);
}
if (!Regex.Match(PhoneNumberTextBox.Text, @"^\d{10}$").Success)
{
MessageBox.Show("Phone number must consist of 10 digits!");
PhoneNumberTextBox.Focus();
return(false);
}
return(true);
}
private bool ValidateForm()
{
if (!Regex.Match(TitleTextBox.Text, @"^\D{1,50}$").Success)
{
MessageBox.Show("Title must consist of at least 1 character and not exceed 50 characters!");
TitleTextBox.Focus();
return(false);
}
if (!Regex.Match(ContactTextBox.Text, @"^\D{1,50}$").Success)
{
MessageBox.Show("Contact person must consist of at least 1 character and not exceed 50 characters!");
ContactTextBox.Focus();
return(false);
}
if (!Regex.Match(PhoneTextBox.Text, @"^\d{10}$").Success)
{
MessageBox.Show("Phone number must consist of 10 digits!");
PhoneTextBox.Focus();
return(false);
}
if (!Regex.Match(AddressTextBox.Text, @"^(Вул\.\s\D{1,40}\,\s\d{1,3})$").Success)
{
MessageBox.Show("Address must consist of at least 1 character and not exceed 50 characters!");
AddressTextBox.Focus();
return(false);
}
return(true);
}
private void UpdateButton_Click(object sender, RoutedEventArgs e)
{
if (NameBox.Text == "" || BloodgroupBox.Text == "" || AddressBox.Text == "" ||
PhonenumberBox.Text == "" || CurrentcityBox.Text == "")
{
MessageBox.Show("Please fill up all the fields", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
NameTextBox.Focus();
}
if (!Regex.Match(NameBox.Text,
@"^([A-Z][a-z]+||[A-Z][a-z]+\s[A-Z][a-z]+||[A-Z][a-z]+\s[A-Z][a-z]+\s[A-Z][a-z]+)$").Success)
{
MessageBox.Show("Invalid Name", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
BloodgroupBox.Focus();
PhonenumberTextBox.Focus();
}
else if (!Regex.Match(PhonenumberBox.Text, @"^\d{10}||\d{11}$").Success)
{
MessageBox.Show("Invalid Phone Number", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
AddressTextBox.Focus();
}
else if (
!Regex.Match(AddressBox.Text,
@"^([A-Z][a-z]+||\d{3}-[A-Z][a-z]+||[A-Z][a-z]+\s[A-Z][a-z]+,[A-Z][a-z]+,[A-Z][a-z]+)$").Success)
{
MessageBox.Show("Invalid Address", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
CurrentcityTextBox.Focus();
}
else if (!Regex.Match(CurrentcityBox.Text, @"^[A-Z][a-z]+$").Success)
{
MessageBox.Show("Invalid Current City Name", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
}
else if (Activate())
{
Conn = DatabaseConnection.GetConnection();
if (Conn.State.ToString() == "Closed")
{
Conn.Open();
}
string query =
string.Format("update information set Name='" + NameBox.Text + "',Bloodgroup='" +
BloodgroupBox.SelectionBoxItem + "',Phonenumber='" + PhonenumberBox.Text +
"',Address='" + AddressBox.Text + "', Currentcity='" + CurrentcityBox.Text +
"' wehre Id='" + IdComboBox.SelectionBoxItem + "'");
var cmd = new SqlCommand(query, Conn);
cmd.ExecuteNonQuery();
MessageBox.Show("Data is Updated!!");
Conn.Close();
}
}
private void SaveButton_Click(object sender, RoutedEventArgs e)
{
if (Name1TextBox.Text == "" || BloodgroupComboBox.Text == "" || AddressTextBox.Text == "" ||
PhonenumberTextBox.Text == "" || CurrentcityTextBox.Text == "")
{
MessageBox.Show("Please fill up all the fields", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
NameTextBox.Focus();
}
else if (!Regex.Match(Name1TextBox.Text,
@"^([A-Z][a-z]+||[A-Z][a-z]+\s[A-Z][a-z]+||[A-Z][a-z]+\s[A-Z][a-z]+\s[A-Z][a-z]+)$").Success)
{
MessageBox.Show("Invalid Name", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
BloodgroupBox.Focus();
PhonenumberTextBox.Focus();
}
else if (!Regex.Match(PhonenumberTextBox.Text, @"^\d{10}||\d{11}$").Success)
{
MessageBox.Show("Invalid Phone Number", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
AddressTextBox.Focus();
}
else if (
!Regex.Match(AddressTextBox.Text,
@"^([A-Z][a-z]+||\d{3}-[A-Z][a-z]+\s[A-Z][a-z]+,[A-Z][a-z]+,[A-Z][a-z]+)$").Success)
{
MessageBox.Show("Invalid Address", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
CurrentcityTextBox.Focus();
}
else if (!Regex.Match(CurrentcityTextBox.Text, @"^[A-Z][a-z]+$").Success)
{
MessageBox.Show("Invalid Current City Name", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
}
else if (Activate())
{
Conn = DatabaseConnection.GetConnection();
if (Conn.State.ToString() == "Closed")
{
Conn.Open();
}
string query = string.Format("insert into information values('{0}','{1}','{2}','{3}','{4}','{5}')",
IdTextBox.Text, Name1TextBox.Text, BloodgroupComboBox.SelectionBoxItem, PhonenumberTextBox.Text,
AddressTextBox.Text, CurrentcityTextBox.Text);
var cmd = new SqlCommand(query, Conn);
cmd.ExecuteNonQuery();
MessageBox.Show("Data is Inserted!!");
Conn.Close();
}
}
private bool UpdateClient()
{
try
{
InvoicerDataSetTableAdapters.ClientTableAdapter objClient = new InvoicerDataSetTableAdapters.ClientTableAdapter();
if (this.NameTextBox.Text == "")
{
MessageBox.Show("Please enter Customer Name");
NameTextBox.Focus();
return(false);
}
else if (AddressTextBox.Text == "")
{
MessageBox.Show("Please enter Customer Address");
AddressTextBox.Focus();
return(false);
}
else if (CityTextBox.Text == "")
{
MessageBox.Show("Please enter Customer City");
CityTextBox.Focus();
return(false);
}
string ClientName = this.NameTextBox.Text != "" ? NameTextBox.Text : null;
string Address = this.AddressTextBox.Text != "" ? AddressTextBox.Text : null;
string City = this.CityTextBox.Text != "" ? CityTextBox.Text : null;
string State = this.StateTextBox.Text != "" ? StateTextBox.Text : null;
string Zip = this.ZipTextBox.Text != "" ? ZipTextBox.Text : null;
string TINNO = this.txtTINNo.Text != "" ? txtTINNo.Text : null;
//string OrderNo = this.txtRefNo.Text != "" ? txtRefNo.Text : null;
string DCNO = this.txtDCNo.Text != "" ? txtDCNo.Text : null;
string VendorCode = this.txtVendorCode.Text != "" ? txtVendorCode.Text : null;
string GSTIN = this.txtGSTIN.Text != "" ? this.txtGSTIN.Text : null;
string StateCode = this.txtStateCode.Text != "" ? this.txtStateCode.Text : null;
if (txtClientID.Text == "")
{
objClient.Insert(ClientName, Address, City, State, Zip, DCNO, VendorCode, TINNO, GSTIN, StateCode);
}
else
{
objClient.UpdateClient(ClientName, Address, City, State, Zip, DCNO, VendorCode, TINNO, GSTIN, StateCode, Convert.ToInt32(txtClientID.Text.ToString()));
}
return(true);
}
catch (Exception excLocal)
{
throw excLocal;
}
}
private void FocusFirstEmptyLoginCredential()
{
if (Address == string.Empty)
{
AddressTextBox.Focus();
}
else if (Port == string.Empty)
{
PortTextBox.Focus();
}
else if (Username == string.Empty)
{
UsernameTextBox.Focus();
}
else
{
PasswordBox.Focus();
}
}
private bool ValidateForm()
{
if (!Regex.Match(FirstNameTextBox.Text, @"^\D{1,30}$").Success)
{
MessageBox.Show("First name must consist of at least 1 character and not exceed 30 characters!");
FirstNameTextBox.Focus();
return(false);
}
if (!Regex.Match(LastNameTextBox.Text, @"^\D{1,30}$").Success)
{
MessageBox.Show("Last name must consist of at least 1 character and not exceed 30 characters!");
LastNameTextBox.Focus();
return(false);
}
if (!Regex.Match(PhoneNumberTextBox.Text, @"^\d{10}$").Success)
{
MessageBox.Show("Phone number must consist of 10 digits!");
PhoneNumberTextBox.Focus();
return(false);
}
if (!Regex.Match(ExperienceTextBox.Text, @"^[0-9]+$").Success)
{
MessageBox.Show("Invalid work experience number! It must contain only digits");
ExperienceTextBox.Focus();
return(false);
}
if (!Regex.Match(AddressTextBox.Text, @"^(Вул\.\s\D{1,40}\,\s\d{1,3})$").Success)
{
MessageBox.Show("Address must consist of at least 1 character and not exceed 50 characters!");
AddressTextBox.Focus();
return(false);
}
if (RoleComboBox.SelectedItem == null)
{
MessageBox.Show("Please select role");
return(false);
}
if (MarketComboBox.SelectedItem == null)
{
MessageBox.Show("Please select market");
return(false);
}
if (CityComboBox.SelectedItem == null)
{
MessageBox.Show("Please select city");
return(false);
}
if (!Regex.Match(LoginTextBox.Text, @"^\D{6,20}$").Success)
{
MessageBox.Show("Login must consist of at least 6 character and not exceed 20 characters!");
LoginTextBox.Focus();
return(false);
}
if (!Regex.Match(PasswordTextBox.Text, @"^\D{6,20}$").Success)
{
MessageBox.Show("Login must consist of at least 6 character and not exceed 20 characters!");
PasswordTextBox.Focus();
return(false);
}
return(true);
}
private bool IsFormValidate()
{
if (FullNameTextBox.Text.Trim() == "")
{
MessageBox.Show("Full Name is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
FullNameTextBox.Clear();
FullNameTextBox.Focus();
return(false);
}
if (FatherNameTextBox.Text.Trim() == "")
{
MessageBox.Show("Father Name is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
FatherNameTextBox.Clear();
FatherNameTextBox.Focus();
return(false);
}
if (MotherNameTextBox.Text.Trim() == "")
{
MessageBox.Show("Mother Name is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
MotherNameTextBox.Clear();
MotherNameTextBox.Focus();
return(false);
}
if (AddressTextBox.Text.Trim() == "")
{
MessageBox.Show("Address is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
AddressTextBox.Clear();
AddressTextBox.Focus();
return(false);
}
if (EmailTextBox.Text.Trim() == "")
{
MessageBox.Show("Email Name is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
EmailTextBox.Clear();
EmailTextBox.Focus();
return(false);
}
if (MobileTextBox.Text.Trim() == "")
{
MessageBox.Show("Mobile number is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
MobileTextBox.Clear();
MobileTextBox.Focus();
return(false);
}
if (BloodGroupTextBox.Text.Trim() == "")
{
MessageBox.Show("Blood Group is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
BloodGroupTextBox.Clear();
BloodGroupTextBox.Focus();
return(false);
}
if (GenderComboBox.SelectedIndex == -1)
{
MessageBox.Show("Gender is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
if (BranchComboBox.SelectedIndex == -1)
{
MessageBox.Show("Branch is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
return(true);
}
public FtpDialog()
{
InitializeComponent();
AddressTextBox.Focus();
}
// save button clicked
private void SaveButton_Click(object sender, EventArgs e)
{
if (FirstNameTextBox.Text == "" || FirstNameTextBox.ForeColor == Color.Red)
{
MessageBox.Show("Make sure you filled out <First Name> field and entered only letters (a-z, A-Z)", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error);
FirstNameTextBox.Focus();
}
else if (LastNameTextBox.Text == "" || LastNameTextBox.ForeColor == Color.Red)
{
MessageBox.Show("Make sure you filled out <Last Name> field and entered only letters (a-z, A-Z)", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error);
LastNameTextBox.Focus();
}
else if (PhoneTextBox.Text == "" || PhoneTextBox.ForeColor == Color.Red)
{
MessageBox.Show("Make sure you filled out <Phone Number> field and input is in correct format (XXXXXXXXXX or XXX XXX XXXX or XXX-XXX-XXXX)", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error);
PhoneTextBox.Focus();
}
else if (EmailTextBox.Text == "" || EmailTextBox.ForeColor == Color.Red)
{
MessageBox.Show("Make sure you filled out <Email> field and provided valid Email", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error);
EmailTextBox.Focus();
}
else if (CityTextBox.Text == "" || CityTextBox.ForeColor == Color.Red)
{
MessageBox.Show("Make sure you filled out <City> field and provided valid input", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error);
CityTextBox.Focus();
}
else if (StateTextBox.Text == "" || StateTextBox.ForeColor == Color.Red)
{
MessageBox.Show("Make sure you filled out <State> field and provided valid input", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error);
StateTextBox.Focus();
}
else if (ZipTextBox.Text == "" || ZipTextBox.ForeColor == Color.Red)
{
MessageBox.Show("Make sure you filled out <Zip> field and input is in valid format (XXXXX)", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error);
ZipTextBox.Focus();
}
else if (AddressTextBox.Text == "" || AddressTextBox.ForeColor == Color.Red)
{
MessageBox.Show("Make sure you filled out <Address> field and provided valid input", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error);
AddressTextBox.Focus();
}
else
{
string cmdText = "select count(*) from Customers where FirstName = @firstName and LastName = @lastName and Email = @email and Phone = @phone and Address = @address and City = @city and State = @state and Zip = @zip";
scmd = new SqlCommand(cmdText, connection);
connection.Open();
scmd.Parameters.AddWithValue("@firstName", FirstNameTextBox.Text);
scmd.Parameters.AddWithValue("@lastName", LastNameTextBox.Text);
scmd.Parameters.AddWithValue("@email", EmailTextBox.Text);
scmd.Parameters.AddWithValue("@phone", PhoneTextBox.Text);
scmd.Parameters.AddWithValue("@address", AddressTextBox.Text);
scmd.Parameters.AddWithValue("@city", CityTextBox.Text);
scmd.Parameters.AddWithValue("@state", StateTextBox.Text);
scmd.Parameters.AddWithValue("@zip", ZipTextBox.Text);
int exists = (int)scmd.ExecuteScalar(); // check if entered isnb is unique
connection.Close();
// if user clicks new customer button, add new customer mode is on
if (addNewCustomerMode)
{
if (exists > 0)
{
MessageBox.Show("Customer Already Exists", "Addition of existing Customer", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DialogResult save = MessageBox.Show("Do you want to save the Customer?", "Add New Customer", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (save == DialogResult.Yes)
{
scmd = new SqlCommand("SET IDENTITY_INSERT Customers OFF; insert into Customers(FirstName, LastName, Email, Phone, Address, City, State, Zip) Values(@firstName, @lastName, @email, @phone, @address, @city, @state, @zip)", connection);
connection.Open();
scmd.Parameters.AddWithValue("@firstName", FirstNameTextBox.Text);
scmd.Parameters.AddWithValue("@lastName", LastNameTextBox.Text);
scmd.Parameters.AddWithValue("@email", EmailTextBox.Text);
scmd.Parameters.AddWithValue("@phone", PhoneTextBox.Text);
scmd.Parameters.AddWithValue("@address", AddressTextBox.Text);
scmd.Parameters.AddWithValue("@state", CityTextBox.Text);
scmd.Parameters.AddWithValue("@city", CityTextBox.Text);
scmd.Parameters.AddWithValue("@zip", ZipTextBox.Text);
scmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show("The Customer Was Added Successfully.");
DisplayCustomers(); // refresh combobox values
ResetAll();
CustomerComboBox.Enabled = true;
}
}
}
// if user chooses customer from combobox, update customer mode is on
if (updateCustomerMode)
{
if (exists > 0)
{
MessageBox.Show("You haven't modified anything.", "Nothing to update", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DialogResult save = MessageBox.Show("Do you want to update the Customer?", "Update Existing Customer", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (save == DialogResult.Yes)
{
cmdText = "update Customers set FirstName = @firstName, LastName = @lastName, Email = @email, Phone = @phone, Address = @address, City = @city, State = @state, Zip = @zip where ID = @customerID";
scmd = new SqlCommand(cmdText, connection);
connection.Open();
scmd.Parameters.AddWithValue("@customerID", customerID);
scmd.Parameters.AddWithValue("@firstName", FirstNameTextBox.Text);
scmd.Parameters.AddWithValue("@lastName", LastNameTextBox.Text);
scmd.Parameters.AddWithValue("@email", EmailTextBox.Text);
scmd.Parameters.AddWithValue("@phone", PhoneTextBox.Text);
scmd.Parameters.AddWithValue("@address", AddressTextBox.Text);
scmd.Parameters.AddWithValue("@city", CityTextBox.Text);
scmd.Parameters.AddWithValue("@state", StateTextBox.Text);
scmd.Parameters.AddWithValue("@zip", ZipTextBox.Text);
scmd.ExecuteNonQuery();
connection.Close();
MessageBox.Show("The Customer Was Updated Successfully.");
DisplayCustomers(); // refresh combobox values
ResetAll();
}
}
}
}
}
private void ShowError(object sender, ErrorEvent e)
{
MessageBox.Show(e.Value, "Błąd", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
AddressTextBox.Focus();
}
