public static void FillDb(this MySqliteDBContext db, DbSet <dbContact> dbSet)
{
XmlDocument doc = new XmlDocument();
doc.Load("Contacts.xml");
XmlElement root = doc.DocumentElement;
// This is the node we are looking for in the XML string
XmlNodeList nodes = root.SelectNodes("//record");
foreach (XmlNode node in nodes)
{
XmlNode fieldid = node.SelectSingleNode("Id");
XmlNode fieldfname = node.SelectSingleNode("Full_Name");
XmlNode fieldcountry = node.SelectSingleNode("Country");
XmlNode fieldphonenumber = node.SelectSingleNode("Phone_Number");
XmlNode fieldcreatedat = node.SelectSingleNode("Created_At");
XmlNode fieldzipcode = node.SelectSingleNode("Zip_Code");
XmlNode fieldwebsite = node.SelectSingleNode("Web_Site");
XmlNode fieldemail = node.SelectSingleNode("Email");
dbContact cnt = new dbContact()
{
//Id = int.Parse(fieldid.InnerText),
Full_Name = fieldfname.InnerText,
Country = fieldcountry.InnerText,
Phone_Number = fieldphonenumber.InnerText,
Created_At = fieldcreatedat.InnerText,
Zip_Code = fieldzipcode.InnerText,
Email = fieldemail.InnerText
};
dbSet.Add(cnt);
db.SaveChanges();
}
}
public IActionResult RegisterContact(dbContact cnt)
{
MySqliteDBContext context = new MySqliteDBContext();
SqliteDBContext.AddContactRecord(cnt);
context.searchCriteria = cnt;
return(View("SQLiteContacts", SqliteDBContext));
}
public TestBasicController(ITestOutputHelper _testOutputHelper)
{
this._testOutputHelper = _testOutputHelper;
var optionsBuilder = new DbContextOptionsBuilder <MySqliteDBContext>();
optionsBuilder.UseSqlite(@"Data Source=/Users/Konstantin/Desktop/Projects/Demo.Asp.Net/Demo.Test/bin/Debug/netcoreapp2.1/blogging.db");
MySqliteDBContext db = new MySqliteDBContext(optionsBuilder.Options);
controller = new BasicController(db);
}
public IActionResult AddContact(MySqliteDBContext context)
{
Stream req = Request.Body;
//req.Seek(0, System.IO.SeekOrigin.Begin);
string json = new StreamReader(req).ReadToEnd();
dbContact criteria = JsonConvert.DeserializeObject <dbContact>(json);
SqliteDBContext.searchCriteria = criteria;
//return View("SQLiteNewContacts", SqliteDBContext);
dbContact cnt = SqliteDBContext.searchCriteria;
return(View("SQLiteNewContacts", cnt));
}
public IActionResult DeleteContact()
{
Stream req = Request.Body;
//req.Seek(0, System.IO.SeekOrigin.Begin);
string json = new StreamReader(req).ReadToEnd();
dbContact criteria = JsonConvert.DeserializeObject <dbContact>(json);
dbContact record = SqliteDBContext.Contacts.Find(criteria.Id);
// Contract.Ensures(Contract.Result<IActionResult>() != null);
MySqliteDBContext context = new MySqliteDBContext();
SqliteDBContext.DeleteContactRecord(record.Id);
context.searchCriteria = record;
return(View("~/Views/Basic/SQLiteContacts.cshtml", SqliteDBContext));
}
public ContactController(MySqliteDBContext sqliteDBContext)
{
SqliteDBContext = sqliteDBContext;
}
public BasicController(MySqliteDBContext sqliteDBContext)
{
SqliteDBContext = sqliteDBContext;
SqliteDBContext.InitializeDB();
}
