public static bool CreateOrder_Line(Order_Line order_Line, out string status, out int id)
{
status = DataConnection.status;
DataConnection.command.CommandText =
"INSERT INTO Order_Line(orlPrice, orlQuantity, orlOrderReq, orlNote, inventoryID, receiptID) " +
"OUTPUT INSERTED.ID " +
"VALUES(" +
"'" + order_Line.orlPrice + "', " +
"'" + order_Line.orlQuantity + "', " +
"'" + order_Line.orlOrderReq + "', " +
"'" + order_Line.orlNote + "', " +
"'" + order_Line.inventoryID + "', " +
"'" + order_Line.receiptID + "' " +
")";
if (DataConnection.Open())
{
try
{
id = (int)DataConnection.command.ExecuteScalar();
status = "Insert successful";
DataConnection.Close();
return(true);
}
catch (Exception e)
{
status = "Insert failed\n" + e.Message;
}
}
DataConnection.Close();
id = 0;
return(false);
}
public static List <Order_Line> GetAllOrder_Lines(out string status)
{
status = DataConnection.status;
List <Order_Line> order_Lines = new List <Order_Line>();
DataConnection.command.CommandText = "Select * From Order_Line";
if (DataConnection.Open())
{
try
{
SqlDataReader reader = DataConnection.command.ExecuteReader();
while (reader.Read())
{
Order_Line orderLine = new Order_Line(Convert.ToInt32(reader[0]));
orderLine.orlPrice = Convert.ToDecimal(reader[1]);
orderLine.orlQuantity = Convert.ToInt32(reader[2]);
orderLine.orlOrderReq = Convert.ToBoolean(reader[3]);
orderLine.orlNote = reader[4].ToString();
orderLine.inventoryID = Convert.ToInt32(reader[5]);
orderLine.receiptID = Convert.ToInt32(reader[6]);
order_Lines.Add(orderLine);
}
status = "Records Found";
}
catch (Exception ex)
{
status = "Command Failed\n" + ex.Message;
}
finally
{
DataConnection.Close();
}
}
return(order_Lines);
}
public static bool UpdateOrder_Line(Order_Line order_Line, out string status)
{
status = DataConnection.status;
DataConnection.command.CommandText =
"UPDATE Order_Line SET orlPrice '" + order_Line.orlPrice + "', " +
"orlQuantity = '" + order_Line.orlQuantity + "', " +
"orlOrderReq = '" + order_Line.orlOrderReq + "', " +
"orlNote = '" + order_Line.orlNote + "', " +
"inventoryID = '" + order_Line.inventoryID + "', " +
"receiptID = '" + order_Line.receiptID + "' " +
"WHERE ID = '" + order_Line.id.ToString();
if (DataConnection.Open())
{
try
{
DataConnection.command.ExecuteNonQuery();
status = "Update successful";
DataConnection.Close();
return(true);
}
catch (Exception e)
{
status = "Update failed\n" + e.Message;
}
}
DataConnection.Close();
return(false);
}
public static bool Order_LineDelete(Order_Line order_Line, out string status)
{
status = DataConnection.status;
DataConnection.command.CommandText = "DELETE FROM Order_Line WHERE id = " + order_Line.id.ToString();
if (DataConnection.Open())
{
try
{
DataConnection.command.ExecuteNonQuery();
status = "Delete successful";
DataConnection.Close();
return(true);
}
catch (Exception e)
{
status = "Delete failed\n" + e.Message;
}
}
DataConnection.Close();
return(false);
}