public TaxProfileType FindTaxProfileByIdentification(string Identification)
{
TaxProfileType item = null;
using (var context = new AgileInvoiceDbContext(_connectionString))
{
IQueryable <TaxProfile> lista = from row in context.TaxProfiles
where row.Identification == Identification
select row;
if (lista.Count() > 0)
{
var entitie = lista.FirstOrDefault();
item.IdTaxProfile = entitie.IdTaxProfile;
item.Name = entitie.Name;
item.Identification = entitie.Identification;
item.Street = entitie.Street;
item.ExteriorNumber = entitie.ExteriorNumber;
item.InteriorNumber = entitie.InteriorNumber;
item.Suburb = entitie.Suburb;
item.Municipality = entitie.Municipality;
item.State = entitie.State;
item.Country = entitie.Country;
item.PostCode = entitie.PostCode;
}
}
return(item);
}
public int UpdateTaxProfile(TaxProfileType item)
{
int result = 0;
using (var context = new AgileInvoiceDbContext(_connectionString))
{
IQueryable <TaxProfile> lista = from row in context.TaxProfiles
where row.IdTaxProfile == item.IdTaxProfile
select row;
if (lista.Count() > 0)
{
var entitie = lista.FirstOrDefault();
entitie.Name = item.Name;
entitie.Identification = item.Identification;
entitie.Street = item.Street;
entitie.ExteriorNumber = item.ExteriorNumber;
entitie.InteriorNumber = item.InteriorNumber;
entitie.Suburb = item.Suburb;
entitie.Municipality = item.Municipality;
entitie.State = item.State;
entitie.Country = item.Country;
entitie.PostCode = item.PostCode;
entitie.ModificationDate = DateTime.Now;
result = context.SaveChanges();
}
}
return(result);
}
public ActionResult DeleteConfirmation(int Id, TaxProfileType item)
{
try
{
_TaxProfileProcessor.RemoveTaxProfile(Id);
ViewData["Suscess"] = "Se eliminó el perfil satisfactoriamente";
}
catch (Exception ex)
{
return(View("Error", ex));
}
//return View("Suscess");
return(RedirectToAction("Index"));
}
public ActionResult Create(TaxProfileType item)
{
try
{
_TaxProfileProcessor.AddTaxProfile(item);
ViewData["Suscess"] = "Se dio de alta el perfil satisfactoriamente";
}
catch (Exception ex)
{
ViewData["Error"] = ex.Message;
}
//return View("Suscess");
return(RedirectToAction("Index"));
}
public void UpdateTaxProfile(TaxProfileType item)
{
try
{
if (_TaxProfileRepository.UpdateTaxProfile(item) == 0)
{
throw new Exception($"Algo salio mal, no se encontró el registro con identificación {item.Identification}");
}
}
catch (Exception ex)
{
//FALTA: Guardar en Log el error real.
throw new Exception("Algo salió bastante mal");
}
}
public void AddTaxProfile(TaxProfileType item)
{
//OBSERVACION:
//Nos damos cuenta algunas de las validaciones podrian o no hacerse (por ej. checar si existe el registro o no)
//ya que las validaciones pueden a nivel base de datos con constraint, es decir el registro existe y intentamos agregar un nuevo
//usuario con la misma clave, tronara la transaccion si la tiene un constraint o llave primaria de esa clave.
//como posible ventaja es utilizar angular para ir validando el campo cada vez que salimos de un contol (caja de texto, grid, etc) antes de enviar todos
//los datos a la BD.
TaxProfileType item2 = _TaxProfileRepository.FindTaxProfileByIdentification(item.Identification);
if (item2 != null)
{
throw new Exception($"Este RFC ya se encuentra registrado para la entidad {item2.Name}");
}
_TaxProfileRepository.AddTaxProfile(item);
}
public ActionResult Edit(TaxProfileType item)
{
if (_TaxProfileProcessor.FindTaxProfileByIdentification(item.Identification) != null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
_TaxProfileProcessor.UpdateTaxProfile(item);
ViewData["Suscess"] = "Se actualizó el perfil satisfactoriamente";
}
catch (Exception ex)
{
return(View("Error", ex));
}
//return View("Suscess");
return(RedirectToAction("Index"));
}
static void Main(string[] args)
{
TaxProfileType item = new TaxProfileType();
item.Identification = "GTR123456ABC";
item.Name = "Empresa GTR S.A. de C.V.";
item.Street = "Calle 1";
item.ExteriorNumber = "123";
item.InteriorNumber = "11";
item.Suburb = "portales";
item.State = "CDMX";
item.PostCode = 01155;
item.Country = "Mexico";
//_connectionString = System.Configuration.con;
//ITaxProfileRepository _TaxProfileRepository;
//_TaxProfileRepository = new TaxProfileRepository("");
}
public int AddTaxProfile(TaxProfileType item)
{
int result = 0;
using (var context = new AgileInvoiceDbContext(_connectionString))
{
TaxProfile entitie = new TaxProfile();
entitie.Name = item.Name;
entitie.Identification = item.Identification;
entitie.Street = item.Street;
entitie.ExteriorNumber = item.ExteriorNumber;
entitie.InteriorNumber = item.InteriorNumber;
entitie.Suburb = item.Suburb;
entitie.Municipality = item.Municipality;
entitie.State = item.State;
entitie.Country = item.Country;
entitie.PostCode = item.PostCode;
entitie.CreationDate = DateTime.Now;
context.TaxProfiles.Add(entitie);
result = context.SaveChanges();
}
return(result);
}
public ActionResult Delete(int Id)
{
TaxProfileType item = _TaxProfileProcessor.FindTaxProfileById(Id);
return(View(item));
}
