private void Button_Click(object sender, RoutedEventArgs e) { if (CheckEmpty()) { Model.dao.EmployeeDao ED = new Model.dao.EmployeeDao(); if (!ED.CheckEmp(tbIDCard.Text)) { Model.entity.EMPLOYEE emp = new Model.entity.EMPLOYEE(); emp.IDCARD = tbIDCard.Text; emp.NAME = tbName.Text; emp.AGE = int.Parse(tbAge.Text); emp.PHONENUMBER = tbPhone.Text; emp.EMAIL = tbEmail.Text; emp.ADDRESS = tbAddress.Text; emp.USERNAME = tbUser.Text; emp.PASSWORD = tbPass.Password; emp.ACCOUNTTYPE = boxType.Text; if (ED.Add(emp)) { MessageBox.Show("Employee Added !"); this.Close(); } else { MessageBox.Show("Failed To Add !"); } } else { MessageBox.Show("Employee Is Already Exists!"); } } }
public bool Add(Model.entity.EMPLOYEE e) { HOTELMANAGEMENTEntities hm = new HOTELMANAGEMENTEntities(); try { hm.EMPLOYEEs.Add(e); hm.SaveChanges(); return(true); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } }
public bool EditEmp(Model.entity.EMPLOYEE e) { conn = new SqlConnection(connstring); conn.Open(); q = new SqlCommand("update employee set age= " + e.AGE + " ,email='" + e.EMAIL + "' ,phonenumber='" + e.PHONENUMBER + "' ,address='" + e.ADDRESS + "' ,accounttype='" + e.ACCOUNTTYPE + "' where idcard='" + e.IDCARD + "'", conn); try { q.ExecuteNonQuery(); return(true); } catch (Exception) { return(false); } }
public EditEmployee(Model.entity.EMPLOYEE emp) { InitializeComponent(); tbIDCard.Text = emp.IDCARD; tbIDCard.IsReadOnly = true; tbIDCard.IsEnabled = false; tbName.Text = emp.NAME; tbName.IsReadOnly = true; tbName.IsEnabled = false; tbAge.Text = emp.AGE.ToString(); tbEmail.Text = emp.EMAIL; tbPhone.Text = emp.PHONENUMBER; tbAddress.Text = emp.ADDRESS; boxType.Text = emp.ACCOUNTTYPE; }
private void Button_Click(object sender, RoutedEventArgs e) { if (CheckEmpty()) { Model.entity.EMPLOYEE emp = new Model.entity.EMPLOYEE(); emp.IDCARD = tbIDCard.Text; emp.AGE = int.Parse(tbAge.Text); emp.EMAIL = tbEmail.Text; emp.ADDRESS = tbAddress.Text; emp.PHONENUMBER = tbPhone.Text; emp.ACCOUNTTYPE = boxType.Text; Model.dao.EmployeeDao ED = new Model.dao.EmployeeDao(); if (ED.EditEmp(emp)) { MessageBox.Show("Employee Edited !"); this.Close(); } else { MessageBox.Show("Failed To Edited !"); } } }