public DeliveryOrderBO getOrderDatabyKey(string orderkey)
{
DeliveryOrderBO bo = new DeliveryOrderBO();
var data = repo.getOrderDatabyKey(orderkey);
return(data);
}
public List <DeliveryOrderBO> GetDispatchItemsList()
{
try
{
string sql = "dbo.fn_get_dispatchitems";
List <DeliveryOrderBO> orderData = new List <DeliveryOrderBO>();
conn = new NpgsqlConnection(connString);
conn.Open();
using (var cmd = new NpgsqlCommand(sql, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
var reader = cmd.ExecuteReader();
do
{
while (reader.Read())
{
var order = new DeliveryOrderBO();
order.OrderDetails = new DeliveryOrderDetailBO();
order.OrderNo = Utils.CustomParse <string>(reader["orderno"]);
order.OrderKey = Utils.CustomParse <Guid>(reader["orderkey"]);
order.OrderDate = Utils.CustomParse <DateTime>(reader["orderdate"]);
order.OrderDetails.OrderDetailKey = Utils.CustomParse <Guid>(reader["orderdetailkey"]);
order.OrderDetails.containerid = Utils.CustomParse <string>(reader["containerid"]);
order.OrderDetails.ContainerNo = Utils.CustomParse <string>(reader["containerno"]);
order.OrderDetails.ContainerSize = Utils.CustomParse <short>(reader["containersize"]);
order.OrderDetails.ContainerSizeDesc = Utils.CustomParse <string>(reader["containersizeDesc"]);
order.OrderDetails.Chassis = Utils.CustomParse <string>(reader["chassis"]);
order.OrderDetails.SealNo = Utils.CustomParse <string>(reader["sealno"]);
order.OrderDetails.Weight = Utils.CustomParse <string>(reader["weight"]);
order.OrderDetails.AppDateFrom = Utils.CustomParse <DateTime>(reader["apptdatefrom"]);
order.OrderDetails.AppDateTo = Utils.CustomParse <DateTime>(reader["apptdateto"]);
//order.OrderDetails.PickupDateTime = Utils.CustomParse<string>(reader["scheduledarrival"]);
//order.OrderDetails.DropOffDateTime = Utils.CustomParse<string>(reader["scheduleddeparture"]);
order.OrderDetails.LastFreeDay = Utils.CustomParse <DateTime>(reader["LastFreeDay"]);
order.OrderDetails.SchedulerNotes = Utils.CustomParse <string>(reader["schedulernotes"]);
order.OrderDetails.StatusDesc = Utils.CustomParse <string>(reader["status"]);
orderData.Add(order);
}
}while (reader.NextResult());
reader.Close();
}
return(orderData);
}
catch (Exception msg)
{
throw msg;
}
finally
{
conn.Close();
}
}
public HttpResponseMessage UpdateBrokerRefNo([FromBody] DeliveryOrderBO obj)
{
bool isUpdated = doObj.UpdateBrokerRefNo(obj);
if (!isUpdated)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Not Updated", Configuration.Formatters.JsonFormatter));
}
return(Request.CreateResponse(HttpStatusCode.OK, isUpdated, Configuration.Formatters.JsonFormatter));
}
public HttpResponseMessage GetbyKey(string OrderKey)
{
DeliveryOrderBO dorder = new DeliveryOrderBO();
DocumentDL dl = new DocumentDL();
dorder = doObj.GetDeliveryOrder(OrderKey);
if (dorder.OrderNo.ToString().Trim() != string.Empty)
{
List <DocumentBO> list = dl.GetSupportingDocuments(dorder.OrderNo).ToList();
dorder.file = list;
}
return(Request.CreateResponse(HttpStatusCode.OK, dorder, Configuration.Formatters.JsonFormatter));
}
public HttpResponseMessage Post([FromBody] DeliveryOrderBO obj)
{
var orderid = doObj.CreateDeliveryOrder(obj);
//if (orderid != Guid.Empty)
//{
// if (!String.IsNullOrEmpty(obj.Comment))
// {
// obj.commentBO = new CommentBO();
// obj.commentBO.createuserkey = obj.CreatedBy;
// obj.commentBO.description = obj.Comment;
// var commentkey = doObj.CreateComment(obj.OrderKey, obj.commentBO);
// if (commentkey != Guid.Empty)
// {
// doObj.CreateOrderHeaderComment(obj.OrderKey, commentkey, 0);
// }
// }
//}
return(Request.CreateResponse(HttpStatusCode.OK, orderid, Configuration.Formatters.JsonFormatter));
}
public DeliveryOrderBO getOrderDatabyKey(string orderkey)
{
try
{
string sql = "dbo.fn_get_orderheaderbykey";
DeliveryOrderBO bo = new DeliveryOrderBO();
AddressDL DL = new AddressDL();
conn = new NpgsqlConnection(connString);
conn.Open();
using (var cmd = new NpgsqlCommand(sql, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("_orderkey",
NpgsqlTypes.NpgsqlDbType.Uuid, Guid.Parse(orderkey));
var reader = cmd.ExecuteReader();
while (reader.Read())
{
bo.OrderKey = Utils.CustomParse <Guid>(reader["orderkey"]);
bo.OrderNo = reader["orderno"].ToString();
var dateAndTime = Convert.ToDateTime(reader["orderdate"].ToString()).ToString("MM/dd/yyyy");
bo.OrderDate = Convert.ToDateTime(reader["orderdate"]);
//bo.OrderDate = Convert.ToDateTime(reader["orderdate"].ToString());
bo.CustKey = Guid.Parse(reader["custkey"].ToString());
bo.BillToAddress = Utils.CustomParse <Guid>(reader["billtoaddress"]);
bo.BillToAddr = Utils.CustomParse <string>(reader["billtoaddr"]);
bo.SourceAddress = Utils.CustomParse <Guid>(reader["sourceaddress"]);
bo.SourceAddr = Utils.CustomParse <string>(reader["sourceaddr"]);
bo.DestinationAddress = Utils.CustomParse <Guid>(reader["destinationaddress"]);
bo.DestinationAddr = Utils.CustomParse <string>(reader["destinationaddr"]);
bo.ReturnAddress = Utils.CustomParse <Guid>(reader["returnaddress"]);
bo.OrderType = Utils.CustomParse <short>(reader["ordertype"]);
bo.Status = Utils.CustomParse <short>(reader["status"]);
//bo.StatusDate = Convert.ToDateTime(reader["statusdate"]);
bo.HoldReason = Utils.CustomParse <short>(reader["holdreason"]);
//bo.HoldDate = Convert.ToDateTime(reader["holdDate"]);
//bo.Brokerkey = Utils.CustomParse<Guid>(reader["brokerkey"]);
bo.BrokerName = reader["brokername"].ToString();
bo.BrokerId = reader["brokerid"].ToString();
bo.BrokerRefNo = reader["brokerrefno"].ToString();
bo.PortofOriginKey = Utils.CustomParse <Guid>(reader["portoforiginkey"]);
// bo.PortofDestinationKey = Utils.CustomParse<Guid>(reader["portofdestinationkey"]);
bo.CarrierKey = Utils.CustomParse <Guid>(reader["carrierkey"]);
bo.VesselName = reader["vesselname"].ToString();
bo.BillofLading = reader["billoflading"].ToString();
bo.BookingNo = reader["bookingno"].ToString();
//bo.CutOffDate = Utils.CustomParse<string>(reader["cutoffdate"]);
//bo.CutOffDate = Convert.ToDateTime(reader["cutoffdate"]);
//bo.IsHazardous = Utils.CustomParse<bool>(reader["ishazardous"]);
//bo.Priority = Utils.CustomParse<short>(reader["priority"]);
bo.CreatedDate = Convert.ToDateTime(reader["createdate"]);
bo.CreatedBy = Utils.CustomParse <Guid>(reader["createuserkey"]);
bo.Comment = Utils.CustomParse <string>(reader["commentdesc"]);
bo.statusdescription = reader["statusdescription"].ToString();
bo.ordertypedescription = reader["ordertypedescription"].ToString();
bo.BillToAddressBO = DL.GetAddressByKey(bo.BillToAddress);
//bo.BrokerAddressBO = GetAddress(bo.Brokerkey);
bo.ReturnAddressBO = DL.GetAddressByKey(bo.ReturnAddress);
bo.SourceAddressBO = DL.GetAddressByKey(bo.SourceAddress);
bo.DestinationAddressBO = DL.GetAddressByKey(bo.DestinationAddress);
}
reader.Close();
return(bo);
}
}
catch (Exception msg)
{
throw msg;
}
finally
{
conn.Close();
}
}
public List <DeliveryOrderBO> GetOrderstoGenerateInvoice()
{
try
{
var DOHeaders = new List <DeliveryOrderBO>();
// string sql = "dbo.fn_GetOrderstoGenerateInvoice";
string sql = "dbo.fn_get_orderstogenerateinvoice";
DeliveryOrderBO bo = new DeliveryOrderBO();
conn = new NpgsqlConnection(connString);
conn.Open();
using (var cmd = new NpgsqlCommand(sql, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
var reader = cmd.ExecuteReader();
do
{
while (reader.Read())
{
var orderHeader = new DeliveryOrderBO();
orderHeader.OrderDetails = new DeliveryOrderDetailBO();
orderHeader.OrderKey = Utils.CustomParse <Guid>(reader["orderkey"]);
orderHeader.OrderNo = Utils.CustomParse <string>(reader["orderno"]);
orderHeader.OrderDate = Convert.ToDateTime(reader["orderdate"].ToString());
//orderHeader.OrderType = Utils.CustomParse<short>(reader["ordertype"]);
//orderHeader.BrokerRefNo = Utils.CustomParse<string>(reader["brokerrefno"]);
//orderHeader.CustKey = Guid.Parse(reader["custkey"].ToString());
//orderHeader.BillToAddress = Utils.CustomParse<Guid>(reader["billtoaddrkey"]);
//orderHeader.SourceAddress = Utils.CustomParse<Guid>(reader["sourceaddrkey"]);
//orderHeader.DestinationAddress = Utils.CustomParse<Guid>(reader["destinationaddrkey"]);
//orderHeader.ReturnAddress = Utils.CustomParse<Guid>(reader["returnaddrkey"]);
//orderHeader.Status = Utils.CustomParse<short>(reader["status"]);
//orderHeader.StatusDate = Convert.ToDateTime(reader["statusdate"]);
//orderHeader.HoldReason = Utils.CustomParse<short>(reader["holdreason"]);
//orderHeader.Brokerkey = Utils.CustomParse<Guid>(reader["brokerkey"]);
//orderHeader.PortofOriginKey = Utils.CustomParse<Guid>(reader["portoforiginkey"]);
//orderHeader.PortofDestinationKey = Utils.CustomParse<Guid>(reader["portofdestinationkey"]);
//orderHeader.CarrierKey = Utils.CustomParse<Guid>(reader["carrierkey"]);
//orderHeader.VesselName = reader["vesselname"].ToString();
//orderHeader.BillofLading = reader["billoflading"].ToString();
//orderHeader.BookingNo = reader["bookingno"].ToString();
//orderHeader.CutOffDate = Convert.ToDateTime(reader["cutoffdate"]);
//orderHeader.Carrier = reader["carrier"].ToString();
////orderHeader.ordertypedescription = reader["ordertypedescription"].ToString();
//orderHeader.OrderDetails.OrderDetailKey = Utils.CustomParse<Guid>(reader["orderdetailkey"]);
//orderHeader.OrderDetails.ContainerNo = Utils.CustomParse<string>(reader["containerNo"]);
//orderHeader.OrderDetails.ContainerSizeDesc = Utils.CustomParse<string>(reader["containerSizeDesc"]);
//orderHeader.OrderDetails.ContainerSize = Utils.CustomParse<short>(reader["containerSize"]);
//orderHeader.OrderDetails.Chassis = Utils.CustomParse<string>(reader["chassis"]);
//orderHeader.OrderDetails.SealNo = Utils.CustomParse<string>(reader["sealNo"]);
DOHeaders.Add(orderHeader);
}
} while (reader.NextResult());
reader.Close();
}
return(DOHeaders);
}
catch (Exception msg)
{
throw msg;
}
finally
{
conn.Close();
}
}
public List <DeliveryOrderBO> GetDispatch_OrderandDetails(Guid orderdetailkey)
{
try
{
string sql = "dbo.fn_get_dispatchitems";
List <DeliveryOrderBO> orderData = new List <DeliveryOrderBO>();
conn = new NpgsqlConnection(connString);
conn.Open();
using (var cmd = new NpgsqlCommand(sql, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("_orderdetailkey", NpgsqlTypes.NpgsqlDbType.Uuid, orderdetailkey);
var reader = cmd.ExecuteReader();
do
{
while (reader.Read())
{
var order = new DeliveryOrderBO();
order.OrderDetails = new DeliveryOrderDetailBO();
order.OrderNo = Utils.CustomParse <string>(reader["orderno"]);
order.OrderKey = Utils.CustomParse <Guid>(reader["orderkey"]);
order.OrderDate = Utils.CustomParse <DateTime>(reader["orderdate"]);
order.BillToAddress = Utils.CustomParse <Guid>(reader["billingAddress"]);
order.SourceAddress = Utils.CustomParse <Guid>(reader["sourceaddress"]);
order.DestinationAddress = Utils.CustomParse <Guid>(reader["destinationaddress"]);
order.ReturnAddress = Utils.CustomParse <Guid>(reader["returnaddress"]);
order.BillToAddr = Utils.CustomParse <string>(reader["billtoaddr"]);
order.SourceAddr = Utils.CustomParse <string>(reader["sourceaddr"]);
order.DestinationAddr = Utils.CustomParse <string>(reader["destinationaddr"]);
order.OrderDetails.OrderDetailKey = Utils.CustomParse <Guid>(reader["orderdetailkey"]);
order.OrderDetails.containerid = Utils.CustomParse <string>(reader["containerid"]);
order.OrderDetails.ContainerNo = Utils.CustomParse <string>(reader["containerno"]);
order.OrderDetails.ContainerSize = Utils.CustomParse <short>(reader["containersize"]);
order.OrderDetails.ContainerSizeDesc = Utils.CustomParse <string>(reader["containersizeDesc"]);
order.OrderDetails.Chassis = Utils.CustomParse <string>(reader["chassis"]);
order.OrderDetails.SealNo = Utils.CustomParse <string>(reader["sealno"]);
order.OrderDetails.Weight = Utils.CustomParse <string>(reader["weight"]);
order.OrderDetails.AppDateFrom = Utils.CustomParse <DateTime>(reader["apptdatefrom"]);
order.OrderDetails.AppDateTo = Utils.CustomParse <DateTime>(reader["apptdateto"]);
//order.OrderDetails.PickupDateTime = Utils.CustomParse<string>(reader["scheduledarrival"]);
//order.OrderDetails.DropOffDateTime = Utils.CustomParse<string>(reader["scheduleddeparture"]);
order.OrderDetails.LastFreeDay = Utils.CustomParse <DateTime>(reader["LastFreeDay"]);
order.OrderDetails.SchedulerNotes = Utils.CustomParse <string>(reader["schedulernotes"]);
order.BillToAddressBO = GetAddress(order.BillToAddress);
//bo.BrokerAddressBO = GetAddress(bo.Brokerkey);
order.ReturnAddressBO = GetAddress(order.ReturnAddress);
order.SourceAddressBO = GetAddress(order.SourceAddress);
order.DestinationAddressBO = GetAddress(order.DestinationAddress);
orderData.Add(order);
}
}while (reader.NextResult());
reader.Close();
}
return(orderData);
}
catch (Exception msg)
{
throw msg;
}
finally
{
conn.Close();
}
}
public HttpResponseMessage UpdateOrder([FromBody] DeliveryOrderBO obj)
{
bool result = doObj.UpdateOrderHeader(obj);
return(Request.CreateResponse(HttpStatusCode.OK, result, Configuration.Formatters.JsonFormatter));
}
