/// <summary> /// DropDownForClient /// Calls [usp_dropdown_ShipVia_for_Client] /// </summary> public override List <ShipViaDetails> DropDownForClient(System.Int32?clientId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_dropdown_ShipVia_for_Client", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId; cn.Open(); DbDataReader reader = ExecuteReader(cmd); List <ShipViaDetails> lst = new List <ShipViaDetails>(); while (reader.Read()) { ShipViaDetails obj = new ShipViaDetails(); obj.ShipViaId = GetReaderValue_Int32(reader, "ShipViaId", 0); obj.ShipViaName = GetReaderValue_String(reader, "ShipViaName", ""); lst.Add(obj); obj = null; } return(lst); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get ShipVias", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// Get /// Calls [usp_select_ShipVia] /// </summary> public override ShipViaDetails Get(System.Int32?shipViaId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_select_ShipVia", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@ShipViaId", SqlDbType.Int).Value = shipViaId; cn.Open(); DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow); if (reader.Read()) { //return GetShipViaFromReader(reader); ShipViaDetails obj = new ShipViaDetails(); obj.ShipViaId = GetReaderValue_Int32(reader, "ShipViaId", 0); obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); obj.ShipViaName = GetReaderValue_String(reader, "ShipViaName", ""); obj.Notes = GetReaderValue_String(reader, "Notes", ""); obj.Service = GetReaderValue_String(reader, "Service", ""); obj.Shipper = GetReaderValue_String(reader, "Shipper", ""); obj.Buy = GetReaderValue_Boolean(reader, "Buy", false); obj.Sell = GetReaderValue_Boolean(reader, "Sell", false); obj.Cost = GetReaderValue_NullableDouble(reader, "Cost", null); obj.Charge = GetReaderValue_NullableDouble(reader, "Charge", null); obj.PickUp = GetReaderValue_String(reader, "PickUp", ""); obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); obj.IsSameAsShipCost = GetReaderValue_Boolean(reader, "IsSameAsShipCost", false); return(obj); } else { return(null); } } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get ShipVia", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
/// <summary> /// GetListForClient /// Calls [usp_selectAll_ShipVia_for_Client] /// </summary> public override List <ShipViaDetails> GetListForClient(System.Int32?clientId) { SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(this.ConnectionString); cmd = new SqlCommand("usp_selectAll_ShipVia_for_Client", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 30; cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId; cn.Open(); DbDataReader reader = ExecuteReader(cmd); List <ShipViaDetails> lst = new List <ShipViaDetails>(); while (reader.Read()) { ShipViaDetails obj = new ShipViaDetails(); obj.ShipViaId = GetReaderValue_Int32(reader, "ShipViaId", 0); obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); obj.ShipViaName = GetReaderValue_String(reader, "ShipViaName", ""); obj.Notes = GetReaderValue_String(reader, "Notes", ""); obj.Service = GetReaderValue_String(reader, "Service", ""); obj.Shipper = GetReaderValue_String(reader, "Shipper", ""); obj.Buy = GetReaderValue_Boolean(reader, "Buy", false); obj.Sell = GetReaderValue_Boolean(reader, "Sell", false); obj.Cost = GetReaderValue_NullableDouble(reader, "Cost", null); obj.Charge = GetReaderValue_NullableDouble(reader, "Charge", null); obj.PickUp = GetReaderValue_String(reader, "PickUp", ""); obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); obj.IsSameAsShipCost = GetReaderValue_Boolean(reader, "IsSameAsShipCost", false); lst.Add(obj); obj = null; } return(lst); } catch (SqlException sqlex) { //LogException(sqlex); throw new Exception("Failed to get ShipVias", sqlex); } finally { cmd.Dispose(); cn.Close(); cn.Dispose(); } }
private static ShipVia PopulateFromDBDetailsObject(ShipViaDetails obj) { ShipVia objNew = new ShipVia(); objNew.ShipViaId = obj.ShipViaId; objNew.ClientNo = obj.ClientNo; objNew.ShipViaName = obj.ShipViaName; objNew.Notes = obj.Notes; objNew.Service = obj.Service; objNew.Shipper = obj.Shipper; objNew.Buy = obj.Buy; objNew.Sell = obj.Sell; objNew.Cost = obj.Cost; objNew.Charge = obj.Charge; objNew.PickUp = obj.PickUp; objNew.Inactive = obj.Inactive; objNew.UpdatedBy = obj.UpdatedBy; objNew.DLUP = obj.DLUP; return(objNew); }