public HttpResponseMessage GetDriverByID(string carrierkey)
{
// Data.carrier carrier = repo.GetbyId(Guid.Parse(carrierkey));
CarrierBO carrierBO = new CarrierBO();
carrierBO = DL.GetCarrierbyKey(Guid.Parse(carrierkey));
if (carrierBO != null)
{
var address = new AddressRepository().GetbyId(carrierBO.AddrKey);
carrierBO.Address = new AddressBO()
{
Address1 = address.address1,
Address2 = address.address2,
City = address.city,
State = address.state,
Zip = address.zipcode,
Email = address.email,
Phone = address.phone,
Fax = address.fax
};
return(Request.CreateResponse(HttpStatusCode.OK, carrierBO, Configuration.Formatters.JsonFormatter));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Not found", Configuration.Formatters.JsonFormatter));
}
}
// POST api/values
public HttpResponseMessage Post([FromBody] CarrierBO carrierBO)
{
CarrierBO carrierData = new CarrierBO();
carrierData = carrierBO;
carrierData.CarrierKey = Guid.NewGuid();
if (string.IsNullOrEmpty(carrierBO.LicensePlate))
{
carrierBO.LicensePlate = string.Empty;
}
carrierData.Status = 1;
carrierData.CreatedDate = DateTime.Now;
carrierData.StatusDate = DateTime.Now;
//Data.carrier _carrier = new Data.carrier();
//_carrier.carrierid = carrierBO.CarrierId;
//_carrier.carriername = carrierBO.CarrierName;
////_carrier.isstreamline = carrierBO.isstreamline;
//_carrier.scaccode = carrierBO.ScacCode;
//_carrier.createdate = DateTime.Now;
//_carrier.status = 1;
//_carrier.statusdate = DateTime.Now;
if (carrierBO.Address != null)
{
var custaddress = new Data.address()
{
address1 = carrierBO.Address.Address1,
address2 = carrierBO.Address.Address2,
city = carrierBO.Address.City,
state = carrierBO.Address.State,
country = carrierBO.Address.Country,
zipcode = carrierBO.Address.Zip,
email = carrierBO.Address.Email,
fax = carrierBO.Address.Fax,
//addrname = _carrier.carrierid
addrname = carrierBO.CarrierName
};
var addrkey = new AddressRepository().Add(custaddress);
//_carrier.addrkey = addrkey;
carrierData.AddrKey = addrkey;
}
//Guid brokerid = repo.Add(_carrier);
CarrierDL DL = new CarrierDL();
var carrierKey = DL.InsertCarrier(carrierData);
if (carrierKey != null && carrierKey != Guid.Empty)
{
return(Request.CreateResponse(HttpStatusCode.OK, carrierKey, Configuration.Formatters.JsonFormatter));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
public CarrierBO AddBroker(CarrierBO carrier)
{
carrier _carrier = new carrier();
_carrier.carriername = carrier.CarrierName;
if (carrier.Address != null)
{
_carrier.addrkey = carrier.Address.AddrKey;
}
_carrier.carrierid = carrier.CarrierId;
var carrierguid = repo.Add(_carrier);
carrier.CarrierKey = carrierguid;
return(carrier);
}
public CarrierBO GetCarrier(string carrierName)
{
var _carrierEntity = repo.GetbyField(carrierName);
if (_carrierEntity != null)
{
CarrierBO bo = new CarrierBO()
{
CarrierName = carrierName,
CarrierId = _carrierEntity.carrierid,
CarrierKey = _carrierEntity.carrierkey,
Address = new DeliveryOrderDL().GetAddress(_carrierEntity.addrkey)
};
return(bo);
}
return(null);
}
public CarrierBO GetCarrierbyKey(Guid carrierKey)
{
try
{
string sql = "dbo.fn_get_carrierbyKey";
CarrierBO carrierlist = new CarrierBO();
conn = new NpgsqlConnection(connString);
conn.Open();
using (var cmd = new NpgsqlCommand(sql, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("_carrierkey", NpgsqlTypes.NpgsqlDbType.Uuid, carrierKey);
var reader = cmd.ExecuteReader();
do
{
while (reader.Read())
{
carrierlist.CarrierKey = Guid.Parse(reader["carrierkey"].ToString());
carrierlist.CarrierId = Utils.CustomParse<string>(reader["carrierid"]);
carrierlist.CarrierName = Utils.CustomParse<string>(reader["carriername"]);
carrierlist.ScacCode = Utils.CustomParse<string>(reader["scaccode"]);
//carrierlist.isstreamline = Convert.ToBoolean(reader["issteamline"]);
carrierlist.LicensePlate = Utils.CustomParse<string>(reader["licenseplate"]);
carrierlist.LicensePlateExpiryDate = Utils.CustomParse<DateTime>(reader["licenseplateexpirydate"]);
carrierlist.AddrKey = Guid.Parse(reader["addrkey"].ToString());
}
}
while (reader.NextResult());
reader.Close();
}
return carrierlist;
}
catch (Exception msg)
{
throw msg;
}
finally
{
conn.Close();
}
}
public List<CarrierBO> GetCarriers()
{
try
{
string sql = "dbo.fn_get_carriers";
List<CarrierBO> carrierlist = new List<CarrierBO>();
List<string> list = new List<string>();
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 BO = new CarrierBO();
BO.CarrierKey = Guid.Parse(reader["carrierkey"].ToString());
BO.CarrierId = Utils.CustomParse<string>(reader["carrierid"]);
BO.CarrierName = Utils.CustomParse<string>(reader["carriername"]);
BO.AddrKey = Guid.Parse(reader["addrkey"].ToString());
BO.ScacCode = Utils.CustomParse<string>(reader["scaccode"]);
carrierlist.Add(BO);
}
}
while (reader.NextResult());
reader.Close();
}
return carrierlist;
}
catch (Exception msg)
{
throw msg;
}
finally
{
conn.Close();
}
}
public HttpResponseMessage Put([FromBody] CarrierBO carrierBO)
{
Data.carrier _carrier = new Data.carrier();
_carrier.carrierkey = carrierBO.CarrierKey;
_carrier.carrierid = carrierBO.CarrierId;
_carrier.carriername = carrierBO.CarrierName;
_carrier.licenseplate = carrierBO.LicensePlate;
_carrier.licenseplateexpirydate = carrierBO.LicensePlateExpiryDate;
_carrier.scaccode = carrierBO.ScacCode;
_carrier.addrkey = carrierBO.AddrKey;
if (carrierBO.Address != null)
{
var custaddress = new Data.address()
{
address1 = carrierBO.Address.Address1,
address2 = carrierBO.Address.Address2,
city = carrierBO.Address.City,
state = carrierBO.Address.State,
country = carrierBO.Address.Country,
zipcode = carrierBO.Address.Zip,
email = carrierBO.Address.Email,
fax = carrierBO.Address.Fax,
addrname = _carrier.carrierid,
addrkey = carrierBO.AddrKey
};
bool updated = new AddressRepository().Update(custaddress);
}
bool result = repo.Update(_carrier);
if (result)
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
public Guid InsertCarrier(CarrierBO carrier)
{
try
{
string sql = "dbo.fn_insert_carrier";
conn = new NpgsqlConnection(connString);
conn.Open();
NpgsqlTransaction tran = conn.BeginTransaction();
using (var cmd = new NpgsqlCommand(sql, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("_carrierkey", NpgsqlTypes.NpgsqlDbType.Uuid, carrier.CarrierKey);
cmd.Parameters.AddWithValue("_carrierid", NpgsqlTypes.NpgsqlDbType.Varchar, carrier.CarrierId);
cmd.Parameters.AddWithValue("_carriername", NpgsqlTypes.NpgsqlDbType.Varchar, carrier.CarrierName);
cmd.Parameters.AddWithValue("_issteamline", NpgsqlTypes.NpgsqlDbType.Bit, carrier.isstreamline);
cmd.Parameters.AddWithValue("_addrkey", NpgsqlTypes.NpgsqlDbType.Uuid, carrier.AddrKey);
cmd.Parameters.AddWithValue("_scaccode", NpgsqlTypes.NpgsqlDbType.Varchar, carrier.ScacCode);
cmd.Parameters.AddWithValue("_licenseplate", NpgsqlTypes.NpgsqlDbType.Varchar, carrier.LicensePlate);
cmd.Parameters.AddWithValue("_licenseplateexpirydate", NpgsqlTypes.NpgsqlDbType.Date, carrier.LicensePlateExpiryDate);
cmd.Parameters.AddWithValue("_status", NpgsqlTypes.NpgsqlDbType.Smallint, carrier.Status);
cmd.Parameters.AddWithValue("_createdate", NpgsqlTypes.NpgsqlDbType.Timestamp, carrier.CreatedDate);
cmd.Parameters.AddWithValue("_statusdate", NpgsqlTypes.NpgsqlDbType.Timestamp, carrier.StatusDate);
var carrierKey = cmd.ExecuteScalar();
tran.Commit();
return Guid.Parse(carrierKey.ToString());
}
}
catch (Exception msg)
{
throw msg;
}
finally
{
conn.Close();
}
}
