/// <summary>
/// Update the record.
/// </summary>
public static int Update(Payment payment, int payment_id)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_UPDATE);
command.Parameters.AddWithValue("@payment_id", payment_id);
command.Parameters.AddWithValue("@client_id", payment.client_id);
command.Parameters.AddWithValue("@price", payment.price);
command.Parameters.AddWithValue("@payment_status", payment.payment_status);
command.Parameters.AddWithValue("@order_id", payment.order_id);
int ret = db.ExecuteNonQuery(command);
db.Close();
Console.WriteLine("Executed");
return(ret);
}
public static int new_order(Orders order)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand("new_order");
command.CommandType = CommandType.StoredProcedure;
SqlParameter client = new SqlParameter();
client.ParameterName = "@client_id";
client.DbType = DbType.Int32;
client.Value = order.client_id;
client.Direction = ParameterDirection.Input;
command.Parameters.Add(client);
/*
* The analisys contains a mistake - there should not be a date of performing an action but
* start date of the order
* SELECT * FROM orders
* WHERE truck_plate=$available_truck.plate
* AND start_date-$current_date < 3
* AND start_date-$current_date >(-3)
*/
SqlParameter start_date = new SqlParameter();
start_date.ParameterName = "@start_date";
start_date.DbType = DbType.Date;
start_date.Value = order.start_date;
start_date.Direction = ParameterDirection.Input;
command.Parameters.Add(start_date);
SqlParameter route_id = new SqlParameter();
route_id.ParameterName = "@route_id";
route_id.DbType = DbType.Int32;
route_id.Value = order.route_id;
route_id.Direction = ParameterDirection.Input;
command.Parameters.Add(route_id);
SqlParameter width = new SqlParameter();
width.ParameterName = "@width";
width.DbType = DbType.Int32;
width.Value = order.width;
width.Direction = ParameterDirection.Input;
command.Parameters.Add(width);
SqlParameter height = new SqlParameter();
height.ParameterName = "@height";
height.DbType = DbType.Int32;
height.Value = order.height;
height.Direction = ParameterDirection.Input;
command.Parameters.Add(height);
SqlParameter description = new SqlParameter();
description.ParameterName = "@description";
description.DbType = DbType.String;
description.Value = order.load_description;
description.Direction = ParameterDirection.Input;
command.Parameters.Add(description);
// 4. execute procedure
int ret = db.ExecuteNonQuery(command);
//db.ExecuteNonQuery(command);
Console.WriteLine("Executed");
// 5. get values of the output parameters
//string result = command.Parameters["@result"].Value.ToString();
db.Close();
//Console.WriteLine("Executed");
return(ret);
}