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; } }