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); }