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");
}
}
