public void AddItem(string title, string answera, string answerb, string answerc, string answerd, string answer, int state) { // 向备忘录里面添加新的元素; DataBase.Item todo = new DataBase.Item(title, answera, answerb, answerc, answerd, answer, state); this.allItems.Add(todo); DataBase.DbContext.InsertData(todo.getID(), title, answera, answerb, answerc, answerd, answer, state); }
public void UpdateItem(int id, string title, string answera, string answerb, string answerc, string answerd, string answer, int state) { int index = getIndexOfItemById(id); if (index != -1) { DataBase.DbContext.UpdateData(id, title, answera, answerb, answerc, answerd, answer, state); allItems[index].UpdateItem(title, answera, answerb, answerc, answerd, answer, state); } // set selectedItem to null after update this.selectedItem = null; }
public void RemoveItem(int id) { // DIY // set selectedItem to null after remove int index = getIndexOfItemById(id); if (index != -1) { this.allItems.Remove(selectedItem); DataBase.DbContext.DeleteData(id); } this.selectedItem = null; }
private void SaveData() { try { ADAM.DataBase.ADAMConnectionString Mdb = new DataBase.ADAMConnectionString(); ADAM.DataBase.Item dr = new DataBase.Item(); #region InsertImgIntoSql string filePath = fulImage.PostedFile.FileName; string filename = Path.GetFileName(filePath); string ext = Path.GetExtension(filename); Stream fs = fulImage.PostedFile.InputStream; BinaryReader br = new BinaryReader(fs); Byte[] bytes = br.ReadBytes((Int32)fs.Length); #endregion dr.Code = long.Parse(txtCode.Text); dr.Image = bytes; dr.ItemStatus = int.Parse(ddlItemStatus.SelectedValue); dr.ItemTypeId = long.Parse(ddlItemType.SelectedValue); dr.ItemunitId = long.Parse(ddlItemUnit.SelectedValue); dr.LimitQty = decimal.Parse(txtLimitQty.Text); dr.Note = txtNote.Text; dr.Sex = int.Parse(ddlSex.SelectedValue); dr.Specification = txtSpecification.Text; dr.Name = txtName.Text; dr.ProductionLineId = int.Parse(ddlProductionLine.SelectedValue); Mdb.Items.Add(dr); Mdb.SaveChanges(); #region showImg Binary binary = dr.Image; byte[] Nbytes; string Base64String = string.Empty; Nbytes = binary.ToArray(); Base64String = Convert.ToBase64String(bytes, 0, Nbytes.Length); ImgItem.ImageUrl = "data:image/png;base64," + Base64String; #endregion } catch { Response.Write("<script>alert('خطأ أثناء الحفظ من فضلك تأكد من ادخال البيانات بشكل صحيح او الاتصال بقاعدة البيانات')</script>"); } }