public static bool Update(POCXml pxml) { return(Update(new List <POCXml>() { pxml })); }
public static bool Insert(POCXml pxml) { return(Insert(new List <POCXml>() { pxml })); }
private static SqlCommand CreateInsertCommand(POCXml pXml) { // insert statement const string INSERT_STATEMENT = "INSERT INTO ConversionXml " + "(Xml_TypeId, XmlFile) VALUES " + "(@TypeId, @XmlFile)"; // create insert command SqlCommand cmd = new SqlCommand(INSERT_STATEMENT); // add values to command cmd.Parameters.AddWithValue("@TypeId", pXml.Xml_TypeId); cmd.Parameters.Add(new SqlParameter("@XmlFile", SqlDbType.Xml) { Value = pXml.XmlFile, }); // return command return(cmd); }
public static SqlCommand CreateUpdateCommand(POCXml pXml) { // update statement const string UPDATE_STATEMENT = "UPDATE ConversionXml " + "SET Xml_TypeId = @TypeId, XmlFile = @XmlFile " + "WHERE Xml_Id = @Id"; // create insert command SqlCommand cmd = new SqlCommand(UPDATE_STATEMENT); // add values to command cmd.Parameters.AddWithValue("@Id", pXml.Xml_Id); cmd.Parameters.AddWithValue("@TypeId", pXml.Xml_TypeId); cmd.Parameters.Add(new SqlParameter("@XmlFile", SqlDbType.Xml) { Value = pXml.XmlFile, }); // return command return(cmd); }