public static int Update(OrderLines o) { try { string query = @"UPDATE ""ORDER_LINES"" SET ""ID"" = @Id, ""ORDER_ID"" = @OrderId, ""ITEM_ID"" = @ItemId, ""QUANTITY"" = @Quantity WHERE ""ID"" = @Id "; List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>() { new NpgsqlParameter("@OrderId", DbType.Int32) { Value = o.OrderId }, new NpgsqlParameter("@ItemId", DbType.Int32) { Value = o.ItemId }, new NpgsqlParameter("@Quantity", DbType.Int32) { Value = o.Quantity }, new NpgsqlParameter("@Id", DbType.Int32) { Value = o.Id } }; int rowAffected = DBManager.ExecuteNonQueryCommand(query, CommandType.Text, parameters); AuditTable.InsertEntity("OrderLines", o.Id.ToString(), 2, DateTime.Now, 1); return(rowAffected); } catch (Exception ex) { Log.InsertEntity("OrderLines", "Update", 2, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", "")); } return(-1); }
public static int Insert(OrderLines o) { try { string query = @"INSERT INTO ""ORDER_LINES"" (""ORDER_ID"", ""ITEM_ID"", ""QUANTITY"") VALUES (@OrderId, @ItemId, @Quantity) returning ""ID"" "; List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>() { new NpgsqlParameter("@OrderId", DbType.Int32) { Value = o.OrderId }, new NpgsqlParameter("@ItemId", DbType.Int32) { Value = o.ItemId }, new NpgsqlParameter("@Quantity", DbType.Int32) { Value = o.Quantity } }; object id = DBManager.ExecuteScalarCommand(query, CommandType.Text, parameters); AuditTable.InsertEntity("OrderLines", id.ToString(), 1, DateTime.Now, 1); return(int.Parse(id.ToString())); } catch (Exception ex) { Log.InsertEntity("OrderLines", "Insert", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", "")); } return(-1); }
public static OrderLines GetOrderLinesAsObject(DataTable dt) { foreach (DataRow row in dt.Rows) { try { OrderLines o = new OrderLines(); o.Id = Helper.ConvertToInt(row["ID"]); o.OrderId = Helper.ConvertToInt(row["ORDER_ID"]); o.ItemId = Helper.ConvertToInt(row["ITEM_ID"]); o.Quantity = Helper.ConvertToInt(row["QUANTITY"]); return(o); } catch (Exception ex) { Log.InsertEntity("OrderLines", "GetOrderLinesAsObject", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", "")); throw ex; } } return(null); }