public KhachHang.Domain.KhachHang Execute() { KhachHang.Domain.KhachHang data = null; using (var conn = new SqlConnection(ConnectionString)) { using (var cmd = conn.CreateCommand()) { conn.Open(); cmd.CommandText = "SELECT * FROM KhachHang WHERE KhachhangId='" + item.KhachhangId + "'"; using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { data = new KhachHang.Domain.KhachHang { KhachhangId = Convert.ToString(reader["KhachhangId"]), Ho = Convert.ToString(reader["Ho"]), Tenlot = Convert.ToString(reader["Tenlot"]), Ten = Convert.ToString(reader["Ten"]), Gioitinh = Convert.ToBoolean(reader["Gioitinh"]), SDT = Convert.ToString(reader["SDT"]), Diachi = Convert.ToString(reader["Diachi"]) }; } } conn.Close(); } } return(data); }
public void Execute() { KhachHang.Domain.KhachHang check = null; using (var cmd = new KhachHangViewBusiness()) { cmd.item = item; check = cmd.Execute(); } if (check != null) // da co du lieu { using (var cmd = new KhachHangUpdateBusiness()) { cmd.item = item; cmd.Execute(); } } else { using (var cmd = new KhachHangAddRepository()) { cmd.item = item; cmd.Execute(); } } }