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