/// <summary> /// Get Customers /// </summary> /// <param name="message">return message</param> /// <returns>List of Customers</returns> public static List <Customer> GetCustomers(out string message) { try { DataTable dt; List <Customer> customers = new List <Customer>(); dt = DBCustomers.GetCustomers(out message); // ORM = Muutetaan datatablen rivit olioiksi Customer customer; foreach (DataRow row in dt.Rows) { customer = new Customer((int)row[0]); customer.FirstName = row[1].ToString(); customer.LastName = row[2].ToString(); customer.Address = row[3].ToString(); customer.ZIP = row[4].ToString(); customer.City = row[5].ToString(); customers.Add(customer); } // Palautus return(customers); } catch (Exception ex) { throw ex; } }
/// <summary> /// Delete Customer /// </summary> /// <param name="customer">Customer to Insert</param> /// <param name="message">return message</param> /// <returns>True id succeeded else false</returns> public static bool DeleteCustomer(Customer customer, out string message) { try { int c = DBCustomers.DeleteCustomer(customer.Id, out message); return(c > 0); } catch (Exception) { throw; } }
/// <summary> /// Update Customer /// </summary> /// <param name="customer">Customer to Update</param> /// <param name="message">return message</param> /// <returns>Count of affected rows in database</returns> public static int UpdateCustomer(Customer customer, out string message) { try { int c = DBCustomers.UpdateCustomer(customer, out message); return(c); } catch (Exception) { throw; } }