public static bool esEncargado()
{
int IdUsuario = SessionHelper.GetIdUser();
var _responsable = new responsable();
try
{
using (var ctx = new inventarioContext())
{
_responsable = ctx.responsable
.Where(x => x.IdUsuario == IdUsuario)
.Where(x => x.Encargado == 1)
.SingleOrDefault();
}
if (_responsable != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public static int ObtenerArea(int IdUsuario)
{
int area;
var modelResponsable = new responsable();
try
{
using (var ctx = new inventarioContext())
{
modelResponsable = ctx.responsable
.Where(x => x.IdUsuario == IdUsuario)
.SingleOrDefault();
}
if (modelResponsable != null)
{
area = (int)modelResponsable.IdArea;
}
else
{
area = -100;
}
}
catch (Exception)
{
throw;
}
return(area);
}
public static int ObtenerIdResponsableUsuario(int IdUsuario)
{
int _IdUsuario;
var modelResponsable = new responsable();
try
{
using (var ctx = new inventarioContext())
{
modelResponsable = ctx.responsable
.Where(x => x.IdUsuario == IdUsuario)
//.Where(x => x.Encargado == 1)
.FirstOrDefault();
}
if (modelResponsable != null)
{
_IdUsuario = (int)modelResponsable.IdResponsable;
}
else
{
_IdUsuario = -1;
}
}
catch (Exception)
{
throw;
}
return(_IdUsuario);
}
public static bool esAutorizador()
{
var responsable = new responsable();
int idResponsable = responsable.obtenerResponsableporIdusuario(SessionHelper.GetIdUser()).IdResponsable;
AutorizadorTarea autorizador = new AutorizadorTarea();
try
{
using (var ctx = new inventarioContext())
{
autorizador = ctx.AutorizadorTarea.Where(x => x.estado == 1)
.Where(x => x.IdResponsable == idResponsable)
.Include(x => x.responsable.usuariosSistema)
.FirstOrDefault();
}
if (autorizador != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw;
}
}
public void EliminarResponsablesArea() //eliminar reponsables de area excepto el encargado
{
var responsable = new responsable();
//int idResponsable = responsable.ObtenerIdResponsable(this.idarea);
string sql;
try
{
using (var ctx = new inventarioContext())
{
sql = "DELETE FROM dbo.TareaResponsable WHERE idTarea = " + this.idtarea;
ctx.Database.ExecuteSqlCommand(sql);
}
}
catch (Exception e)
{
throw;
}
//return rm;
}
public responsable obtenerResponsableporIdusuario(int IdUsuario)
{
var modelResponsable = new responsable();
try
{
using (var ctx = new inventarioContext())
{
modelResponsable = ctx.responsable
.Include(x => x.areas)
.Where(x => x.IdUsuario == IdUsuario)
.FirstOrDefault();
}
}
catch (Exception)
{
throw;
}
return(modelResponsable);
}
public List <responsable> obtenerResposables(int IdArea)
{
List <responsable> _responsables;
var modelResponsable = new responsable();
try
{
using (var ctx = new inventarioContext())
{
_responsables = ctx.responsable
.Where(x => x.IdArea == IdArea)
.Where(x => x.Encargado == 1)
.OrderByDescending(x => x.IdUsuario)
.ToList();
}
}
catch (Exception)
{
throw;
}
return(_responsables);
}
public int ObtenerIdResponsable(int IdArea)
{
int IdResponsable;
var modelResponsable = new responsable();
try
{
using (var ctx = new inventarioContext())
{
modelResponsable = ctx.responsable
.Where(x => x.IdArea == IdArea)
.Where(x => x.Encargado == 1)
.OrderByDescending(x => x.IdUsuario)
.FirstOrDefault();
}
IdResponsable = (int)modelResponsable.IdResponsable;
}
catch (Exception)
{
throw;
}
return(IdResponsable);
}
