public string SaveProduct(Product aProduct)
{
connection.Open();
string query = string.Format("INSERT INTO t_product VALUES('{0}','{1}',{2})", aProduct.Code, aProduct.Name,
aProduct.Quantity);
SqlCommand command = new SqlCommand(query, connection);
int affectedRows = command.ExecuteNonQuery();
connection.Close();
if (affectedRows > 0)
return "insert success";
return "Product Code must be will in 3 Character and name in 5 Character!";
}
public string SaveProduct(Product aProduct)
{
if (aProduct.Code == string.Empty || aProduct.Name == string.Empty )
{
return "Fill up all fields first.";
}
if (aProduct.Code.Length > 3 && aProduct.Code.Length < 3)
{
return "Need 3 Characters Only";
}
if (aProduct.Name.Length < 10 && aProduct.Name.Length > 5)
{
return "Need 5 Characters Only";
}
if (HasThisCode(aProduct.Code) || HasThisName(aProduct.Name))
{
return "Code Or Name already included.";
}
return aProductGateway.SaveProduct(aProduct);
}
public List<Product> ShowProducts()
{
connection.Open();
string query = string.Format("SELECT * FROM t_product");
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader aReader = command.ExecuteReader();
List<Product> products = new List<Product>();
if (aReader.HasRows)
{
while (aReader.Read())
{
Product aProduct = new Product();
aProduct.Code = (string) aReader[0];
aProduct.Name = (string) aReader[1];
aProduct.Quantity = (int) aReader[2];
products.Add(aProduct);
}
}
connection.Close();
return products;
}