public string AddNewTelephoneNumber(TelephoneNumberInfo aTelephoneNumberInfo) { if (IsNumberAlreadyAvailable(aTelephoneNumberInfo)) { return "Error! Number Already Exist in Database."; } InsertIntoDatabase(aTelephoneNumberInfo); return "Number Success Fully Added."; }
private void InsertIntoDatabase(TelephoneNumberInfo aTelephoneNumberInfo) { string nonQuery = "INSERT INTO allphoneinfo (`PhoneNumber`," + " `ServiceStatus`, `ConnectionTypeID`, `Remarks`)" + " VALUES (@PhoneNumber," + " @ServiceStatus, @ConnectionTypeID, @Remarks);"; Hashtable aHashtable = new Hashtable() { {"PhoneNumber", aTelephoneNumberInfo.PhoneNumber}, {"ServiceStatus", "Terminated"}, {"ConnectionTypeID", aTelephoneNumberInfo.ConnectionTypeID}, {"Remarks","New Phone"}, }; aGateway.Insert(nonQuery, aHashtable); }
private bool IsNumberAlreadyAvailable(TelephoneNumberInfo aTelephoneNumberInfo) { string query = "select * from allphoneinfo where PhoneNumber=@PhoneNumber;"; Hashtable aHastable = new Hashtable() { {"PhoneNumber", aTelephoneNumberInfo.PhoneNumber} }; if (aGateway.Select(query, aHastable).Tables[0].Rows.Count == 0) { return false; } return true; }
public ActionResult SubmitNewTelephoneNumber(TelephoneNumberInfo aTelephoneNumberInfo) { if (aTelephoneNumberInfo.ConnectionTypeID.Trim().Length == 0 || aTelephoneNumberInfo.PhoneNumber.Trim().Length == 0) { ViewData["Message"] = "Error! Fill All Fields"; return View("AddNewTelephoneNumber"); } TelephoneNumber aNumber = new TelephoneNumber(); string message = aNumber.AddNewTelephoneNumber(aTelephoneNumberInfo); ViewData["Message"] = message; return View("AddNewTelephoneNumber"); }