public void DeleteStaff(EC_Staff et)
{
sql.DeleteStaff(et);
}
public void UpdateAllStaff(EC_Staff et)
{
sql.UpdateAllStaff(et);
}
public void AddStaff(EC_Staff et)
{
sql.AddStaff(et);
}
public void DeleteStaff(EC_Staff et)
{
cn.ImplementSQL(@"DELETE FROM STAFF Where Id=N'" + et.Id + "'");
}
public void UpdateStaff(EC_Staff et)
{
cn.ImplementSQL("UPDATE STAFF SET Name =N'" + et.Name + "', DateOfBirth =N'" + et.DOB + "', Sex =N'" + et.Sex + "', PhoneNumber = " + et.Phone + " where ID=N'" + et.Id + "'");
}
public void AddStaff(EC_Staff et)
{
cn.ImplementSQL(@"INSERT INTO STAFF (ID, Name, DateOfBirth, Sex, UserName, Password, PhoneNumber) VALUES(N'" + et.Id + "',N'" + et.Name + "',N'" + et.DOB + "',N'" + et.Sex + "',N'" + et.UserName + "',N'" + et.Password + "',N'" + et.Phone + "')");
}