public void DelItem(Item item) { using (SQLiteCommand cmd = new SQLiteCommand(conn)) { cmd.CommandText = "delete from items where id=@Id;"; cmd.Prepare(); cmd.Parameters.AddWithValue("@Id", item.Id); cmd.ExecuteNonQuery(); Items.Remove(item); } if (item.FileName!=string.Empty) { try { File.Delete(SomeConst.FILEDIR + item.FileName); } catch (System.Exception) { System.Windows.Forms.MessageBox.Show("Delete file failed."); } } }
public void SaveItem(Item refItem, Item newItem) { refItem.Title = newItem.Title; refItem.Description = newItem.Description; refItem.Tagum = newItem.Tagum; if (refItem.IsChanged()) { using (SQLiteCommand cmd = new SQLiteCommand(conn)) { List<string> sList = new List<string>(); if (refItem.IsTitleChanged) { sList.Add("title=@Title"); } if (refItem.IsDescriptionChanged) { sList.Add("description=@Description"); } if (refItem.IsTagumChanged) { sList.Add("tagum=@Tagum"); } cmd.CommandText = "update items set " + string.Join(",", sList) + " where id=@Id"; cmd.Prepare(); cmd.Parameters.AddWithValue("@Id", refItem.Id); cmd.Parameters.AddWithValue("@Title", refItem.Title); cmd.Parameters.AddWithValue("@Description", refItem.Description); cmd.Parameters.Add("@Tagum", System.Data.DbType.Binary).Value = refItem.Tagum; cmd.ExecuteNonQuery(); refItem.ClearChangeStatus(); } } }
public void AddItem(Item item, string path) { using (SQLiteCommand cmd = new SQLiteCommand(conn)) { cmd.CommandText = "insert into items(title,description,file,tagum) values(@Title,@Description,@File,@Tagum);"; cmd.Prepare(); cmd.Parameters.AddWithValue("@Title", item.Title); cmd.Parameters.AddWithValue("@Description", item.Description); cmd.Parameters.AddWithValue("@File", item.FileName); cmd.Parameters.Add("@Tagum", System.Data.DbType.Binary).Value = item.Tagum; cmd.ExecuteNonQuery(); item.Id = (int)conn.LastInsertRowId; Items.Add(item); } if (item.FileName!=string.Empty) { File.Copy(path, SomeConst.FILEDIR + item.FileName); } }