void OnButtonRemoveSelfClick(object sender, EventArgs e)
{
var tableLayout = Parent as TableLayout;
Debug.Assert(tableLayout != null, "tableLayout != null");
var tableLayoutRows = tableLayout.Rows;
if (tableLayoutRows.Count == 2)
{
Clear();
TextBoxAddress.Focus();
return;
}
for (var i = tableLayoutRows.Count - 2; i >= 0; i--)
{
if (tableLayoutRows[i].Cells[0].Control == this)
{
tableLayout.Remove(this);
tableLayoutRows.RemoveAt(i);
return;
}
}
}
private void ButtonCostumerAdd_Click(object sender, EventArgs e)
{
try
{
if (TextBoxCompanyName.Text != "")
{
CostumerBO objCostumerBO = new CostumerBO();
objCostumerBO.CostumerName = TextBoxCompanyName.Text;
objCostumerBO.CostumerAddress = TextBoxAddress.Text;
objCostumerBO.CostumerPhone = TextBoxTelephone.Text;
CostumerBL objCostumerBL = new CostumerBL();
objCostumerBL.AddCostumerBL(objCostumerBO);
MessageBox.Show("Müşteri başarı ile eklenmiştir");
}
else
{
MessageBox.Show("Lütfen müşteri adı giriniz");
}
TextBoxCompanyName.Clear();
TextBoxAddress.Clear();
TextBoxTelephone.Clear();
PopulateGridViewCostumers();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Helper methods to display information in the Results textbox.
/// </summary>
private void ResultsClear()
{
TextBoxResults.Clear();
TextBoxLeadID.Clear();
TextBoxCapturedBy.Clear();
TextBoxCapturedDate.Clear();
TextBoxRegID.Clear();
TextBoxFirstName.Clear();
TextBoxLastName.Clear();
TextBoxTitle.Clear();
TextBoxCompany.Clear();
TextBoxCompany2.Clear();
TextBoxAddress.Clear();
TextBoxAddress2.Clear();
TextBoxAddress3.Clear();
TextBoxCity.Clear();
TextBoxStateCode.Clear();
TextBoxZipCode.Clear();
TextBoxCountryCode.Clear();
TextBoxEmail.Clear();
TextBoxPhone.Clear();
TextBoxPhoneExt.Clear();
TextBoxFax.Clear();
TextBoxNotes.Clear();
dgvDemographics.DataSource = null;
}
private void BtnCancel_Click(object sender, RoutedEventArgs e)
{
TextBoxName.Clear();
TextBoxFamily.Clear();
TextBoxThirdName.Clear();
TextBoxAddress.Clear();
TextBoxNumber.Clear();
}
private void metroTileEnter_Click(object sender, EventArgs e)
{
SimsOracle db = new SimsOracle();
int rows = 0;
if (TextBoxName.Text == "")
{
MessageBox.Show("You should enter centre name");
TextBoxName.Focus();
}
else if (TextBoxAddress.Text == "")
{
MessageBox.Show("You should enter centre address");
TextBoxAddress.Focus();
}
else if (TextBoxClasses.Text == "")
{
MessageBox.Show("You should enter number of classes");
TextBoxClasses.Focus();
}
else if (!checkValue.isValidInteger(TextBoxClasses.Text))
{
MessageBox.Show("The number format is not valid");
TextBoxClasses.Focus();
}
else
{
try
{
string sql = "INSERT INTO CENTRE " +
"(NAME, ADDRESS, CLASSES) " +
" VALUES " +
"(:NAME, :ADDRESS, :CLASSES)";
OracleCommand cmd = new OracleCommand(sql, db.Connection);
cmd.Parameters.Add("NAME", TextBoxName.Text);
cmd.Parameters.Add("ADDRESS", TextBoxAddress.Text);
cmd.Parameters.Add("CLASSES", TextBoxClasses.Text);
rows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Error adding a centre:\n" + ex.Message.ToString());
}
if (rows > 0)
{
MessageBox.Show("Centre added successfully");
ClearControls();
}
else
{
MessageBox.Show("Centre was not added, there might have been unexpected error");
}
}
}
internal void ClearControls()
{
TextBoxFirstName.Clear();
TextBoxLastName.Clear();
TextBoxCitizenID.Clear();
TextBoxContact.Clear();
DateTimeHireStaff.ResetText();
TextBoxAddress.Clear();
TextBoxCity.Clear();
TextBoxZipCode.Clear();
TextBoxEmail.Clear();
}
private void ButtonOK_Click(object sender, System.EventArgs e)
{
TextBoxName.Text = TextBoxName.Text.Trim();
TextBoxAddress.Text = TextBoxAddress.Text.Trim();
if (TextBoxAddress.Text.Length == 0)
{
MessageBox.Show(this, "Please input a valid email address!");
TextBoxAddress.Focus();
return;
}
ButtonOK.DialogResult = DialogResult.OK;
this.DialogResult = DialogResult.OK;
this.Close();
}
private bool IsValidData()
{
if (ButtonRegister.Text == "Update")
{
if (string.IsNullOrEmpty(TextBoxSupId.Text))
{
Globals.MessageBoxShow(this, "Please Choose a Customer to Edit");
TextBoxSupId.Focus();
return(false);
}
}
if (string.IsNullOrEmpty(TextBoxSupName.Text))
{
Globals.MessageBoxShow(this, "Please Enter Customer Name");
TextBoxSupName.Focus();
return(false);
}
if (string.IsNullOrEmpty(TextBoxZipCode.Text))
{
Globals.MessageBoxShow(this, "Please Enter Zip Code");
TextBoxZipCode.Focus();
return(false);
}
else
{
string zipCodePattern = @"[0-9]{6}";
bool isZipValid = true;
isZipValid = Regex.IsMatch(TextBoxZipCode.Text, zipCodePattern);
if (!isZipValid)
{
Globals.MessageBoxShow(this, "Please Enter Valid Zip Code");
TextBoxZipCode.Focus();
return(false);
}
}
if (string.IsNullOrEmpty(TextBoxSupPhno.Text))
{
Globals.MessageBoxShow(this, "Please Enter Phone Number");
TextBoxSupPhno.Focus();
return(false);
}
else
{
string phnoPattern = @"[0-9]{10}";
bool isphnoValid = true;
isphnoValid = Regex.IsMatch(TextBoxSupPhno.Text, phnoPattern);
if (!isphnoValid)
{
Globals.MessageBoxShow(this, "Please Enter Valid Phone Number");
TextBoxSupPhno.Focus();
return(false);
}
}
if (string.IsNullOrEmpty(TextBoxEmail.Text))
{
Globals.MessageBoxShow(this, "Please Enter Email");
TextBoxEmail.Focus();
return(false);
}
else
{
string emailPattern = @"^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$";
bool isemailValid = true;
isemailValid = Regex.IsMatch(TextBoxEmail.Text, emailPattern);
if (!isemailValid)
{
Globals.MessageBoxShow(this, "Please Enter Valid Email");
TextBoxEmail.Focus();
return(false);
}
}
if (string.IsNullOrEmpty(TextBoxGSTNo.Text))
{
Globals.MessageBoxShow(this, "Please Enter GST No");
TextBoxGSTNo.Focus();
return(false);
}
else
{
string gstPattern = @"^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}Z[0-9A-Z]{1}$";
bool isgstValid = true;
isgstValid = Regex.IsMatch(TextBoxGSTNo.Text, gstPattern);
if (!isgstValid)
{
Globals.MessageBoxShow(this, "Please Enter Valid GST No");
TextBoxGSTNo.Focus();
return(false);
}
}
if (string.IsNullOrEmpty(TextBoxState.Text))
{
Globals.MessageBoxShow(this, "Please Enter State");
TextBoxState.Focus();
return(false);
}
if (string.IsNullOrEmpty(TextBoxCity.Text))
{
Globals.MessageBoxShow(this, "Please Enter City");
TextBoxCity.Focus();
return(false);
}
if (string.IsNullOrEmpty(TextBoxAddress.Text))
{
Globals.MessageBoxShow(this, "Please Enter Address");
TextBoxAddress.Focus();
return(false);
}
if (DropDownListCountry.SelectedItem.Text == "Select Country")
{
Globals.MessageBoxShow(this, "Please Select Country");
DropDownListCountry.Focus();
return(false);
}
if (DropDownListGender.SelectedItem.Text == "Gender")
{
Globals.MessageBoxShow(this, "Please Select Gender");
DropDownListGender.Focus();
return(false);
}
return(true);
}
private void ToolsStatus()
{
if (_TypeOperation == ClassPublicVar.TypeOperation.Show)
{
TextBoxMainID.ReadOnly = true;
TextBoxMainName.ReadOnly = true;
TextBoxID.ReadOnly = true;
TextBoxGroupID.ReadOnly = true;
TextBoxGroupName.ReadOnly = true;
TextBoxNameLng1.ReadOnly = true;
TextBoxNameLng2.ReadOnly = true;
TextBoxPhone.ReadOnly = true;
TextBoxeFax.ReadOnly = true;
TextBoxAddress.ReadOnly = true;
TextBoxRentStartDate.ReadOnly = true;
TextBoxRentEndDate.ReadOnly = true;
TextBoxCrNO.ReadOnly = true;
TextBoxCrLssDate.ReadOnly = true;
TextBoxCrExpDate.ReadOnly = true;
TextBoxMunicp.ReadOnly = true;
TextBoxMunicpLssDate.ReadOnly = true;
TextBoxMunicpExpDate.ReadOnly = true;
TxtBoxAdvocatteship.ReadOnly = true;
TxtBoxAdvocatteshipLssDate.ReadOnly = true;
TxtBoxAdvocatteshipExpDate.ReadOnly = true;
ButtonNew.Enabled = true;
ButtonEdit.Enabled = true;
ButtonSave.Enabled = false;
ButtonDelete.Enabled = true;
ButtonPrint.Enabled = true;
ButtonSearch.Enabled = true;
ButtonCancel.Enabled = false;
ButtonExit.Enabled = true;
TreeViewMain.Enabled = true;
RadioBtnGroup.Enabled = false;
RadioBtnNotGroup.Enabled = false;
buttonGroupSearch.Enabled = false;
ButtonLast.Enabled = true;
ButtonNext.Enabled = true;
ButtonPrevious.Enabled = true;
ButtonFirst.Enabled = true;
TextBoxMainID.Clear();
TextBoxMainName.Clear();
TextBoxID.Clear();
TextBoxGroupID.Clear();
TextBoxGroupName.Clear();
TextBoxNameLng1.Clear();
TextBoxNameLng2.Clear();
TextBoxPhone.Clear();
TextBoxeFax.Clear();
TextBoxAddress.Clear();
TextBoxRentStartDate.Clear();
TextBoxRentEndDate.Clear();
TextBoxCrNO.Clear();
TextBoxCrLssDate.Clear();
TextBoxCrExpDate.Clear();
TextBoxMunicp.Clear();
TextBoxMunicpLssDate.Clear();
TextBoxMunicpExpDate.Clear();
TxtBoxAdvocatteship.Clear();
TxtBoxAdvocatteshipLssDate.Clear();
TxtBoxAdvocatteshipExpDate.Clear();
}
else if (_TypeOperation == ClassPublicVar.TypeOperation.Add)
{
TextBoxMainID.ReadOnly = false;
TextBoxMainName.ReadOnly = false;
TextBoxID.ReadOnly = false;
TextBoxGroupID.ReadOnly = false;
TextBoxGroupName.ReadOnly = true;
TextBoxNameLng1.ReadOnly = false;
TextBoxNameLng2.ReadOnly = false;
TextBoxPhone.ReadOnly = false;
TextBoxeFax.ReadOnly = false;
TextBoxAddress.ReadOnly = false;
TextBoxRentStartDate.ReadOnly = false;
TextBoxRentEndDate.ReadOnly = false;
TextBoxCrNO.ReadOnly = false;
TextBoxCrLssDate.ReadOnly = false;
TextBoxCrExpDate.ReadOnly = false;
TextBoxMunicp.ReadOnly = false;
TextBoxMunicpLssDate.ReadOnly = false;
TextBoxMunicpExpDate.ReadOnly = false;
TxtBoxAdvocatteship.ReadOnly = false;
TxtBoxAdvocatteshipLssDate.ReadOnly = false;
TxtBoxAdvocatteshipExpDate.ReadOnly = false;
RadioBtnNotGroup.Checked = true;
ButtonNew.Enabled = true;
ButtonEdit.Enabled = false;
ButtonSave.Enabled = true;
ButtonDelete.Enabled = false;
ButtonPrint.Enabled = false;
ButtonSearch.Enabled = false;
ButtonCancel.Enabled = true;
ButtonExit.Enabled = false;
TreeViewMain.Enabled = false;
RadioBtnGroup.Enabled = true;
RadioBtnNotGroup.Enabled = true;
buttonGroupSearch.Enabled = true;
ButtonLast.Enabled = false;
ButtonNext.Enabled = false;
ButtonPrevious.Enabled = false;
ButtonFirst.Enabled = false;
TextBoxMainID.Clear();
TextBoxMainName.Clear();
TextBoxID.Clear();
TextBoxGroupID.Clear();
TextBoxGroupName.Clear();
TextBoxNameLng1.Clear();
TextBoxNameLng2.Clear();
TextBoxPhone.Clear();
TextBoxeFax.Clear();
TextBoxAddress.Clear();
TextBoxRentStartDate.Clear();
TextBoxRentEndDate.Clear();
TextBoxCrNO.Clear();
TextBoxCrLssDate.Clear();
TextBoxCrExpDate.Clear();
TextBoxMunicp.Clear();
TextBoxMunicpLssDate.Clear();
TextBoxMunicpExpDate.Clear();
TxtBoxAdvocatteship.Clear();
TxtBoxAdvocatteshipLssDate.Clear();
TxtBoxAdvocatteshipExpDate.Clear();
}
else if (_TypeOperation == ClassPublicVar.TypeOperation.Edit)
{
TextBoxMainID.ReadOnly = false;
TextBoxMainName.ReadOnly = false;
TextBoxID.ReadOnly = true;
TextBoxGroupID.ReadOnly = false;
TextBoxGroupName.ReadOnly = true;
TextBoxNameLng1.ReadOnly = false;
TextBoxNameLng2.ReadOnly = false;
TextBoxPhone.ReadOnly = false;
TextBoxeFax.ReadOnly = false;
TextBoxAddress.ReadOnly = false;
TextBoxRentStartDate.ReadOnly = false;
TextBoxRentEndDate.ReadOnly = false;
TextBoxCrNO.ReadOnly = false;
TextBoxCrLssDate.ReadOnly = false;
TextBoxCrExpDate.ReadOnly = false;
TextBoxMunicp.ReadOnly = false;
TextBoxMunicpLssDate.ReadOnly = false;
TextBoxMunicpExpDate.ReadOnly = false;
TxtBoxAdvocatteship.ReadOnly = false;
TxtBoxAdvocatteshipLssDate.ReadOnly = false;
TxtBoxAdvocatteshipExpDate.ReadOnly = false;
ButtonNew.Enabled = false;
ButtonEdit.Enabled = false;
ButtonSave.Enabled = true;
ButtonDelete.Enabled = false;
ButtonPrint.Enabled = false;
ButtonSearch.Enabled = false;
ButtonCancel.Enabled = true;
ButtonExit.Enabled = false;
TreeViewMain.Enabled = false;
RadioBtnGroup.Enabled = true;
RadioBtnNotGroup.Enabled = true;
buttonGroupSearch.Enabled = true;
ButtonLast.Enabled = false;
ButtonNext.Enabled = false;
ButtonPrevious.Enabled = false;
ButtonFirst.Enabled = false;
//TextBoxMainID.Clear();
//TextBoxMainName.Clear();
//TextBoxID.Clear();
//TextBoxGroupID.Clear();
//TextBoxGroupName.Clear();
//TextBoxNameLng1.Clear();
//TextBoxNameLng2.Clear();
//TextBoxPhone.Clear();
//TextBoxeFax.Clear();
//TextBoxAddress.Clear();
//TextBoxRentStartDate.Clear();
//TextBoxRentEndDate.Clear();
//TextBoxCrNO.Clear();
//TextBoxCrLssDate.Clear();
//TextBoxCrExpDate.Clear();
//TextBoxMunicp.Clear();
//TextBoxMunicpLssDate.Clear();
//TextBoxMunicpExpDate.Clear();
//TxtBoxAdvocatteship.Clear();
//TxtBoxAdvocatteshipLssDate.Clear();
//TxtBoxAdvocatteshipExpDate.Clear();
}
}
private void ToolsStatus()
{
if (_TypeOperation == ClassPublicVar.TypeOperation.Show)
{
TextBoxID.ReadOnly = true;
TextBoxGroupID.ReadOnly = true;
TextBoxGroupName.ReadOnly = true;
TextBoxNameLng1.ReadOnly = true;
TextBoxNameLng2.ReadOnly = true;
TextBoxAddress.ReadOnly = true;
TextBoxCity.ReadOnly = true;
TextBoxEmail.ReadOnly = true;
TextBoxTelephone1.ReadOnly = true;
TextBoxTelephone2.ReadOnly = true;
TextBoxFax.ReadOnly = true;
TextBoxMobile.ReadOnly = true;
TextBoxCreditLimit.ReadOnly = true;
TextBoxDebitTrans.ReadOnly = true;
TextBoxCreditTrans.ReadOnly = true;
TextBoxBalance.ReadOnly = true;
ButtonNew.Enabled = true;
ButtonEdit.Enabled = true;
ButtonSave.Enabled = false;
ButtonDelete.Enabled = true;
ButtonPrint.Enabled = true;
ButtonSearch.Enabled = true;
ButtonCancel.Enabled = false;
ButtonExit.Enabled = true;
TreeViewMain.Enabled = true;
RadioBtnGroup.Enabled = false;
RadioBtnNotGroup.Enabled = false;
buttonGroupSearch.Enabled = false;
ButtonExit.Enabled = true;
ButtonLast.Enabled = true;
ButtonNext.Enabled = true;
ButtonPrevious.Enabled = true;
ButtonFirst.Enabled = true;
TextBoxID.Clear();
TextBoxGroupID.Clear();
TextBoxGroupName.Clear();
TextBoxNameLng1.Clear();
TextBoxNameLng2.Clear();
TextBoxAddress.Clear();
TextBoxCity.Clear();
TextBoxEmail.Clear();
TextBoxTelephone1.Clear();
TextBoxTelephone2.Clear();
TextBoxFax.Clear();
TextBoxMobile.Clear();
TextBoxCreditLimit.Clear();
TextBoxDebitTrans.Clear();
TextBoxCreditTrans.Clear();
TextBoxBalance.Clear();
}
else if (_TypeOperation == ClassPublicVar.TypeOperation.Add)
{
TextBoxID.ReadOnly = false;
TextBoxGroupID.ReadOnly = false;
TextBoxGroupName.ReadOnly = true;
TextBoxNameLng1.ReadOnly = false;
TextBoxNameLng2.ReadOnly = false;
TextBoxAddress.ReadOnly = false;
TextBoxCity.ReadOnly = false;
TextBoxEmail.ReadOnly = false;
TextBoxTelephone1.ReadOnly = false;
TextBoxTelephone2.ReadOnly = false;
TextBoxFax.ReadOnly = false;
TextBoxMobile.ReadOnly = false;
TextBoxCreditLimit.ReadOnly = false;
TextBoxDebitTrans.ReadOnly = false;
TextBoxCreditTrans.ReadOnly = false;
TextBoxBalance.ReadOnly = false;
ButtonNew.Enabled = true;
ButtonEdit.Enabled = false;
ButtonSave.Enabled = true;
ButtonDelete.Enabled = false;
ButtonPrint.Enabled = false;
ButtonSearch.Enabled = false;
ButtonCancel.Enabled = true;
ButtonExit.Enabled = false;
TreeViewMain.Enabled = false;
RadioBtnGroup.Enabled = true;
RadioBtnNotGroup.Enabled = true;
buttonGroupSearch.Enabled = true;
ButtonExit.Enabled = false;
ButtonLast.Enabled = false;
ButtonNext.Enabled = false;
ButtonPrevious.Enabled = false;
ButtonFirst.Enabled = false;
TextBoxID.Clear();
TextBoxGroupID.Clear();
TextBoxGroupName.Clear();
TextBoxNameLng1.Clear();
TextBoxNameLng2.Clear();
TextBoxAddress.Clear();
TextBoxCity.Clear();
TextBoxEmail.Clear();
TextBoxTelephone1.Clear();
TextBoxTelephone2.Clear();
TextBoxFax.Clear();
TextBoxMobile.Clear();
TextBoxCreditLimit.Clear();
TextBoxDebitTrans.Clear();
TextBoxCreditTrans.Clear();
TextBoxBalance.Clear();
}
else if (_TypeOperation == ClassPublicVar.TypeOperation.Edit)
{
TextBoxID.ReadOnly = true;
TextBoxGroupID.ReadOnly = false;
TextBoxGroupName.ReadOnly = true;
TextBoxNameLng1.ReadOnly = false;
TextBoxNameLng2.ReadOnly = false;
TextBoxAddress.ReadOnly = false;
TextBoxCity.ReadOnly = false;
TextBoxEmail.ReadOnly = false;
TextBoxTelephone1.ReadOnly = false;
TextBoxTelephone2.ReadOnly = false;
TextBoxFax.ReadOnly = false;
TextBoxMobile.ReadOnly = false;
TextBoxCreditLimit.ReadOnly = false;
TextBoxDebitTrans.ReadOnly = false;
TextBoxCreditTrans.ReadOnly = false;
TextBoxBalance.ReadOnly = false;
ButtonNew.Enabled = true;
ButtonEdit.Enabled = false;
ButtonSave.Enabled = true;
ButtonDelete.Enabled = false;
ButtonPrint.Enabled = false;
ButtonSearch.Enabled = false;
ButtonCancel.Enabled = true;
ButtonExit.Enabled = false;
TreeViewMain.Enabled = false;
RadioBtnGroup.Enabled = true;
RadioBtnNotGroup.Enabled = true;
buttonGroupSearch.Enabled = true;
ButtonLast.Enabled = false;
ButtonNext.Enabled = false;
ButtonPrevious.Enabled = false;
ButtonFirst.Enabled = false;
//TextBoxID.Clear();
//TextBoxGroupID.Clear();
//TextBoxGroupName.Clear();
//TextBoxNameLng1.Clear();
//TextBoxNameLng2.Clear();
//TextBoxAddress.Clear();
//TextBoxCity.Clear();
//TextBoxEmail.Clear();
//TextBoxTelephone1.Clear();
//TextBoxTelephone2.Clear();
//TextBoxFax.Clear();
//TextBoxMobile.Clear();
//TextBoxCreditLimit.Clear();
//TextBoxDebitTrans.Clear();
//TextBoxCreditTrans.Clear();
//TextBoxBalance.Clear();
}
}
private void TextBoxAddress_Enter(object sender, EventArgs e)
{
TextBoxAddress.SelectAll();
}
private void ClearControls()
{
TextBoxAddress.Clear();
TextBoxName.Clear();
TextBoxClasses.Clear();
}
