public static void AddThing(BO_TodoThing thing) { //serial //DB_Acces_Serial_TodoThing.AddData(thing); //sql command DB_Acces_Client.DB_PostThing(thing); }
//factoriser code de test public static void AddData(BO_TodoThing thing) { var dir = new DirectoryInfo(@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml"); if (dir.Exists) { if(new FileInfo(@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml\file.xml").Exists) { var ser = new XmlSerializer(typeof(List<BO_TodoThing>)); var data =new List<BO_TodoThing>(); using (var stream = new StreamReader(@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml\file.xml")) { data = (List<BO_TodoThing>)ser.Deserialize(stream); } data.Add(thing); System.IO.File.WriteAllText((@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml\file.xml"), string.Empty); using (var stream = new StreamWriter(@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml\file.xml")) { ser.Serialize(stream, data); } } else { var ser = new XmlSerializer(typeof(List<BO_TodoThing>)); var data = new List<BO_TodoThing>(); CreateData(); using (var stream = new StreamReader(@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml\file.xml")) { data = (List<BO_TodoThing>)ser.Deserialize(stream); } data.Add(thing); System.IO.File.WriteAllText((@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml\file.xml"), string.Empty); using (var stream = new StreamWriter(@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml\file.xml")) { ser.Serialize(stream, data); } } } else { dir.Create(); CreateData(); var ser = new XmlSerializer(typeof(List<BO_TodoThing>)); var data = new List<BO_TodoThing>(); CreateData(); using (var stream = new StreamReader(@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml\file.xml")) { data = (List<BO_TodoThing>)ser.Deserialize(stream); } data.Add(thing); System.IO.File.WriteAllText((@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml\file.xml"), string.Empty); using (var stream = new StreamWriter(@"C:\Users\Karim\Documents\cours\developpement\c_sharp\3eme\projet\b.m.t\MVVM\DAL_SericalisationXML\Xml\file.xml")) { ser.Serialize(stream, data); } } }
public static void DB_PostThing(BO_TodoThing thing) { var cmd = new SqlCommand("Client.insertToDB", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@title", thing.Title); try { Connect.OpenConnection(con); cmd.ExecuteNonQuery(); Connect.CloseConnection(con); } catch (Exception ex) { throw; } }
public static List<BO_TodoThing> DB_GetAllTodoThing() { var cmd = new SqlCommand("Client.GetAllThingToDo",con); cmd.CommandType = CommandType.StoredProcedure; var ds = exec(cmd, "thing"); var lst = new List<BO_TodoThing>(); foreach (DataRow r in ds.Tables["thing"].Rows) { var t = new BO_TodoThing() { ID = Convert.ToInt32(r["Id"].ToString()), Title = r["Title"].ToString(), Done = Convert.ToInt32(r["Done"].ToString()) }; lst.Add(t); } return lst; }