C# (CSharp) EC_Staff Examples

Example #1

 public void DeleteStaff(EC_Staff et)
 {
     sql.DeleteStaff(et);
 }

Example #2

 public void UpdateAllStaff(EC_Staff et)
 {
     sql.UpdateAllStaff(et);
 }

Example #3

 public void AddStaff(EC_Staff et)
 {
     sql.AddStaff(et);
 }

Example #4

 public void DeleteStaff(EC_Staff et)
 {
     cn.ImplementSQL(@"DELETE FROM STAFF Where Id=N'" + et.Id + "'");
 }

Example #5

 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 + "'");
 }

Example #6

 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 + "')");
 }