public int UpdateWaiter(WaiterDetails wd)
{
tbl_waiter td = _db.tbl_waiter.Where(c => c.WaiterID == wd.WaiterID).FirstOrDefault();
td.WaiterName = wd.WaiterName;
td.WaiterContact = wd.WaiterContact;
td.WaiterAddress = wd.WaiterAddress;
return(_db.SaveChanges());
}
public int AddNewWaiter(WaiterDetails wd)
{
tbl_waiter tw = new tbl_waiter();
tw.WaiterName = wd.WaiterName;
tw.WaiterContact = wd.WaiterContact;
tw.WaiterAddress = wd.WaiterAddress;
_db.tbl_waiter.Add(tw);
return(_db.SaveChanges());
}
private void LoadWaiter()
{
List <WaiterDetails> lstwt = blw.GetAllWaiters();
WaiterDetails pro = new WaiterDetails();
pro.WaiterName = "Choose Waiter";
lstwt.Insert(0, pro);
cmbWaiter.DataSource = lstwt;
cmbWaiter.DisplayMember = "WaiterName";
cmbWaiter.ValueMember = "WaiterID";
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtWaiterName.Text == "")
{
MessageBox.Show("Please Enter Waiter Name", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtWaiterName.Focus();
return;
}
if (txtContact.Text == "")
{
MessageBox.Show("Please Enter Waiter Contact Number", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtContact.Focus();
return;
}
if (txtAddress.Text == "")
{
MessageBox.Show("Please Enter Waiter Address", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtAddress.Focus();
return;
}
WaiterDetails wd = new WaiterDetails();
wd.WaiterName = txtWaiterName.Text;
wd.WaiterContact = txtContact.Text;
wd.WaiterAddress = txtAddress.Text;
bool isexists = blw.CheckContact(txtContact.Text);
if (isexists)
{
MessageBox.Show("Waiter Already Exists in Database", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtContact.Text = "";
txtContact.Focus();
}
else
{
int i = blw.AddNewWaiter(wd);
if (i > 0)
{
MessageBox.Show("New Waiter Added Successfully", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtWaiterName.Text = "";
txtContact.Text = "";
txtAddress.Text = "";
txtWaiterName.Focus();
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtWaiterName.Text == "")
{
MessageBox.Show("Please Enter Waiter Name", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtWaiterName.Focus();
return;
}
if (txtContact.Text == "")
{
MessageBox.Show("Please Enter Waiter Contact Number", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtContact.Focus();
return;
}
if (txtAddress.Text == "")
{
MessageBox.Show("Please Enter Waiter Address", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtAddress.Focus();
return;
}
WaiterDetails wd = new WaiterDetails();
wd.WaiterID = Convert.ToInt32(txtWaiterID.Text);
wd.WaiterName = txtWaiterName.Text;
wd.WaiterContact = txtContact.Text;
wd.WaiterAddress = txtAddress.Text;
int i = blw.UpdateWaiter(wd);
if (i > 0)
{
MessageBox.Show("Waiter Updated Successfully", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Dispose();
}
}