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