public int DeleteCustomer(Customer or) { _Cuservice = new CustomerService(); if (_Cuservice.Delete(or) == 1) return 1; else return 0; }
public int AddCustomer(Customer or) { _Cuservice = new CustomerService(); if (_Cuservice.Add(or) == 1) return 1; else return 0; }
public IQueryable<Customer> GetAll() { List<Customer> ls_cus = new List<Customer>(); string sqlcm = "Select * from Customers"; using (IDataReader dr = ConnectionClass.GetInstance().ExecuteReader(sqlcm)) { while (dr.Read()) { Customer _cus = new Customer(); _cus.CustomerID = dr.GetString(0); _cus.CompanyName = dr.GetString(1); _cus.ContactName = dr.GetString(2); _cus.ContactTitle = dr.GetString(3); _cus.Address = dr.GetString(4); _cus.City = dr.GetString(5); _cus.Region = dr.GetString(6); _cus.PostalCode = dr.GetString(7); _cus.Country = dr.GetString(8); _cus.Phone = dr.GetString(9); _cus.Fax = dr.GetString(10); ls_cus.Add(_cus); } dr.Close(); } return ls_cus.AsQueryable(); }
public int Delete(Customer _cus) { string sqlcm = "Delete from Customer where CustomerID=" + _cus.CustomerID; return ConnectionClass.GetInstance().ExecuteNonQuery(sqlcm); }
public int Update(Customer _cus) { string sqlcm = "update Customers set CompanyName='" + _cus.CompanyName + "',ContactName='" + _cus.ContactName + "',ContactTitle='" + _cus.ContactTitle + "',Address='" + _cus.Address + "',City='" + _cus.City + "',Region='" + _cus.Region + "',PosttalCode='" + _cus.PostalCode + "',Country='" + _cus.Country + "' where CustomerID=" + _cus.CustomerID; return ConnectionClass.GetInstance().ExecuteNonQuery(sqlcm); }
public int Add(Customer _cus) { string sqlcm = "insert into Customers(CustomerID,CompanyName,) values('" + _cus.CustomerID + "','" + _cus.CompanyName + "')"; return ConnectionClass.GetInstance().ExecuteNonQuery(sqlcm); }