public void CreatePaymentMethod(PaymentMethod pm)
{
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputNVarcharParameter("@name", 50, pm.Name)
};
string sql = "INSERT INTO payment_methods(name) VALUES(@name)";
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public static bool CreatePaymentMethod(PaymentMethod pm)
{
if (dal.GetPaymentMethodByName(pm.Name) != null)
{
return false;
}
dal.CreatePaymentMethod(pm);
return true;
}
public List<PaymentMethod> GetPaymentMethod()
{
List<PaymentMethod> result = new List<PaymentMethod>();
string sql = "SELECT id, name FROM payment_methods";
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, null))
{
while (dr.Read())
{
PaymentMethod pm = new PaymentMethod();
pm.Id = dr.GetInt32(0);
pm.Name = dr.GetString(1);
result.Add(pm);
}
}
return result;
}
public PaymentMethod GetPaymentMethodByName(string name)
{
PaymentMethod pm = null;
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputNVarcharParameter("@name", 50, name)
};
string sql = "SELECT id, name FROM payment_methods WHERE name = @name";
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
{
while (dr.Read())
{
pm = new PaymentMethod();
pm.Id = dr.GetInt32(0);
pm.Name = dr.GetString(1);
}
}
return pm;
}
public static void UpdatePaymentMethod(PaymentMethod pm)
{
dal.UpdatePaymentMethod(pm);
}
public void UpdatePaymentMethod(PaymentMethod pm)
{
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@id", pm.Id),
SqlUtilities.GenerateInputNVarcharParameter("@name", 50, pm.Name)
};
string sql = "UPDATE payment_methods SET name = @name WHERE id = @id";
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}