private void AutoWaiterAppId()
{
WaiterRepository emp = new WaiterRepository();
WaiterEntity en = new WaiterEntity();
var s = emp.AutoLoadWaiterId();
en.WaiterIdGenerate = s;
txtAddId.Text = en.WaiterIdGenerate;
}
public bool Save(WaiterEntity er)
{
try
{
string query = "select * from Waiter where appid = '" + er.WaiterId + "'";
var dt = DataAccess.GetDataTable(query);
if (dt == null || dt.Rows.Count == 0)
{
query = "Insert into Waiter values ('" + er.WaiterId + "','" + er.WaiterName + "','" + er.WaiterAddress + "','" + er.WaiterEmail + "','" + er.WaiterPhone + "','" + er.WaiterGender + "','" + er.WaiterDateOfBirth + "','" + er.WaiterJoiningDate + "','" + er.WaiterMaritalStatus + "','" + er.WaiterBloodGroup + "','" + er.WaiterSalary + "');";
}
else
{
//query = "Update Waiter set Name = '" + er.WaiterName + "','" + er.WaiterAddress + "','" + er.WaiterEmail + "','" + er.WaiterPhone + "','" + er.WaiterGender + "','" + er.WaiterDateOfBirth + "','" + er.WaiterJoiningDate + "','" + er.WaiterMaritalStatus + "','" + er.WaiterBloodGroup + "','" + er.WaiterSalary + "' where appid = '" + er.WaiterId + "'";
query = @"update Waiter
set Name = '" + er.WaiterName + @"',
Address = " + er.WaiterAddress + @",
Email = " + er.WaiterEmail + @",
Phone = '" + er.WaiterPhone + @"',
Gender = '" + er.WaiterGender + @"'
Date_Of_Birth = '" + er.WaiterDateOfBirth + @"',
Joining_Date = '" + er.WaiterJoiningDate + @"'
Marital_Status = '" + er.WaiterMaritalStatus + @"',
Blood_Group = '" + er.WaiterBloodGroup + @"'
Salary = '" + er.WaiterSalary + @"',
where AppId = '" + er.WaiterId + "';";
}
int count = DataAccess.ExecuteQuery(query);
if (count >= 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public WaiterEntity ConvertToEntity(DataRow row)
{
if (row == null)
{
return(null);
}
var w = new WaiterEntity();
w.WaiterId = row["AppId"].ToString();
w.WaiterName = row["Name"].ToString();
w.WaiterAddress = row["Address"].ToString();
w.WaiterBloodGroup = row["Blood_Group"].ToString();
w.WaiterDateOfBirth = row["Date_Of_Birth"].ToString();
w.WaiterEmail = row["Email"].ToString();
w.WaiterPhone = row["Phone"].ToString();
w.WaiterGender = row["Gender"].ToString();
w.WaiterMaritalStatus = row["Marital_Status"].ToString();
w.WaiterJoiningDate = row["Joining_Date"].ToString();
w.WaiterSalary = row["Salary"].ToString();
return(w);
}
private void BtnSave_Click(object sender, EventArgs e)
{
WaiterEntity w = new WaiterEntity();
WaiterRepository repo = new WaiterRepository();
ManagerEntity m = new ManagerEntity();
ManagerRepository mepo = new ManagerRepository();
AdminRepository arepo = new AdminRepository();
AdminEntity a = new AdminEntity();
if (rbGenderFemale.Checked == true || rbGenderMale.Checked == true)
{
if (cmbPost.Text == "Waiter")
{
if (IsValidToSave())
{
w.WaiterName = txtAddName.Text;
w.WaiterId = txtAddId.Text;
w.WaiterAddress = txtAddAddress.Text;
w.WaiterEmail = txtAddEmail.Text;
w.WaiterPhone = txtAddPhone.Text;
if (rbGenderFemale.Checked == true)
{
w.WaiterGender = "Female";
}
else if (rbGenderMale.Checked == true)
{
w.WaiterGender = "Male";
}
else
{
MessageBox.Show("Please Select A Gender");
}
w.WaiterDateOfBirth = dtDate_Of_Birth.Value.ToString();
w.WaiterJoiningDate = dtJoining_Date.Value.ToString();
w.WaiterMaritalStatus = cmbMaritalStatus.Text;
w.WaiterBloodGroup = cmbBlood_Group.Text;
w.WaiterSalary = txtSalary.Text;
repo.Save(w);
Denied();
clear();
AutoWaiterAppId();
}
else
{
MessageBox.Show("Invalid Fields");
}
}
else if (cmbPost.Text == "Admin")
{
if (IsValidToSave())
{
a.AdminName = txtAddName.Text;
a.AdminId = txtAddId.Text;
a.AdminAddress = txtAddAddress.Text;
a.AdminEmail = txtAddEmail.Text;
a.AdminPhone = txtAddPhone.Text;
if (rbGenderFemale.Checked == true)
{
a.AdminGender = "Female";
}
else if (rbGenderMale.Checked == true)
{
a.AdminGender = "Male";
}
a.AdminDateOfBirth = dtDate_Of_Birth.Value.ToString();
a.AdminJoiningDate = dtJoining_Date.Value.ToString();
m.ManagerMaritalStatus = cmbMaritalStatus.Text;
a.AdminBloodGroup = cmbBlood_Group.Text;
a.AdminSalary = txtSalary.Text;
arepo.Save(a);
//Denied();
clear();
AutoManagerAppId();
}
else
{
MessageBox.Show("Invalid Fiels");
}
}
else if (cmbPost.Text == "Manager")
{
if (IsValidToSave())
{
m.ManagerName = txtAddName.Text;
m.ManagerId = txtAddId.Text;
m.ManagerAddress = txtAddAddress.Text;
m.ManagerEmail = txtAddEmail.Text;
m.ManagerPhone = txtAddPhone.Text;
if (rbGenderFemale.Checked == true)
{
m.ManagerGender = "Female";
}
else if (rbGenderMale.Checked == true)
{
m.ManagerGender = "Male";
}
m.ManagerDateOfBirth = dtDate_Of_Birth.Value.ToString();
m.ManagerJoiningDate = dtJoining_Date.Value.ToString();
m.ManagerMaritalStatus = cmbMaritalStatus.Text;
m.ManagerBloodGroup = cmbBlood_Group.Text;
m.ManagerSalary = txtSalary.Text;
mepo.Save(m);
//Denied();
clear();
AutoAdminAppId();
}
else
{
MessageBox.Show("Invalid Fields");
}
}
else
{
MessageBox.Show("Please Select An Employee Type");
}
}
else
{
MessageBox.Show("Please Select A Gender");
}
}
