public static List <ComissaoMOD> Consultar(int PlanoId)
{
try
{
List <ComissaoMOD> ListComissaoMODs = new List <ComissaoMOD>();
using (SGCPSContext context = new SGCPSContext())
{
ComissaoMOD comissaoMOD = context.Comissoes.Where(x => x.PlanoId == PlanoId && x.Tipo.Equals("PME de 03 até 29 vidas")).FirstOrDefault();
if (comissaoMOD != null)
{
ListComissaoMODs.Add(comissaoMOD);
}
comissaoMOD = context.Comissoes.Where(x => x.PlanoId == PlanoId && x.Tipo.Equals("PME de 30 até 99 vidas")).FirstOrDefault();
if (comissaoMOD != null)
{
ListComissaoMODs.Add(comissaoMOD);
}
comissaoMOD = context.Comissoes.Where(x => x.PlanoId == PlanoId && x.Tipo.Equals("PME")).FirstOrDefault();
if (comissaoMOD != null)
{
ListComissaoMODs.Add(comissaoMOD);
}
}
return(ListComissaoMODs);
}
catch (Exception e)
{
return(new List <ComissaoMOD>());
}
}
public static void Cadastrar(ComissaoMOD comissaoMOD)
{
try
{
using (SGCPSContext context = new SGCPSContext())
{
context.Comissoes.Add(comissaoMOD);
context.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public static ComissaoVM ComissaoVM(ComissaoMOD comissaoMOD = null)
{
try
{
return(new ComissaoVM
{
LisPlanosMOD = PlanoRPO.Listar(),
ObjComissaoMOD = comissaoMOD
});
}
catch (Exception)
{
return(new ComissaoVM
{
LisPlanosMOD = new List <PlanoMOD>(),
ObjComissaoMOD = comissaoMOD
});
}
}
private static void AlterarPorParcela(ComissaoMOD comissaoMOD)
{
try
{
using (SGCPSContext context = new SGCPSContext())
{
ComissaoMOD ObjComissaoMOD = context.Comissoes.Where(x => x.NumeroDaParcela == comissaoMOD.NumeroDaParcela && x.PlanoId == comissaoMOD.PlanoId).First();
ObjComissaoMOD.NumeroDaParcela = comissaoMOD.NumeroDaParcela;
ObjComissaoMOD.PlanoId = comissaoMOD.PlanoId;
ObjComissaoMOD.Comissao = comissaoMOD.Comissao;
ObjComissaoMOD.Tipo = comissaoMOD.Tipo;
context.Comissoes.Update(ObjComissaoMOD);
context.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
private static bool Exists(ComissaoMOD comissaoMOD)
{
try
{
using (SGCPSContext context = new SGCPSContext())
{
if (context.Comissoes.Where(x => x.NumeroDaParcela == comissaoMOD.NumeroDaParcela &&
x.PlanoId == comissaoMOD.PlanoId).First() != null)
{
return(true);
}
}
return(true);
}
catch (Exception e)
{
if (e.Message.Equals("Sequence contains no elements"))
{
return(false);
}
throw;
}
}
