C# (CSharp) EC_Customer Examples

Example #1

File: SQL_Member.cs Project: annguyenbku/An

 public void DeleteCustomer(EC_Customer et)
 {
     cn.ImplementSQL(@"DELETE FROM CUSTOMER Where ID_CUSTOMER=N'" + et.Id + "'");
 }

Example #2

File: SQL_Member.cs Project: annguyenbku/An

 public void UpdateCustomer(EC_Customer et)
 {
     cn.ImplementSQL(@"UPDATE CUSTOMER Set Name =N'" + et.Name + "', DateOfBirth =N'" + et.DOB + "', Sex =N'" + et.Sex + "', PhoneNumber =" + et.Phone + " where ID_CUSTOMER=N'" + et.Id + "'");
 }

Example #3

File: SQL_Member.cs Project: annguyenbku/An

 public void AddCustomer(EC_Customer et)
 {
     cn.ImplementSQL(@"INSERT INTO CUSTOMER (ID_CUSTOMER, Name, DateOfBirth, Sex, PhoneNumber) VALUES(N'" + et.Id + "',N'" + et.Name + "',N'" + et.DOB + "',N'" + et.Sex + "',N'" + et.Phone + "')");
 }

Example #4

 public void DeleteCustomer(EC_Customer et)
 {
     sql.DeleteCustomer(et);
 }

Example #5

 public void UpdateCustomer(EC_Customer et)
 {
     sql.UpdateCustomer(et);
 }

Example #6

 public void AddCustomer(EC_Customer et)
 {
     sql.AddCustomer(et);
 }