public static List <TransferOrderDetail> GetTransferOrderDetailAsList(DataTable dt)
{
List <TransferOrderDetail> oList = new List <TransferOrderDetail>();
foreach (DataRow row in dt.Rows)
{
try
{
TransferOrderDetail o = new TransferOrderDetail();
o.OrderNum = Helper.ConvertToInt(row["ORDER_NUM"].ToString());
o.OrderDetailNum = Helper.ConvertToInt(row["ORDER_DETAIL_NUM"]);
o.OrderGtin = row["ORDER_GTIN"].ToString();
o.OrderGtinLotnum = row["ORDER_GTIN_LOTNUM"].ToString();
o.OrderCustomItem = Helper.ConvertToBoolean(row["ORDER_CUSTOM_ITEM"]);
o.OrderDetailDescription = row["ORDER_DETAIL_DESCRIPTION"].ToString();
o.OrderQty = Helper.ConvertToDecimal(row["ORDER_QTY"]);
o.OrderUom = row["ORDER_UOM"].ToString();
o.OrderQtyInBaseUom = Helper.ConvertToDecimal(row["ORDER_QTY_IN_BASE_UOM"]);
o.OrderDetailStatus = Helper.ConvertToInt(row["ORDER_DETAIL_STATUS"]);
o.ModifiedOn = Helper.ConvertToDate(row["MODIFIED_ON"]);
o.ModifiedBy = Helper.ConvertToInt(row["MODIFIED_BY"]);
o.RevNum = Helper.ConvertToInt(row["REV_NUM"]);
oList.Add(o);
}
catch (Exception ex)
{
Log.InsertEntity("TransferOrderDetail", "GetTransferOrderDetailAsList", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
throw ex;
}
}
return(oList);
}
public static int Update(TransferOrderDetail o)
{
try
{
string query = @"UPDATE ""TRANSFER_ORDER_DETAIL"" SET ""ORDER_GTIN"" = @OrderGtin, ""ORDER_GTIN_LOTNUM"" = @OrderGtinLotnum, ""ORDER_CUSTOM_ITEM"" = @OrderCustomItem, ""ORDER_DETAIL_DESCRIPTION"" = @OrderDetailDescription, ""ORDER_QTY"" = @OrderQty, ""ORDER_UOM"" = @OrderUom, ""ORDER_QTY_IN_BASE_UOM"" = @OrderQtyInBaseUom, ""ORDER_DETAIL_STATUS"" = @OrderDetailStatus, ""MODIFIED_ON"" = @ModifiedOn, ""MODIFIED_BY"" = @ModifiedBy, ""REV_NUM"" = @RevNum WHERE ""ORDER_NUM"" = @OrderNum AND ""ORDER_DETAIL_NUM"" = @OrderDetailNum ";
List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@OrderNum", DbType.Int32)
{
Value = o.OrderNum
},
new NpgsqlParameter("@OrderDetailNum", DbType.Int32)
{
Value = o.OrderDetailNum
},
new NpgsqlParameter("@OrderGtin", DbType.String)
{
Value = o.OrderGtin
},
new NpgsqlParameter("@OrderGtinLotnum", DbType.String)
{
Value = (object)o.OrderGtinLotnum ?? DBNull.Value
},
new NpgsqlParameter("@OrderCustomItem", DbType.Boolean)
{
Value = (object)o.OrderCustomItem ?? DBNull.Value
},
new NpgsqlParameter("@OrderDetailDescription", DbType.String)
{
Value = (object)o.OrderDetailDescription ?? DBNull.Value
},
new NpgsqlParameter("@OrderQty", DbType.Double)
{
Value = o.OrderQty
},
new NpgsqlParameter("@OrderUom", DbType.String)
{
Value = (object)o.OrderUom ?? DBNull.Value
},
new NpgsqlParameter("@OrderQtyInBaseUom", DbType.Double)
{
Value = (object)o.OrderQtyInBaseUom ?? DBNull.Value
},
new NpgsqlParameter("@OrderDetailStatus", DbType.Int32)
{
Value = (object)o.OrderDetailStatus ?? DBNull.Value
},
new NpgsqlParameter("@ModifiedOn", DbType.Date)
{
Value = o.ModifiedOn
},
new NpgsqlParameter("@ModifiedBy", DbType.Int32)
{
Value = o.ModifiedBy
},
new NpgsqlParameter("@RevNum", DbType.Int32)
{
Value = o.RevNum
}
};
int rowAffected = DBManager.ExecuteNonQueryCommand(query, CommandType.Text, parameters);
AuditTable.InsertEntity("TransferOrderDetail", o.OrderNum.ToString() + " " + o.OrderDetailNum.ToString(), 2, DateTime.Now, o.ModifiedBy);
return(rowAffected);
}
catch (Exception ex)
{
Log.InsertEntity("TransferOrderDetail", "Update", 2, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
}
return(-1);
}
public static int Insert(TransferOrderDetail o)
{
try
{
string query = @"INSERT INTO ""TRANSFER_ORDER_DETAIL"" (""ORDER_NUM"", ""ORDER_GTIN"", ""ORDER_GTIN_LOTNUM"", ""ORDER_CUSTOM_ITEM"", ""ORDER_DETAIL_DESCRIPTION"", ""ORDER_QTY"", ""ORDER_UOM"", ""ORDER_QTY_IN_BASE_UOM"", ""ORDER_DETAIL_STATUS"", ""MODIFIED_ON"", ""MODIFIED_BY"", ""REV_NUM"")
VALUES (@OrderNum, @OrderGtin, @OrderGtinLotnum, @OrderCustomItem, @OrderDetailDescription, @OrderQty, @OrderUom, @OrderQtyInBaseUom, @OrderDetailStatus, @ModifiedOn, @ModifiedBy, @RevNum) returning ""ORDER_DETAIL_NUM"" ";
List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@OrderNum", DbType.Int32)
{
Value = o.OrderNum
},
//new NpgsqlParameter("@OrderDetailNum", DbType.Int32) { Value = o.OrderDetailNum },
new NpgsqlParameter("@OrderGtin", DbType.String)
{
Value = o.OrderGtin
},
new NpgsqlParameter("@OrderGtinLotnum", DbType.String)
{
Value = (object)o.OrderGtinLotnum ?? DBNull.Value
},
new NpgsqlParameter("@OrderCustomItem", DbType.Boolean)
{
Value = (object)o.OrderCustomItem ?? DBNull.Value
},
new NpgsqlParameter("@OrderDetailDescription", DbType.String)
{
Value = (object)o.OrderDetailDescription ?? DBNull.Value
},
new NpgsqlParameter("@OrderQty", DbType.Double)
{
Value = o.OrderQty
},
new NpgsqlParameter("@OrderUom", DbType.String)
{
Value = (object)o.OrderUom ?? DBNull.Value
},
new NpgsqlParameter("@OrderQtyInBaseUom", DbType.Double)
{
Value = (object)o.OrderQtyInBaseUom ?? DBNull.Value
},
new NpgsqlParameter("@OrderDetailStatus", DbType.Int32)
{
Value = (object)o.OrderDetailStatus ?? DBNull.Value
},
new NpgsqlParameter("@ModifiedOn", DbType.Date)
{
Value = o.ModifiedOn
},
new NpgsqlParameter("@ModifiedBy", DbType.Int32)
{
Value = o.ModifiedBy
},
new NpgsqlParameter("@RevNum", DbType.Int32)
{
Value = o.RevNum
}
};
object id = DBManager.ExecuteScalarCommand(query, CommandType.Text, parameters);
AuditTable.InsertEntity("TransferOrderDetail", id.ToString(), 1, DateTime.Now, o.ModifiedBy);
return(int.Parse(id.ToString()));
}
catch (Exception ex)
{
Log.InsertEntity("TransferOrderDetail", "Insert", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
}
return(-1);
}
