public static bool WriteToDatabase(IList Codes, string PONumber, string ValidFrom, string ValidTo)
{
if (Codes.Count < 1 || String.IsNullOrEmpty(PONumber))
{
return false;
}
string sql = "INSERT INTO gift_codes (code, customerPO, validFrom, validTo) values (@code, @po, @from, @to)";
string code = "";
MySqlCommand cmd = new MySqlCommand(sql, Conn);
cmd.Parameters.AddWithValue("@po", PONumber);
cmd.Parameters.AddWithValue("@from", ValidFrom);
cmd.Parameters.AddWithValue("@to", ValidTo);
cmd.Parameters.AddWithValue("@code", code);
cmd.Prepare();
for (int i = 0; i < Codes.Count; i++)
{
code = Codes[i].ToString();
cmd.ExecuteNonQuery();
}
return true;
}
public static bool WriteToDatabase(IList Codes, string PONumber, string ValidFrom, string ValidTo)
{
if (Codes.Count < 1)
{
return false;
}
if (String.IsNullOrEmpty(PONumber))
{
return false;
}
string sql = "INSERT INTO gift_codes (code, customerPO, validFrom, validTo) values (@code, @po, @from, @to)";
MySqlCommand cmd = new MySqlCommand(sql, Conn);
cmd.Parameters.AddWithValue("@code", "");
cmd.Parameters.AddWithValue("@po", PONumber);
cmd.Parameters.AddWithValue("@from", ValidFrom);
cmd.Parameters.AddWithValue("@to", ValidTo);
cmd.Prepare();
for (int i = 0; i < Codes.Count; i++)
{
MySqlParameter code = new MySqlParameter
{
Value = Codes[i].ToString()
};
cmd.Parameters[0] = code;
cmd.ExecuteNonQuery();
}
return true;
}
public static bool WriteToDatabase(IList Codes, string PONumber, string ValidFrom, string ValidTo)
{
if (Codes.Count < 1 || String.IsNullOrEmpty(PONumber))
{
return false;
}
string sql = "INSERT INTO gift_codes (code, customerPO, validFrom, validTo) values (@code, @po, @from, @to)";
string code = "";
MySqlCommand cmd = new MySqlCommand(sql, Conn);
cmd.Parameters.AddWithValue("@po", PONumber);
cmd.Parameters.AddWithValue("@from", ValidFrom);
cmd.Parameters.AddWithValue("@to", ValidTo);
cmd.Parameters.AddWithValue("@code", code);
cmd.Prepare();
for (int i = 0; i < Codes.Count; i++)
{
code = Codes[i].ToString();
cmd.Parameters[3].Value = code;
cmd.ExecuteNonQuery();
}
return true;
}
Open in new window