public Boolean SaveRebate(Rebate Item)
{
try
{ return(base.Channel.SaveRebate(Item)); }
catch (Exception ex)
{ throw ex; }
}
public static void getInfo()
{
//Instances
Rebate calcRebate = new Rebate();
//ValidReciepts isValid = new ValidReciepts();
int recNum;
Console.WriteLine("Please enter reciept number: /n");
recNum = Convert.ToInt32(Console.ReadLine());
//Check ValidReciepts
//Since isValid is no longer a class after chnging things up
//Add method in rebate to check validity of a reciept and have return bool
if (isValid.CheckValidity(recNum))
{
//calls to calcRebate
double rebate = calcRebate.getRebate(recNum);
//Print rebate
Console.WriteLine(rebate);
}
else
{
//error statement
}
}
static void Main(string[] args)
{
using (SalesDB context = new SalesDB())
{
EnsureMember(context.GetMemberRepository());
Rebate rebate = EnsureRebate(context.GetRebateRepository());
EnsureProduct(rebate, context.GetProductRepository());
}
Console.WriteLine("Subscribing to events...");
var queue = new MsmqMessageQueueOutbound <Subscription>(
".",
typeof(OrderShipped).FullName);
queue.Send(new Subscription
{
Target = Environment.MachineName,
QueueName = typeof(OrderShippedSubscriber).FullName
});
Console.WriteLine("Starting order shipped subscriber...");
MessageProcessor <OrderShipped> processor =
new MessageProcessor <OrderShipped>(
typeof(OrderShippedSubscriber).FullName,
() => new OrderShippedSubscriber());
processor.Start();
Console.ReadKey();
processor.Stop();
}
public void EditRebate(int id, Rebate rebate)
{
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
using (SqlCommand com = new SqlCommand())
{
string query = String.Format("UPDATE Rebate SET Name='{0}', ProductId='{1}', Discount='{2}', ", rebate.Name, rebate.Product.Id, (decimal)rebate.Discount);
if (rebate.GetType() == typeof(VolumeBasedRebate))
{
VolumeBasedRebate r = (VolumeBasedRebate)rebate;
query += String.Format("Volume='{0}', StartDate='{1}', EndDate='{2}', RebateType='{3}' WHERE Id={4}", r.Volume, DateTime.Now.AddYears(-1).ToString(), DateTime.Now.AddYears(10).ToString(), "VOLUME", id);
}
else if (rebate.GetType() == typeof(SeasonalRebate))
{
SeasonalRebate r = (SeasonalRebate)rebate;
query += String.Format("Volume='{0}', StartDate='{1}', EndDate='{2}', RebateType='{3}' WHERE Id={4}", 1, r.Start, r.End, "SEASONAL", id);
}
else
{
SpecialRebate r = (SpecialRebate)rebate;
query += String.Format("Volume='{0}', StartDate='{1}', EndDate='{2}', RebateType='{3}' WHERE Id={4}", r.Volume, r.Start, r.End, "SPECIAL", id);
}
com.CommandText = query;
com.Connection = con;
com.ExecuteNonQuery();
}
}
}
public ReportCard CalculatePerformance(
Member member,
MeasurementPeriod measurementPeriod,
Rebate rebate)
{
throw new NotImplementedException();
}
private bool Delete(ref Rebate item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_ELIMINAR_Rebate");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", item.REBA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
private ObservableCollection <Rebate> SelectAll(string x_CONC_TabReb, string x_CONC_CodReb, string x_ENTC_CodTransportista, DateTime x_REBA_FecIni)
{
try
{
ObservableCollection <Rebate> items = new ObservableCollection <Rebate>();
Rebate item = new Rebate();
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_RebateAllByFiltros");
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONC_TabReb", x_CONC_TabReb, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONC_CodReb", x_CONC_CodReb, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", x_ENTC_CodTransportista, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecIni", x_REBA_FecIni, SqlDbType.DateTime, 8, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
while (reader.Read())
{
item = new Rebate();
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
items.Add(item);
}
}
return(items);
}
catch (Exception ex)
{ throw ex; }
}
public int UpdateRebate(Rebate theRebate)
{
int ReturnValue = 0;
using (SqlCommand UpdateCommand = new SqlCommand())
{
UpdateCommand.CommandType = CommandType.StoredProcedure;
UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateCommand.Parameters.Add(GetParameter("@RebateID", SqlDbType.Int, theRebate.RebateID));
UpdateCommand.Parameters.Add(GetParameter("@PolicyTypeID", SqlDbType.Int, theRebate.PolicyTypeID));
//UpdateCommand.Parameters.Add(GetParameter("@PolicyName", SqlDbType.VarChar, theRebate.PolicyName));
UpdateCommand.Parameters.Add(GetParameter("@InstallmentMode", SqlDbType.VarChar, theRebate.InstallmentMode));
UpdateCommand.Parameters.Add(GetParameter("@RebatePer", SqlDbType.Decimal, theRebate.RebatePer));
UpdateCommand.Parameters.Add(GetParameter("@RebateValue", SqlDbType.Decimal, theRebate.RebateValue));
UpdateCommand.Parameters.Add(GetParameter("@EffectiveDateFrom", SqlDbType.VarChar, theRebate.EffectiveDateFrom));
UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
UpdateCommand.CommandText = "pCRM_Rebates_Update";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static Rebate GetRebateByID(int RebateID)
{
DataRow TheRebateRow = RebateDataAccess.GetInstance.GetRebateByID(RebateID);
Rebate TheRebate = DataRowToObject(TheRebateRow);
return(TheRebate);
}
public BLRebate(IUnityContainer container)
{
this.ContainerService = container;
Loader = new BusinessEntityLoader <Rebate>();
Rebate item = new Rebate();
Loader.EntityType = item.GetType();
}
public Boolean Save(ref Rebate Item)
{
try
{
Boolean m_isCorrect = true;
Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DABeginTransaction();
switch (Item.Instance)
{
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added:
m_isCorrect = Insert(ref Item); break;
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified:
m_isCorrect = Update(ref Item); break;
case Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted:
m_isCorrect = Delete(ref Item); break;
}
if (m_isCorrect)
{
for (int i = 0; i < Item.ListDetRebate.Count; i++)
{
DetRebate ItemDetRebate = Item.ListDetRebate[i];
ItemDetRebate.REBA_Codigo = Item.REBA_Codigo;
if (ItemDetRebate.DREB_Valor <= 0)
{
ItemDetRebate.Instance = Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted;
}
m_isCorrect = BL_DetRebate.Save(ref ItemDetRebate);
if (!m_isCorrect && ItemDetRebate.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Deleted)
{
break;
}
else
{
m_isCorrect = true;
}
}
if (m_isCorrect)
{
Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DACommitTransaction();
}
else
{
Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction();
}
}
else
{
Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction();
}
return(m_isCorrect);
}
catch (Exception)
{ Infrastructure.Aspect.DataAccess.DataAccessEnterpriseSQL.DARollbackTransaction(); throw; }
}
private static void EnsureProduct(Rebate rebate, IRepository <Product> productRepository)
{
if (!productRepository.GetAll().Any(p => p.ProductNumber == 11190))
{
productRepository.Add(new Product
{
ProductNumber = 11190,
Name = "Procrit",
Rebate = rebate
});
productRepository.SaveChanges();
}
}
public Boolean SaveRebate(Rebate Item)
{
try
{
if (Item.Instance != Infrastructure.Aspect.BusinessEntity.InstanceEntity.Unchanged)
{
return(BL_Rebate.Save(ref Item));
}
return(true);
}
catch (Exception ex)
{ throw ex; }
}
public static List <Rebate> GetRebateList()
{
List <Rebate> RebateList = new List <Rebate>();
DataTable RebateTable = RebateDataAccess.GetInstance.GetRebateList();
foreach (DataRow dr in RebateTable.Rows)
{
Rebate TheRebate = DataRowToObject(dr);
RebateList.Add(TheRebate);
}
return(RebateList);
}
private static Rebate EnsureRebate(IRepository <Rebate> rebateRepository)
{
Rebate rebate = rebateRepository.GetAll().FirstOrDefault(r => r.Name == "Procrit Rebate");
if (rebate == null)
{
rebate = rebateRepository.Add(new Rebate
{
Name = "Procrit Rebate"
});
rebateRepository.SaveChanges();
}
return(rebate);
}
private void SetExistingRebateValues()
{
if (!IsNew() && cmbRebName.SelectedItem != null)
{
Rebate item = (Rebate)cmbRebName.SelectedItem;
for (int i = 0; i < cmbRebProduct.Items.Count; i++)
{
Product p = (Product)cmbRebProduct.Items[i];
if (p.Id == item.Product.Id)
{
cmbRebProduct.SelectedIndex = i;
}
}
txtRebDiscount.Text = item.Discount.ToString();
if (item.GetType() == typeof(VolumeBasedRebate))
{
rdbRebVolume.Checked = true;
VolumeBasedRebate r = (VolumeBasedRebate)item;
txtRebVolQuantity.Text = r.Volume.ToString();
}
else if (item.GetType() == typeof(SeasonalRebate))
{
rdbRebSeasonal.Checked = true;
SeasonalRebate r = (SeasonalRebate)item;
dateRebSeasonalStart.Value = r.Start;
dateRebSeasonalEnd.Value = r.End;
}
else
{
rdbRebSpecial.Checked = true;
SpecialRebate r = (SpecialRebate)item;
txtRebSpecialQuantity.Text = r.Volume.ToString();
dateRebSpecialStart.Value = r.Start;
dateRebSpecialEnd.Value = r.End;
}
}
else
{
cmbRebProduct.SelectedItem = null;
txtRebDiscount.Text = "";
rdbRebVolume.Checked = true;
txtRebVolQuantity.Text = "";
dateRebSeasonalStart.Value = DateTime.Now;
dateRebSeasonalEnd.Value = DateTime.Now;
txtRebSpecialQuantity.Text = "";
dateRebSpecialStart.Value = DateTime.Now;
dateRebSpecialEnd.Value = DateTime.Now;
}
}
public static Rebate DataRowToObject(DataRow dr)
{
Rebate TheRebate = new Rebate();
TheRebate.RebateID = int.Parse(dr["RebateID"].ToString());
TheRebate.PolicyTypeID = int.Parse(dr["PolicyTypeID"].ToString());
TheRebate.PolicyName = dr["PolicyName"].ToString();
TheRebate.PolicyTypeDescription = dr["PolicyTypeDescription"].ToString();
TheRebate.InstallmentMode = dr["InstallmentMode"].ToString();
TheRebate.RebatePer = decimal.Parse(dr["RebatePer"].ToString());
TheRebate.RebateValue = decimal.Parse(dr["RebateValue"].ToString());
TheRebate.EffectiveDateFrom = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(MicroConstants.DateFormat);
return(TheRebate);
}
public Rebate GetOne(Int32 REBA_Codigo)
{
try
{
if (REBA_Codigo == null)
{
return(null);
}
Rebate Item = SelectOne(REBA_Codigo);
Item.ListDetRebate = BL_DetRebate.GetAllByRebate(REBA_Codigo);
return(Item);
}
catch (Exception ex)
{ throw ex; }
}
private Rebate findRebate(decimal amount)
{
Rebate result = Rebates[0];
foreach (Rebate rebate in Rebates)
{
if (amount < rebate.lowerBound)
{
return(result);
}
else
{
result = rebate;
}
}
return(result);
}
public int DeleteRebate(Rebate theRebate)
{
int ReturnValue = 0;
using (SqlCommand DeleteCommand = new SqlCommand())
{
DeleteCommand.CommandType = CommandType.StoredProcedure;
DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
DeleteCommand.Parameters.Add(GetParameter("@RebateID", SqlDbType.Int, theRebate.RebateID));
DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
DeleteCommand.CommandText = "pCRM_Rebates_Delete";
ExecuteStoredProcedure(DeleteCommand);
ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
private bool Insert(ref Rebate item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Added)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_INSERTAR_Rebate");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", item.REBA_Codigo, SqlDbType.Int, 4, ParameterDirection.InputOutput);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCONT_Codigo", item.CONT_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecIni", item.REBA_FecIni, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecFin", item.REBA_FecFin, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", item.ENTC_CodTransportista, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabMnd", item.TIPO_TabMnd, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodMnd", item.TIPO_CodMnd, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintPUER_CodDestino", item.PUER_CodDestino, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintPUER_CodOrigen", item.PUER_CodOrigen, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONC_TabReb", item.CONC_TabReb, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONC_CodReb", item.CONC_CodReb, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrCrea", item.AUDI_UsrCrea, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
Int32 _REBA_Codigo;
if (Int32.TryParse(DataAccessEnterpriseSQL.DASqlCommand.Parameters["@pintREBA_Codigo"].Value.ToString(), out _REBA_Codigo))
{
item.REBA_Codigo = _REBA_Codigo;
}
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
public void OneItemMultipleTimesWithRebate()
{
Product product = new Product();
Rebate currentRebateCode = new Rebate();
Dictionary <Product, int> cart = new Dictionary <Product, int>();
MainWindow.Cart = cart;
MainWindow.currentRebateCode = currentRebateCode;
product.Name = "Dator";
product.Price = "5000";
currentRebateCode.Code = "BCE234";
currentRebateCode.Percent = "10";
cart.Add(product, 2);
decimal sum = MainWindow.TotalSumWithRebate();
Assert.AreEqual(9000, sum);
}
bool Display()
{
Rebate objRebate = new Rebate(objStore.Discount);
double total = objStore.ValueOfGoods();
double value = objRebate(total);
double netValue = total - value;
Console.WriteLine();
Console.WriteLine("product name: \t\t" + objStore.ItemName);
Console.WriteLine("price per unit: \t" + objStore.ItemPrice);
Console.WriteLine("number of units sold: \t" + objStore.Quantity);
Console.WriteLine("total price: \t\t" + total);
Console.WriteLine("discount rate: \t\t" + objStore.Rate + "%");
Console.WriteLine("discount: \t\t" + value);
Console.WriteLine("Net value: \t\t" + netValue);
return(true);
}
public void AddRebate(Rebate rebate)
{
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
using (SqlCommand com = new SqlCommand("INSERT INTO Rebate(Name, ProductId, Discount, Volume, StartDate, EndDate, RebateType) VALUES(@Name, @ProductId, @Discount, @Volume, @StartDate, @EndDate, @RebateType)", con))
{
com.Parameters.AddWithValue("@Name", rebate.Name);
com.Parameters.AddWithValue("@ProductId", rebate.Product.Id);
com.Parameters.AddWithValue("@Discount", (decimal)rebate.Discount);
if (rebate.GetType() == typeof(VolumeBasedRebate))
{
VolumeBasedRebate r = (VolumeBasedRebate)rebate;
com.Parameters.AddWithValue("@Volume", r.Volume);
com.Parameters.AddWithValue("@StartDate", DateTime.Now.AddYears(-1).ToString());
com.Parameters.AddWithValue("@EndDate", DateTime.Now.AddYears(10).ToString());
com.Parameters.AddWithValue("@RebateType", "VOLUME");
}
else if (rebate.GetType() == typeof(SeasonalRebate))
{
SeasonalRebate r = (SeasonalRebate)rebate;
com.Parameters.AddWithValue("@Volume", 1);
com.Parameters.AddWithValue("@StartDate", r.Start);
com.Parameters.AddWithValue("@EndDate", r.End);
com.Parameters.AddWithValue("@RebateType", "SEASONAL");
}
else
{
SpecialRebate r = (SpecialRebate)rebate;
com.Parameters.AddWithValue("@Volume", r.Volume);
com.Parameters.AddWithValue("@StartDate", r.Start);
com.Parameters.AddWithValue("@EndDate", r.End);
com.Parameters.AddWithValue("@RebateType", "SPECIAL");
}
com.ExecuteNonQuery();
}
}
}
public List <Rebate> GetAllRebates()
{
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
List <Rebate> list = new List <Rebate>();
using (SqlCommand com = new SqlCommand("SELECT Id FROM Rebate", con))
{
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Rebate rebate = GetRebate((int)reader["Id"]);
list.Add(rebate);
}
}
return(list);
}
}
private void SetExistingCustomerValues()
{
if (!IsNew() && cmbCusName.SelectedItem != null)
{
Customer customer = (Customer)cmbCusName.SelectedItem;
List <int> rebateIdList = customer.RebateAgreement.Select(i => i.Id).ToList();
for (int i = 0; i < chkCusAgreements.Items.Count; i++)
{
Rebate item = (Rebate)chkCusAgreements.Items[i];
chkCusAgreements.SetItemChecked(i, rebateIdList.Contains(item.Id));
}
}
else
{
for (int i = 0; i < chkCusAgreements.Items.Count; i++)
{
chkCusAgreements.SetItemChecked(i, false);
}
}
}
private bool Update(ref Rebate item)
{
try
{
if (item.Instance == Infrastructure.Aspect.BusinessEntity.InstanceEntity.Modified)
{
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_ACTUALIZAR_Rebate");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", item.REBA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintCONT_Codigo", item.CONT_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecIni", item.REBA_FecIni, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pdtmREBA_FecFin", item.REBA_FecFin, SqlDbType.DateTime, 8, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintENTC_CodTransportista", item.ENTC_CodTransportista, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_TabMnd", item.TIPO_TabMnd, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrTIPO_CodMnd", item.TIPO_CodMnd, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@psinEMPR_Codigo", item.EMPR_Codigo, SqlDbType.SmallInt, 2, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintPUER_CodDestino", item.PUER_CodDestino, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pintPUER_CodOrigen", item.PUER_CodOrigen, SqlDbType.Int, 4, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONC_TabReb", item.CONC_TabReb, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pchrCONC_CodReb", item.CONC_CodReb, SqlDbType.Char, 3, ParameterDirection.Input);
DataAccessEnterpriseSQL.DAAgregarParametro("@pvchAUDI_UsrMod", item.AUDI_UsrMod, SqlDbType.VarChar, 20, ParameterDirection.Input);
if (DataAccessEnterpriseSQL.DAExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{ throw ex; }
}
private Rebate SelectOne(Int32 REBA_Codigo)
{
try
{
Rebate item = new Rebate();
DataAccessEnterpriseSQL.DAAsignarProcedure("TCOM_SP_CONSULTAR_Rebate");
DataAccessEnterpriseSQL.DAAgregarParametro("@pintREBA_Codigo", REBA_Codigo, SqlDbType.Int, 4, ParameterDirection.Input);
using (IDataReader reader = DataAccessEnterpriseSQL.DAExecuteReader())
{
if (reader.Read())
{
Loader.LoadEntity(reader, item);
item.Instance = InstanceEntity.Unchanged;
}
else
{
throw new Exception("No se encontro el registro.");
}
}
return(item);
}
catch (Exception ex)
{ throw ex; }
}
public void TwoItemsMultipleTimesWithRebate()
{
Product productOne = new Product();
Product pr = new Product();
Rebate currentRebateCode = new Rebate();
Dictionary <Product, int> cart = new Dictionary <Product, int>();
MainWindow.Cart = cart;
MainWindow.currentRebateCode = currentRebateCode;
productOne.Name = "Dator";
productOne.Price = "5000";
pr.Name = "Ratt";
pr.Price = "430";
currentRebateCode.Code = "BCE234";
currentRebateCode.Percent = "10";
cart.Add(productOne, 3);
cart.Add(pr, 2);
decimal sum = MainWindow.TotalSumWithRebate();
Assert.AreEqual(14274, sum);
}
public void AddRebate(Rebate rebate)
{
rebate.Id = rebateId++;
rebates.Add(rebate);
}
//[TestMethod()]
public void DeleteTest()
{
RebateDAL target = new RebateDAL();
Rebate rebate = new Rebate();
rebate.IdProduto = 101;
rebate.IdParceiro = 1;
rebate.Data = DateTime.Now;
rebate.Valor = 4333;
target.Delete(rebate);
Assert.AreEqual(rebate, target.Obter("IdProduto = 101 AND IdParceiro = 1"));
}
public void InsertTest()
{
RebateDAL target = new RebateDAL();
Rebate rebate = new Rebate();
rebate.IdProduto = 1;
rebate.IdParceiro = 1 ;
rebate.Data = DateTime.Now;
rebate.Valor = 4;
target.Insert(rebate);
Rebate rebateTest = target.Obter("IdProduto = 1 AND IdParceiro = 1");
Assert.AreEqual(rebate.IdProduto, rebateTest.IdProduto);
Assert.AreEqual(rebate.IdParceiro, rebateTest.IdParceiro);
Assert.AreNotEqual(rebate.Data, rebateTest.Data);
Assert.AreEqual(rebate.Valor, rebateTest.Valor);
}
