public AnswerResponseBE UpdateActivities(ActivitiesBE UPACTI)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
Activities activities = new Activities();
activities = BDEA.Activities.Where(x => x.ActivitiesCode == UPACTI.ActivitiesCode).FirstOrDefault();
if (activities != null)
{
activities.NameActivities = UPACTI.NameActivities;
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha actualizado la actividad correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro no existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
public AnswerResponseBE DeleteTimeActivity(int TIMEACTIVITECODE)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
var idTimeacti = BDEA.TimeActivity.Where(x => x.CodeTimeActivity == TIMEACTIVITECODE).FirstOrDefault();
if (idTimeacti != null)
{
BDEA.TimeActivity.Remove(idTimeacti);
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se eliminó con éxito";
}
else
{
AR.CodeError = 1;
AR.DescriptionError = "El registro no existe";
}
}
catch (Exception EX)
{
AR.CodeError = 2;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
public AnswerResponseBE ValidatioUserPassword(string USERNAME, string PASSWORD)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
User user = new User();
user = BDEA.User.Where(x => x.NameUser == USERNAME && x.Password == PASSWORD).FirstOrDefault();
if (user != null)
{
AR.CodeError = 0;
AR.DescriptionError = "Usuario correcto";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "Usuario y contraseña incorrecta, favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
public AnswerResponseBE UpdateDepartamento(DepartamentoBE UDEPT)
{
AnswerResponseBE AR = new AnswerResponseBE();
try
{
Departamento Departamento = new Departamento();
Departamento = _appDbContext.Departamento.Where(x => x.DepartamentoId == UDEPT.DepartamentoId).FirstOrDefault();
if (Departamento != null)
{
Departamento.Nombre = UDEPT.Nombre;
Departamento.Codigo = UDEPT.Codigo;
_appDbContext.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha actualizado el Departamento correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro no existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
_appDbContext.Dispose();
}
return(AR);
}
public AnswerResponseBE DeleteMunicipio(int id)
{
AnswerResponseBE AR = new AnswerResponseBE();
try
{
Municipio municipio = new Municipio();
municipio = _appDbContext.Municipio.Where(x => x.MunicipioId == id).FirstOrDefault();
if (municipio != null)
{
_appDbContext.Remove(municipio);
_appDbContext.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha eliminado el municipio correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro no existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
_appDbContext.Dispose();
}
return(AR);
}
public AnswerResponseBE Updatetimeactivity(TimeActivityBE UPTIMEACT)
{
AnswerResponseBE AR = new AnswerResponseBE();
TimeActivityLogic TAL = new TimeActivityLogic();
AR = TAL.UpdateTimeActivity(UPTIMEACT);
return(AR);
}
public AnswerResponseBE UpdateActivities(ActivitiesBE UPACTI)
{
AnswerResponseBE AR = new AnswerResponseBE();
ActivitiesLogic AL = new ActivitiesLogic();
AR = AL.UpdateActivities(UPACTI);
return(AR);
}
public AnswerResponseBE UpdateCupboard(ProductBE UPPROD)
{
AnswerResponseBE AR = new AnswerResponseBE();
ProductLogic PL = new ProductLogic();
AR = PL.UpdateProduct(UPPROD);
return(AR);
}
public AnswerResponseBE InsertUser(UserBE IUSER)
{
AnswerResponseBE AR = new AnswerResponseBE();
UserLogic UL = new UserLogic();
AR = UL.InsertUser(IUSER);
return(AR);
}
public AnswerResponseBE UpdateDepartamento([FromBody] DepartamentoBE UDEPT)
{
AnswerResponseBE AR = new AnswerResponseBE();
DepartamentoLogic DL = new DepartamentoLogic(_appDbContext);
AR = DL.UpdateDepartamento(UDEPT);
return(AR);
}
public AnswerResponseBE UpdateMunicipio([FromBody] MunicipioBE UMUNI)
{
AnswerResponseBE AR = new AnswerResponseBE();
MunicipioLogic ML = new MunicipioLogic(_appDbContext);
AR = ML.UpdateMunicipio(UMUNI);
return(AR);
}
public AnswerResponseBE UpdateUser(UserBE UPUSER)
{
AnswerResponseBE AR = new AnswerResponseBE();
UserLogic UL = new UserLogic();
AR = UL.UpdateUser(UPUSER);
return(AR);
}
public AnswerResponseBE InsertProduct([FromBody] UserBE IUS)
{
AnswerResponseBE AR = new AnswerResponseBE();
UserLogic UL = new UserLogic();
AR = UL.InsertUser(IUS);
return(AR);
}
public AnswerResponseBE InsertProduct(ProductBE IPROD)
{
AnswerResponseBE AR = new AnswerResponseBE();
ProductLogic PL = new ProductLogic();
AR = PL.InsertProduct(IPROD);
return(AR);
}
public AnswerResponseBE DeleteDepartamento(int id)
{
AnswerResponseBE AR = new AnswerResponseBE();
DepartamentoLogic DL = new DepartamentoLogic(_appDbContext);
AR = DL.DeleteDepartamento(id);
return(AR);
}
public AnswerResponseBE DeleteTimeActivity(int TIMEACTIVITECODE)
{
AnswerResponseBE AR = new AnswerResponseBE();
TimeActivityLogic TAL = new TimeActivityLogic();
AR = TAL.DeleteTimeActivity(TIMEACTIVITECODE);
return(AR);
}
public AnswerResponseBE InsertTimeActivity(TimeActivityBE ITIMAC)
{
AnswerResponseBE AR = new AnswerResponseBE();
TimeActivityLogic TAL = new TimeActivityLogic();
AR = TAL.InsertTimeActivity(ITIMAC);
return(AR);
}
public AnswerResponseBE DeleteMunicipio(int id)
{
AnswerResponseBE AR = new AnswerResponseBE();
MunicipioLogic ML = new MunicipioLogic(_appDbContext);
AR = ML.DeleteMunicipio(id);
return(AR);
}
public AnswerResponseBE InsertActivities(ActivitiesBE IACT)
{
AnswerResponseBE AR = new AnswerResponseBE();
ActivitiesLogic AL = new ActivitiesLogic();
AR = AL.InsertActivities(IACT);
return(AR);
}
public AnswerResponseBE InsertMunicipio([FromBody] MunicipioBE IMUNI)
{
AnswerResponseBE AR = new AnswerResponseBE();
MunicipioLogic ML = new MunicipioLogic(_appDbContext);
AR = ML.InsertMunicipio(IMUNI);
return(AR);
}
public AnswerResponseBE ValidatioUserPassword(string USERNAME, string PASSWORD)
{
AnswerResponseBE AR = new AnswerResponseBE();
UserLogic UL = new UserLogic();
AR = UL.ValidatioUserPassword(USERNAME, PASSWORD);
return(AR);
}
public AnswerResponseBE InsertProduct(ProductBE IPROD)
{
AnswerResponseBE AR = new AnswerResponseBE();
MasterProductContext BDMP = new MasterProductContext();
try
{
int CountProd = 0;
CountProd = BDMP.Product.Where(x => x.IdProduct == IPROD.IdProduct).ToList().Count();
if (CountProd == 0)
{
Product PROD = new Product();
PROD.IdProduct = IPROD.IdProduct;
PROD.NameProduct = IPROD.NameProduct;
PROD.Properties = IPROD.Properties;
PROD.ReleaseDate = IPROD.ReleaseDate;
PROD.ManufacturerEmail = IPROD.ManufacturerEmail;
PROD.IdCountry = IPROD.IdCountry;
PROD.Cost = IPROD.Cost;
PROD.UnitsAvailable = IPROD.UnitsAvailable;
PROD.SoldUnits = IPROD.SoldUnits;
PROD.StateProduct = IPROD.StateProduct;
PROD.ImageProduct = IPROD.ImageProduct;
BDMP.Product.Add(PROD);
BDMP.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha insertado el producto correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El producto ya existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDMP.Dispose();
}
return(AR);
}
public AnswerResponseBE UpdateProduct(ProductBE UPROD)
{
AnswerResponseBE AR = new AnswerResponseBE();
MasterProductContext BDMP = new MasterProductContext();
try
{
Product product = new Product();
product = BDMP.Product.Where(x => x.IdProduct == UPROD.IdProduct).FirstOrDefault();
if (product != null)
{
product.IdProduct = UPROD.IdProduct;
product.NameProduct = UPROD.NameProduct;
product.Properties = UPROD.Properties;
product.ReleaseDate = UPROD.ReleaseDate;
product.ManufacturerEmail = UPROD.ManufacturerEmail;
product.IdCountry = UPROD.IdCountry;
product.Cost = UPROD.Cost;
product.UnitsAvailable = UPROD.UnitsAvailable;
product.SoldUnits = UPROD.SoldUnits;
product.StateProduct = UPROD.StateProduct;
product.ImageProduct = UPROD.ImageProduct;
BDMP.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha actualizado el producto correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro no existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDMP.Dispose();
}
return(AR);
}
public AnswerResponseBE InsertUser(UserBE IUS)
{
AnswerResponseBE AR = new AnswerResponseBE();
MasterProductContext BDMP = new MasterProductContext();
try
{
int CountUser = 0;
CountUser = BDMP.User.Where(x => x.IdUser == IUS.IdUser).ToList().Count();
if (CountUser == 0)
{
User USER = new User();
USER.IdUser = IUS.IdUser;
USER.NameUser = IUS.NameUser;
USER.Photo = IUS.Photo;
BDMP.User.Add(USER);
BDMP.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha insertado el usuario correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El usuario ya existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDMP.Dispose();
}
return(AR);
}
public AnswerResponseBE UpdateUser(UserBE UPUS)
{
AnswerResponseBE AR = new AnswerResponseBE();
MasterProductContext BDMP = new MasterProductContext();
try
{
User user = new User();
user = BDMP.User.Where(x => x.IdUser == UPUS.IdUser).FirstOrDefault();
if (user != null)
{
user.IdUser = UPUS.IdUser;
user.NameUser = UPUS.NameUser;
user.Photo = UPUS.Photo;
BDMP.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha actualizado el usuario correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro no existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDMP.Dispose();
}
return(AR);
}
public AnswerResponseBE InsertTimeActivity(TimeActivityBE ITIMAC)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
int CountTimeActi = 0;
CountTimeActi = BDEA.TimeActivity.Where(x => x.CodeTimeActivity == ITIMAC.CodeTimeActivity).ToList().Count();
if (CountTimeActi == 0)
{
TimeActivity TIMACT = new TimeActivity();
TIMACT.ActivitiesCode = ITIMAC.ActivitiesCode;
TIMACT.DateActivity = ITIMAC.DateActivity;
TIMACT.Hours = ITIMAC.Hours;
TIMACT.IdUser = ITIMAC.IdUser;
BDEA.TimeActivity.Add(TIMACT);
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha insertado el tiempo / actividad correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro ya existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
public AnswerResponseBE InsertMunicipio(MunicipioBE IMUNI)
{
AnswerResponseBE AR = new AnswerResponseBE();
try
{
int CountMuni = 0;
CountMuni = _appDbContext.Municipio.Where(x => x.Codigo == IMUNI.Codigo).ToList().Count();
if (CountMuni == 0)
{
Municipio MUNICIPIO = new Municipio();
MUNICIPIO.Nombre = IMUNI.Nombre;
MUNICIPIO.DepartamentoId = IMUNI.DepartamentoId;
MUNICIPIO.Codigo = IMUNI.Codigo;
_appDbContext.Municipio.Add(MUNICIPIO);
_appDbContext.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha insertado el municipio correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El municipio ya existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
_appDbContext.Dispose();
}
return(AR);
}
public AnswerResponseBE InsertActivities(ActivitiesBE IACT)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
int CountActi = 0;
CountActi = BDEA.Activities.Where(x => x.ActivitiesCode == IACT.ActivitiesCode).ToList().Count();
if (CountActi == 0)
{
Activities ACTIV = new Activities();
ACTIV.NameActivities = IACT.NameActivities;
ACTIV.IdUser = IACT.IdUser;
BDEA.Activities.Add(ACTIV);
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha insertado la actividad correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro ya existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
public AnswerResponseBE InsertUser(UserBE IUSER)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
int CountUser = 0;
CountUser = BDEA.User.Where(x => x.IdUser == IUSER.IdUser).ToList().Count();
if (CountUser == 0)
{
User US = new User();
US.NameUser = IUSER.NameUser;
US.Password = IUSER.Password;
BDEA.User.Add(US);
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha insertado el usuario correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro ya existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
public AnswerResponseBE UpdateTimeActivity(TimeActivityBE UPTIMEACT)
{
AnswerResponseBE AR = new AnswerResponseBE();
EmploActiEntities BDEA = new EmploActiEntities();
try
{
TimeActivity timeactivity = new TimeActivity();
timeactivity = BDEA.TimeActivity.Where(x => x.CodeTimeActivity == UPTIMEACT.CodeTimeActivity).FirstOrDefault();
if (timeactivity != null)
{
timeactivity.ActivitiesCode = UPTIMEACT.ActivitiesCode;
timeactivity.DateActivity = UPTIMEACT.DateActivity;
timeactivity.Hours = UPTIMEACT.Hours;
BDEA.SaveChanges();
AR.CodeError = 0;
AR.DescriptionError = "Se ha actualizado el tiempo / actividad correctamente";
}
else
{
AR.CodeError = 2;
AR.DescriptionError = "El registro no existe, por favor verifique la información";
}
}
catch (Exception EX)
{
AR.CodeError = 1;
AR.DescriptionError = "Hubo un error";
}
finally
{
BDEA.Dispose();
}
return(AR);
}
