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