private void btnSubmit_Click(object sender, EventArgs e) { String code = txCode.Text; String name = txName.Text; String desc = txDescription.Text; String category = txCategory.Text; int type = cmbType.SelectedIndex; if (code.Equals("")) MessageBox.Show("Item Code must be filled."); else if (name.Equals("")) MessageBox.Show("Item Name must be filled."); else if (type < 0 || type >= cmbType.Items.Count) MessageBox.Show("Item Category must be chosen."); else if (type == 0 && category.Equals("")) MessageBox.Show("New Category must be filled."); else { if (type > 0) category = cmbType.Items[type].ToString(); var res = from x in db.MsItems where x.Name.Equals(name) && x.Category.Equals(category) select x; if (res.Any()) { MessageBox.Show("Item Name in "+category+" is already existed."); } else { MsItem obj = new MsItem(); obj.Code = code; obj.Name = name; obj.Category = category; obj.Description = desc; db.MsItems.InsertOnSubmit(obj); db.SubmitChanges(); MessageBox.Show(code+" - "+name+" is added successfully."); txCategory.Text = ""; cmbType.SelectedIndex = -1; txCode.Text = ""; txDescription.Text = ""; txName.Text = ""; } } }
partial void UpdateMsItem(MsItem instance);
partial void DeleteMsItem(MsItem instance);
partial void InsertMsItem(MsItem instance);