private static void DoTrans()
{
using (var context = new ControlEntities())
{
context.Database.Connection.Open();
using (var dbcxtransaction = context.Database.BeginTransaction())
{
try
{
Categoria newCat = new Categoria()
{
Descripcion = "Tran Test"
};
context.Categorias.Add(newCat);
context.SaveChanges();
Bitacora newBitacora = new Bitacora()
{
//Descripcion = "TranTest"
//,Error = true
//,Fecha = DateTime.Now
//,IdUsuario = 1
};
context.Bitacoras.Add(newBitacora);
context.SaveChanges();
dbcxtransaction.Commit();
context.Database.Connection.Close();
Console.WriteLine("Data Saved Successfully. Transaction Commited");
}
catch
{
dbcxtransaction.Rollback();
context.Database.Connection.Close();
Console.WriteLine("Error Occured during data saved. Transaction Rolled Back");
}
}
Console.WriteLine("Categorias");
var queryListCat = (from b in context.Categorias
select b).ToList();
foreach (var item in queryListCat)
{
Console.WriteLine(item.Descripcion);
}
Console.WriteLine("Bitacoras");
var queryList = (from b in context.Bitacoras
select b).ToList();
foreach (var item in queryList)
{
Console.WriteLine(item.Descripcion + item.IdUsuario.ToString());
}
context.Database.Connection.Close();
}
}
private ControlBusiness.Business.CommonB CreateProductosBL()
{
ControlEntities ctx = new ControlEntities();
var mockControlRepository = new MockControlRepository(ctx);
// var inventBL = new InventarioB();
//var inventBL = new InventarioB(mockControlRepository);
var commB = new CommonB(mockControlRepository);
commB.CreateEntity(new Producto()
{
IdProducto = 0,
Codigo = "First Producto code",
Descripcion = "Descrip 1",
Proveedore = new Proveedore()
{
IdProveedor = 0,
Descripcion = "Proveedor One",
Telefono = "Tel 1"
}
});
commB.CreateEntity(new Producto()
{
IdProducto = 1,
Codigo = "Second Producto code",
Descripcion = "Descrip 2",
Proveedore = new Proveedore()
{
IdProveedor = 1,
Descripcion = "Proveedor 2",
Telefono = "Tel 2"
}
});
commB.CreateEntity(new Producto()
{
IdProducto = 2,
Codigo = "Third Producto code",
Descripcion = "Descrip 3",
Proveedore = new Proveedore()
{
IdProveedor = 2,
Descripcion = "Proveedor 3",
Telefono = "Tel 3"
}
});
return(commB);
}
public ControlBase(ControlEntities db)
{
dbCtx = db; // por si quiero usar otro contextDb que no sea el static ControlContext.DbCtx
}
public GeneralR(ControlEntities passedCtx)
: base
(passedCtx)
{
}
static void Main(string[] args)
{
DoTrans();
Console.ReadLine();
object mynumber = "1050.00";
var dec = BaseHelpers.Helpers.Tools.NumericValidators.IsNumeric(mynumber);
Console.Write(dec);
Console.ReadLine();
var round = new RoundTest();
round.TestRound();
decimal value = 0;
decimal value2 = 0;
decimal value3 = 0;
value = 1324.249m;
value2 = 1310.519m;
value3 = 1370.234m;
Console.WriteLine("Ninguno {0} = {1}", value, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Ninguno));
Console.WriteLine("Centecimales {0} = {1}", value, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Centecimales));
Console.WriteLine("Centecimales {0} = {1}", value2, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value2,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Centecimales));
Console.WriteLine("Centecimales {0} = {1}", value3, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value3,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Centecimales));
Console.WriteLine("Decimales {0} = {1}", value, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Decimales));
Console.WriteLine("Decimales {0} = {1}", value2, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value2,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Decimales));
Console.WriteLine("Decimales {0} = {1}", value3, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value3,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Decimales));
Console.WriteLine("SinDecimales {0} = {1}", value, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.SinDecimales));
Console.WriteLine("SinDecimales {0} = {1}", value2, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value2,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.SinDecimales));
Console.WriteLine("SinDecimales {0} = {1}", value3, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value3,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.SinDecimales));
Console.WriteLine("Unidades {0} = {1}", value, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Unidades));
Console.WriteLine("Unidades {0} = {1}", value2, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value2,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Unidades));
Console.WriteLine("Unidades {0} = {1}", value3, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value3,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Unidades));
Console.WriteLine("Decenas {0} = {1}", value, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Decenas));
Console.WriteLine("Decenas {0} = {1}", value2, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value2,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Decenas));
Console.WriteLine("Decenas {0} = {1}", value3, BaseHelpers.Helpers.Tools.Redondeo.ApplyRound(value3,
BaseHelpers.Helpers.Tools.Redondeo.RedondeoTypes.Decenas));
Console.ReadLine();
var encodedPassword = BaseHelpers.Helpers.Tools.CodeDecode.Encode("1");
Console.WriteLine("clave de 1: {0}", encodedPassword);
// test generics
bool b1 = true, b2 = false;
Console.WriteLine("Before swap: {0}, {1}", b1, b2);
GenericMethods.Swap <bool>(ref b1, ref b2);
Console.WriteLine("After swap: {0}, {1}", b1, b2);
ControlEntities db = new ControlEntities();
var pl = db.Proveedores.ToList();
//GenericMethods.GetSnapshot<ProveedoresDtos.ProvListSearch>(pl);
GenericMethods.DisplayBaseClass <int>();
GenericMethods.DisplayBaseClass <string>();
// struct Point
Point <int> p = new Point <int>(10, 10);
// Point using double.
Point <double> p2 = new Point <double>(5.4, 3.3);
// class Coordenada
Coordenada <int> c = new Coordenada <int>(10, 10);
// Coordenada using double.
Coordenada <double> c2 = new Coordenada <double>(5.4, 3.3);
byte[] array = new byte[] { 1, 2, 3 };
var xxx = reversed(array, array.Length);
for (int i = 0; i < xxx.Length; i++)
{
Console.WriteLine(xxx[i]);
}
Console.ReadLine();
// pasandolo como parametro en el constructor
//InjectedRepository repoInjected = new InjectedRepository();
//InjectedClaseFinal final = new InjectedClaseFinal(repoInjected);
//final.getShit();
// sin parametros, usa constructor por defecto, el cual enlaza con el repo
InjectedClaseFinal finalSimple = new InjectedClaseFinal();
finalSimple.getShit(); // llama al getShit de ClaseFinal que a su vez llama getShit de InjectedRepository
// se agrego entityframework y se hizo reference a ControlData
// se creo un connectionstring
var testc = new testLinq();
var prods = testc.GetProdExistencias(4);
foreach (var item in prods)
{
Console.WriteLine(item.Cantidad);
}
Console.ReadLine();
}
public CreditoR(ControlEntities passedCtx)
: base
(passedCtx)
{
}
public InventarioR(ControlEntities passedCtx) : base
(passedCtx)
{
}
public ProveedoresR(ControlEntities passedCtx)
: base
(passedCtx)
{
}
//ControlEntities dbCtx;
public MockControlRepository(ControlEntities ctx) : base(ctx)
{
dbCtx = ctx;
}
public BancosR(ControlEntities passedCtx)
: base
(passedCtx)
{
}
public VentasR(ControlEntities passedCtx)
: base
(passedCtx)
{
}
public CommonR(ControlEntities passedCtx) : base(passedCtx)
{
}
