private void listBoxSearch_SelectedIndexChanged(object sender, EventArgs e) { MySkeletonItem = MyItemList.Find(x => x.Name == (String)listBoxSearch.SelectedItem); txtItemUpdate.Text = MySkeletonItem.Name; txtCodeUpdate.Text = MySkeletonItem.Code.ToString(); }
public bool AddItem(tblSkeleton tSkeleton) { try { tblSkeleton t = new tblSkeleton(); t.Name = tSkeleton.Name; t.Code = tSkeleton.Code; db.tblSkeletons.Add(t); db.SaveChanges(); return(true); } catch (Exception ex) { Console.WriteLine("AddItem error: " + ex.Message); return(false); } }
public bool UpdateItem(tblSkeleton tSkeleton) { try { tblSkeleton t = (from a in db.tblSkeletons where a.id == tSkeleton.id select a).FirstOrDefault(); t.Name = tSkeleton.Name; t.Code = tSkeleton.Code; db.SaveChanges(); return(true); } catch (Exception ex) { Console.WriteLine("UpdateItem error: " + ex.Message); return(false); } }
private void btnSubmit_Click(object sender, EventArgs e) { var itemName = txtItemAdd.Text; var itemCode = txtCodeAdd.Text; tblSkeleton tSkeleton = new tblSkeleton(); tSkeleton.Name = itemName; tSkeleton.Code = Convert.ToInt32(itemCode); if (cl.AddItem(tSkeleton) == true) { ClearAddItems(); lblStatus.Text = "Added item " + itemName + " with code " + itemCode; } else { MessageBox.Show("Error in adding item."); } }
private void btnUpdate_Click(object sender, EventArgs e) { string putName = txtItemUpdate.Text; int putCode = Convert.ToInt32(txtCodeUpdate.Text); tblSkeleton tSkelUpdate = new tblSkeleton(); tSkelUpdate.id = MySkeletonItem.id; tSkelUpdate.Name = putName; tSkelUpdate.Code = putCode; if (cl.UpdateItem(tSkelUpdate) == true) { lblStatus.Text = "Updated item " + putName + " with code " + putCode; ClearUpdateItems(); } else { MessageBox.Show("Error in updating item"); } }