public static List <TransferOrderHeader> GetTransferOrderHeaderAsListForStatus(DataTable dt)
{
List <TransferOrderHeader> oList = new List <TransferOrderHeader>();
foreach (DataRow row in dt.Rows)
{
try
{
TransferOrderHeader o = new TransferOrderHeader();
o.OrderNum = Helper.ConvertToInt(row["ORDER_NUM"].ToString());
o.OrderSchedReplenishDate = Helper.ConvertToDate(row["ORDER_SCHED_REPLENISH_DATE"]);
o.OrderFacilityFrom = row["ORDER_FACILITY_FROM"].ToString();
o.OrderFacilityTo = row["ORDER_FACILITY_TO"].ToString();
o.OrderCarrier = row["ORDER_CARRIER"].ToString();
o.OrderStatusName = row["ORDER_STATUS"].ToString();
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("TransferOrderHeader", "GetTransferOrderHeaderAsList", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
throw ex;
}
}
return(oList);
}
public static int Update(TransferOrderHeader o)
{
try
{
string query = @"UPDATE ""TRANSFER_ORDER_HEADER"" SET ""ORDER_SCHED_REPLENISH_DATE"" = @OrderSchedReplenishDate, ""ORDER_FACILITY_FROM"" = @OrderFacilityFrom, ""ORDER_FACILITY_TO"" = @OrderFacilityTo, ""ORDER_CARRIER"" = @OrderCarrier, ""ORDER_STATUS"" = @OrderStatus, ""MODIFIED_ON"" = @ModifiedOn, ""MODIFIED_BY"" = @ModifiedBy, ""REV_NUM"" = @RevNum WHERE ""ORDER_NUM"" = @OrderNum ";
List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@OrderNum", DbType.Int32)
{
Value = o.OrderNum
},
new NpgsqlParameter("@OrderSchedReplenishDate", DbType.Date)
{
Value = o.OrderSchedReplenishDate
},
new NpgsqlParameter("@OrderFacilityFrom", DbType.String)
{
Value = o.OrderFacilityFrom
},
new NpgsqlParameter("@OrderFacilityTo", DbType.String)
{
Value = o.OrderFacilityTo
},
new NpgsqlParameter("@OrderCarrier", DbType.String)
{
Value = (object)o.OrderCarrier ?? DBNull.Value
},
new NpgsqlParameter("@OrderStatus", DbType.Int32)
{
Value = o.OrderStatus
},
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("TransferOrderHeader", o.OrderNum.ToString(), 2, DateTime.Now, o.ModifiedBy);
return(rowAffected);
}
catch (Exception ex)
{
Log.InsertEntity("TransferOrderHeader", "Update", 2, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
}
return(-1);
}
public static int Insert(TransferOrderHeader o)
{
try
{
string query = @"INSERT INTO ""TRANSFER_ORDER_HEADER"" (""ORDER_SCHED_REPLENISH_DATE"", ""ORDER_FACILITY_FROM"", ""ORDER_FACILITY_TO"", ""ORDER_CARRIER"", ""ORDER_STATUS"", ""MODIFIED_ON"", ""MODIFIED_BY"", ""REV_NUM"") VALUES (@OrderSchedReplenishDate, @OrderFacilityFrom, @OrderFacilityTo, @OrderCarrier, @OrderStatus, @ModifiedOn, @ModifiedBy, @RevNum) returning ""ORDER_NUM"" ";
List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>()
{
//new NpgsqlParameter("@OrderNum", DbType.Int32) { Value = o.OrderNum },
new NpgsqlParameter("@OrderSchedReplenishDate", DbType.Date)
{
Value = o.OrderSchedReplenishDate
},
new NpgsqlParameter("@OrderFacilityFrom", DbType.String)
{
Value = o.OrderFacilityFrom
},
new NpgsqlParameter("@OrderFacilityTo", DbType.String)
{
Value = o.OrderFacilityTo
},
new NpgsqlParameter("@OrderCarrier", DbType.String)
{
Value = (object)o.OrderCarrier ?? DBNull.Value
},
new NpgsqlParameter("@OrderStatus", DbType.Int32)
{
Value = o.OrderStatus
},
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("TransferOrderHeader", id.ToString(), 1, DateTime.Now, o.ModifiedBy);
return(int.Parse(id.ToString()));
}
catch (Exception ex)
{
Log.InsertEntity("TransferOrderHeader", "Insert", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
}
return(-1);
}