private void button1_Click(object sender, EventArgs e)
{
textBox3.Clear();
long _number;
if ((!(long.TryParse(textBox2.Text, out _number))) | _number==0)
{
MessageBox.Show("Invalid Number");
}
else if (string.IsNullOrWhiteSpace(textBox1.Text) | textBox1.Text.StartsWith(" "))
{
MessageBox.Show("Invalid Name");
}
else
{
var _phoneEntry = new PhoneEntry(textBox1.Text, _number);
if (_phoneEntry.IsValidNumber())
{
validation = businessLayer.AddToDictionary(_phoneEntry);
if (validation.isError)
{
MessageBox.Show(validation.description);
validation.isError = false;
}
else
{
gridDisplay(null);
button2_Click(sender,e);
}
}
else
MessageBox.Show("Number should be of length 10");
}
}
public ErrorValidation Add(PhoneEntry phoneEntry)
{
string searchBy="Number";
string searchNumber= phoneEntry.number.ToString();
var resultList = PK_Validation.Search(searchBy, searchNumber);
if (resultList.Any())
{
validation.isError = true;
validation.description = "Number already presents in the Directory";
return validation;
}
return phoneRepo.Add(phoneEntry);
}
public ErrorValidation Add(PhoneEntry phoneEntry)
{
using (SqlConnection sqlConn = new SqlConnection(sqlConnectionString))
{
try
{
sqlConn.Open();
var cmd = new SqlCommand("Insert into PhoneDirectory values(@name,@phone)");
cmd.Connection = sqlConn;
cmd.Parameters.AddWithValue("@name", phoneEntry.name);
cmd.Parameters.AddWithValue("@phone", phoneEntry.number);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
validation.isError = true;
validation.description = e.ToString();
}
return validation;
}
}
public ErrorValidation AddToDictionary(PhoneEntry phoneEntry)
{
return businessLayerAdd.Add(phoneEntry);
}
