public ActionResult Index()
        {
            if (Session["usuarioLogadoID"] != null)
            {
                using (var db = new MyContext())
                {
                    //var controle = db.Dia.ToList();

                    DiaViewModel dias = new DiaViewModel();
                    //var valorTotal = db.ResumoDiario.GroupBy(x => x.id_data).ToList();
                    //float? valorTotalMesmo = 0;
                    //foreach (var valor in valorTotal)
                    //    valorTotalMesmo += valor.Sum(x => x.Valor);

                    dias.Dias = (from p in db.Dia
                                 orderby p.RegistrarDia
                                 select p).Take(30).ToList();

                    float total = dias.Dias.Sum(x => x.valorDia);

                    dias.valorTotal = total;

                    //DiaViewModel diaControler = new DiaViewModel();

                    //diaControler.Login = controle;


                    return(View(dias));
                }
            }
            else
            {
                return(RedirectToAction("Login", "Login"));
            }
        }
Example #2
0
 public DiaView(DiaTypes diaType, Window main, string exaequoFolder)
 {
     InitializeComponent();
     MainWin   = main;
     DiaType   = diaType;
     ViewModel = new DiaViewModel(DiaType, MainWin, exaequoFolder);
     ViewModel.OnRequestClose += (s, e) => Close();
     DataContext  = ViewModel;
     DiaWin.Style = (Style)Application.Current.Resources["NoShadowWindowStyle"];
 }
        public ActionResult Index(DiaViewModel dia)
        {
            if (Session["usuarioLogadoID"] != null)
            {
                Dia diaBanco = new Dia();
                dia.RegistrarDia = dia.RegistrarDia;

                diaBanco.RegistrarDia = dia.RegistrarDia;
                diaBanco.valorDia     = dia.valorDia;

                if (ModelState.IsValid)
                {
                    using (var db = new MyContext())
                    {
                        var diaBancoComparar = dia.RegistrarDia.Date;
                        var RegistrarDia     = db.Dia.AsEnumerable().Where(x => x.RegistrarDia.Date == diaBancoComparar).FirstOrDefault();;
                        if (RegistrarDia == null)
                        {
                            db.Dia.Add(diaBanco);
                            db.SaveChanges();
                            ModelState.Clear();
                            ViewBag.Message = "Dia Registrado com Sucesso!";
                        }
                        else
                        {
                            ViewBag.Message = "Este Dia já foi cadastrado!";
                        }
                    }
                }

                using (var db = new MyContext())
                {
                    dia.Dias = db.Dia.ToList();
                    return(View(dia));
                }
            }
            else
            {
                return(RedirectToAction("Login", "Login"));
            }
        }