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