Пример #1
0
    protected void btnCadastrar_Click(object sender, EventArgs e)
    {
        try
        {
            var ag = new _agenda();
            ag.dataHora      = DateTime.Parse(txtdata.Text + " " + txtHora.Text);
            ag.encarregadoID = (from p in bd.db._users where p.nome == ddlEncarregado.SelectedValue select p.id).Single();
            ag.eventoID      = (from p in bd.db._agenda_Eventos where p.descricao == ddlTIpo.SelectedValue select p.ID).Single();
            ag.igrejaID      = (from p in bd.db._igrejas where p.descricao == ddlIgreja.SelectedValue && p._municipio.descricao == ddlCidade.SelectedValue select p.id).Single();
            ag.telefone      = txtTel.Text;

            bd.db._agendas.InsertOnSubmit(ag);
            bd.db.SubmitChanges();

            log.AdicionarEntrada(28, usuarioLogado.id, 6, "", 1, 0);

            CarregaForm();

            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alerta", "alert('Compromisso cadastrado com sucesso!!');", true);
        }
        catch (Exception er4)
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alerta", "alert('" + er4.Message + "');", true);
        }
    }
Пример #2
0
    protected void btnConfirmarReplicar_Click(object sender, EventArgs e)
    {
        try
        {
            string[] mesReplicar = txtMesReplicar.Text.Split('/');
            string[] mesReceber  = txtMesReceber.Text.Split('/');

            var eventosReplicar = (from p in bd.db._agendas
                                   where p.dataHora.Value.Month == int.Parse(mesReplicar[0]) &&
                                   p.dataHora.Value.Year == int.Parse(mesReplicar[1])
                                   select p).ToList();


            if (eventosReplicar.Count > 0)
            {
                for (int i = 0; i < eventosReplicar.Count; i++)
                {
                    //montar data
                    string   dt       = eventosReplicar[i].dataHora.Value.Day + "/" + mesReceber[0] + "/" + mesReceber[1] + " " + eventosReplicar[i].dataHora.Value.TimeOfDay;
                    DateTime dataNova = DateTime.Parse(dt);

                    _agenda a = new _agenda();
                    a.dataHora      = dataNova;
                    a.encarregadoID = eventosReplicar[i].encarregadoID;
                    a.eventoID      = eventosReplicar[i].eventoID;
                    a.igrejaID      = eventosReplicar[i].igrejaID;
                    a.telefone      = eventosReplicar[i].telefone;

                    bd.db._agendas.InsertOnSubmit(a);
                    bd.db.SubmitChanges();
                }
            }

            txtMesReplicar.Text = string.Empty;
            txtMesReceber.Text  = string.Empty;

            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alerta", "alert('" + eventosReplicar.Count + " Compromissos replicados!!');", true);
        }
        catch (Exception er4)
        {
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alerta", "alert('" + er4.Message + "');", true);
        }
    }