/// <summary> /// GetByAddress /// Calls [usp_select_CompanyAddress_by_Address] /// </summary> public override CompanyAddressDetails GetByAddress(System.Int32?addressId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_CompanyAddress_by_Address", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@AddressId", SqlDbType.Int).Value = addressId; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetCompanyAddressFromReader(reader); CompanyAddressDetails obj = new CompanyAddressDetails(); obj.CompanyAddressId = GetReaderValue_Int32(reader, "CompanyAddressId", 0); obj.CompanyNo = GetReaderValue_Int32(reader, "CompanyNo", 0); obj.AddressNo = GetReaderValue_Int32(reader, "AddressNo", 0); obj.CeaseDate = GetReaderValue_NullableDateTime(reader, "CeaseDate", null); obj.ShipViaNo = GetReaderValue_NullableInt32(reader, "ShipViaNo", null); obj.ShipViaAccount = GetReaderValue_String(reader, "ShipViaAccount", ""); obj.Notes = GetReaderValue_String(reader, "Notes", ""); obj.TaxbyAddress = GetReaderValue_NullableInt32(reader, "TaxbyAddress", null); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); obj.DefaultBilling = GetReaderValue_Boolean(reader, "DefaultBilling", false); obj.DefaultShipping = GetReaderValue_Boolean(reader, "DefaultShipping", false); obj.ShippingNotes = GetReaderValue_String(reader, "ShippingNotes", ""); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get CompanyAddress", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
private static CompanyAddress PopulateFromDBDetailsObject(CompanyAddressDetails obj) { CompanyAddress objNew = new CompanyAddress(); objNew.CompanyAddressId = obj.CompanyAddressId; objNew.CompanyNo = obj.CompanyNo; objNew.AddressNo = obj.AddressNo; objNew.CeaseDate = obj.CeaseDate; objNew.ShipViaNo = obj.ShipViaNo; objNew.ShipViaAccount = obj.ShipViaAccount; objNew.Notes = obj.Notes; objNew.UpdatedBy = obj.UpdatedBy; // ESMS #14 objNew.TaxbyAddress = obj.TaxbyAddress; //end objNew.DLUP = obj.DLUP; objNew.DefaultBilling = obj.DefaultBilling; objNew.DefaultShipping = obj.DefaultShipping; objNew.ShippingNotes = obj.ShippingNotes; return(objNew); }