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); }