public bool FeeUpdateByID(DataFees fees)
{
bool noError = true;
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand command = new SqlCommand("dbo.sp_FeeUpdateByID", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Tax", fees.Tax);
command.Parameters.AddWithValue("@ShippingFee", fees.ShippingFee);
command.Parameters.AddWithValue("@Active", fees.Active);
connection.Open();
}
}
}
catch (Exception exception)
{
Logger.LogError(exception);
}
return(noError);
}
public DataFees FeeGetByID(int FeeID)
{
DataFees dFee = new DataFees();
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand command = new SqlCommand("dbo.sp_FeeGetByID", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@FeeID", FeeID);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
dFee.FeeID = reader.GetInt32(0);
dFee.Tax = reader.GetDecimal(1);
dFee.ShippingFee = reader.GetDecimal(2);
dFee.RateCreationDate = reader.GetDateTime(3);
}
}
}
}
catch (Exception exception)
{
Logger.LogError(exception);
}
return(dFee);
}
public ModelFees Map(DataFees dFee)
{
ModelFees mFee = new ModelFees();
mFee.FeeID = dFee.FeeID;
mFee.Tax = dFee.ShippingFee;
mFee.ShippingFee = dFee.ShippingFee;
mFee.RateCreationDate = dFee.RateCreationDate;
mFee.Active = dFee.Active;
return(mFee);
}
public DataFees Map(ModelFees mFee)
{
DataFees dFee = new DataFees();
dFee.FeeID = mFee.FeeID;
dFee.Tax = mFee.ShippingFee;
dFee.ShippingFee = mFee.ShippingFee;
dFee.RateCreationDate = mFee.RateCreationDate;
dFee.Active = mFee.Active;
return(dFee);
}
public List <DataFees> FeeGetAll()
{
List <DataFees> dFees = new List <DataFees>();
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
using (SqlCommand command = new SqlCommand("dbo.sp_FeesGetAll", connection))
{
command.CommandType = CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DataFees dFee = new DataFees();
dFee.FeeID = reader.GetInt32(0);
dFee.Tax = reader.GetDecimal(1);
dFee.ShippingFee = reader.GetDecimal(2);
dFee.RateCreationDate = reader.GetDateTime(3);
dFees.Add(dFee);
}
}
}
}
catch (Exception exception)
{
Logger.LogError(exception);
}
return(dFees);
}
