protected void typeSaveButton_Click(object sender, EventArgs e)
{
Type type = new Type();
if (typeTextBox.Text == "")
{
ShowMessage("Please enter type name", MessageType.Error);
}
else
{
type.TypeName = typeTextBox.Text;
string msg = typeManager.Save(type);
if (msg.StartsWith("Success"))
{
showTypeList();
ShowMessage("Type name saved.", MessageType.Success);
typeTextBox.Text = string.Empty;
}
else
{
ShowMessage(msg, MessageType.Error);
}
}
}
public List <Type> GetAllTypes()
{
List <Type> typeList = new List <Type>();
SqlConnection connection = new SqlConnection(connectionString);
//query
string query = "SELECT * FROM Types ORDER BY TypeName";
//execute
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows) // if table has list of products(product rows) or not
{
while (reader.Read()) //then continue its reading for each row
{
Type aType = new Type();
aType.TypeId = Convert.ToInt32(reader["TypeID"]);
aType.TypeName = reader["TypeName"].ToString();
typeList.Add(aType); // add types on list
}
}
reader.Close();
connection.Close();
return(typeList);
}
public int SaveType(Type type)
{
//connection
SqlConnection connection = new SqlConnection(connectionString);
//query
string query = "INSERT INTO Types (TypeName) VALUES('" + type.TypeName + "')";
//execute
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
return(rowAffected);
}
public string Save(Type type)
{
if (type.TypeName.Length < 3)
{
return("Name must be 3 charcters long");
}
if (typeGateway.IsTypeExist(type.TypeName))
{
return("Already exist");
}
int rowAffected = typeGateway.SaveType(type);
if (rowAffected > 0)
{
return("Success");
}
return("Not save.");
}
