private void btnBuscar_Click(object sender, RoutedEventArgs e)
{
a = new Agenda();
if (!string.IsNullOrEmpty(txtNome.Text))
{
a.Aula = txtNome.Text;
a = AgendaDAO.VerificaAgendaPorNome(a);
if (a != null)
{
txtNome.Text = a.Aula;
DtInicial.Text = a.DataInicio;
DtFinal.Text = a.DataFinal;
cmbInstrutor.SelectedValue = a.Instrutor;
HabilitarBotoes();
}
else
{
MessageBox.Show("Aula não encontrado!", "Busca Aula",
MessageBoxButton.OK, MessageBoxImage.Information);
}
}
else
{
MessageBox.Show("Favor preencher o campo da busca", "Busca Aula",
MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void btnGravar_Click(object sender, RoutedEventArgs e)
{
a = new Agenda();
a.Aula = txtNome.Text;
a.DataInicio = DtInicial.Text;
a.DataFinal = DtFinal.Text;
a.Instrutor = (int)cmbInstrutor.SelectedValue;
if (AgendaDAO.AdicionarAgenda(a))
{
MessageBox.Show("Gravado com sucesso!", "Cadastro de Agenda",
MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Não foi possível gravar!", "Cadastro de Agenda",
MessageBoxButton.OK, MessageBoxImage.Error);
}
txtNome.Clear();
DtInicial.Text = null;
DtFinal.Text = null;
cmbInstrutor.Text = null;
}
public Status getOne(int agendaID, out AgendaInfo agenda)
{
agenda = new AgendaInfo();
AgendaDAO agendaDao = Factory.getInstance <AgendaDAO>();
AgendaVO agendaVo = agendaDao.getOne <AgendaVO>(agendaID);
if (agendaVo == null)
{
return(Status.NONFOUND);
}
PersonDAO personDao = Factory.getInstance <PersonDAO>();
PersonVO personVo = personDao.getOne <PersonVO>(agendaVo.personID);
if (personVo == null)
{
return(Status.FAILURE);
}
agenda.agendaID = agendaVo.agendaID;
agenda.agendaName = agendaVo.agendaName;
agenda.agendaDuration = agendaVo.agendaDuration;
agenda.userName = personVo.personName;
agenda.meetingID = agendaVo.meetingID;
return(Status.SUCCESS);
}
protected bool checkOverlap()
{
if (txtDiaFinal.Value == "" || txtDiaComienzo.Value == "")
{
return(true);
}
var lAgendas = AgendaDAO.GetAll();
var actual = new Tabla_Registro_AgendaDTO();
actual.Inicio_Agenda = Convert.ToDateTime(txtDiaComienzo.Value);
DateTime fechaAgendaFinal1 = Convert.ToDateTime(txtDiaFinal.Value);
actual.Fin_Agenda = actual.Inicio_Agenda.Date + fechaAgendaFinal1.TimeOfDay;
var tEndB = actual.Fin_Agenda;
var tStartB = actual.Inicio_Agenda;
foreach (var y in lAgendas)
{
var tStartA = y.Inicio_Agenda;
var tEndA = y.Fin_Agenda;
var overlap = tStartA < tEndB && tStartB < tEndA;
if (overlap)
{
return(true);
}
}
return(false);
}
private void preencherListagem()
{
int idMedico = 1; // Id do medico da tela
List <Agenda> listaAgendaBanco = AgendaDAO.BuscarListagemPorMedico(idMedico);
int test = 0;
foreach (Agenda a in listaAgendaBanco)
{
agendas.Add(new
{
Paciente = a.Paciente.Nome,
DataAgendada = a.DataAgendada,
HoraAgendada = a.HoraAgendada,
Plano = a.Plano,
idPaciente = a.Paciente.IdPaciente,
idMedico = a.Medico.IdMedico
});
}
test = 1;
dtgAgendaMedico.ItemsSource = agendas;
dtgAgendaMedico.Items.Refresh();
test = 2;
//itens.Add(new
//{
// Nome = produto.Nome,
// Preco = produto.Preco.ToString("C2"),
// Quantidade = Convert.ToInt32(txtQuantidade.Text),
// Subtotal =
// (Convert.ToInt32(txtQuantidade.Text) * produto.Preco).ToString("C2")
//});
}
private void btnAlterar_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Deseja alterar o registro?", "Alterar Instrutor",
MessageBoxButton.YesNo, MessageBoxImage.Question) ==
MessageBoxResult.Yes)
{
a.Aula = txtNome.Text;
a.DataInicio = DtInicial.Text;
a.DataFinal = DtFinal.Text;
a.Instrutor = (int)cmbInstrutor.SelectedValue;
if (AgendaDAO.AlterarAgenda(a))
{
MessageBox.Show("Aula alterada com sucesso", "Altera Aula", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Aula não alterado!", "Altera Aula", MessageBoxButton.OK, MessageBoxImage.Error);
}
DesabilitarBotoes();
}
else
{
DesabilitarBotoes();
}
txtNome.Clear();
DtInicial.Text = null;
DtFinal.Text = null;
cmbInstrutor.Text = null;
}
private void AgendarConsulta()
{
DateTime data = dtpDtaAgendamento.DisplayDate;
string hora = cboHorario.Text;
string plano = txtPlanoPaciente.Text;
int idMed = (int)cboMedico.SelectedValue;
int idPac = Convert.ToInt32(txtNPac.Text);
ag.DataAgendada = data;
ag.HoraAgendada = hora;
ag.Paciente = PacienteDAO.BuscarPacientePorId(idPac);
ag.Cpf = PacienteDAO.BuscarPacientePorId(idPac);
ag.Plano = plano;
ag.Medico = MedicoDAO.BuscarMedicoPorId(idMed);
ag.Especialidade = MedicoDAO.BuscarMedicoPorId(idMed);
string msgCadastrou = AgendaDAO.CadastrarAgenda(ag);
if (msgCadastrou == null)
{
ag = new Agenda();
MessageBox.Show("Consulta agendada!");
this.Close();
}
else
{
MessageBox.Show(msgCadastrou);
}
}
private void btnRemover_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Deseja remover o registro?", "Remover de Instrutor",
MessageBoxButton.YesNo, MessageBoxImage.Question) ==
MessageBoxResult.Yes)
{
if (AgendaDAO.RemoverAgenda(a))
{
MessageBox.Show("Aula removido com sucesso", "Remover Aula", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Aula não removido!", "Remover Aula", MessageBoxButton.OK, MessageBoxImage.Error);
}
DesabilitarBotoes();
}
else
{
DesabilitarBotoes();
}
txtNome.Clear();
DtInicial.Text = null;
DtFinal.Text = null;
cmbInstrutor.Text = null;
}
public Status update(UpdateAgenda updateAgenda)
{
AgendaDAO agendaDao = Factory.getInstance <AgendaDAO>();
AgendaVO agendaVo = agendaDao.getOne <AgendaVO>(updateAgenda.agendaID);
if (agendaVo == null)
{
return(Status.NONFOUND);
}
//初始化会议操作
meeting_initOperator(agendaVo.meetingID);
//判断会议是否开启，如果正在开启，直接退出
if (meeting_isOpening())
{
return(Status.MEETING_OPENING);
}
else if (meeting_isOpended())//如果会议已结束，直接退出
{
return(Status.FAILURE);
}
Dictionary <string, object> setlist = new Dictionary <string, object>();
setlist.Add("agendaName", updateAgenda.agendaName);
setlist.Add("agendaDuration", updateAgenda.agendaDuration);
setlist.Add("personID", updateAgenda.userID);
if (agendaDao.update(setlist, updateAgenda.agendaID) < 0)
{
return(Status.FAILURE);
}
return(Status.SUCCESS);
}
protected void btnSave(object sender, EventArgs e)
{
string prioridad = "Normal";
if (rbUrgente.Checked)
{
prioridad = "Urgente";
}
Tabla_Registro_AgendaDTO oneAgenda = new Tabla_Registro_AgendaDTO();
oneAgenda.Id_FichaIdentificacion = Id_FichaIdentificacion;
oneAgenda.Asunto_Agenda = txtasunto.Text;
oneAgenda.Id_Categoria = Convert.ToInt32(ddlCategoria.SelectedItem.Value);
oneAgenda.Prioridad_Agenda = prioridad;
oneAgenda.Fecha_Agenda = DateTime.Now;
oneAgenda.Inicio_Agenda = Convert.ToDateTime(txtDiaComienzo.Value);
oneAgenda.Fin_Agenda = Convert.ToDateTime(txtDiaFinal.Value);
oneAgenda.Descripcion_Agenda = txtdescripcionagenda.Text;
oneAgenda.EstadoCitas_Agenda = DropDownEstadoCitas.SelectedItem.Text;
AgendaDAO Insert = new AgendaDAO();
Insert.Insert(oneAgenda);
oneAgenda = Insert.GetLastById_Ficha(oneAgenda);
NotaClinicaDTO oneConsulta = new NotaClinicaDTO();
oneConsulta.Id_Agenda = oneAgenda.Id_Agenda;
oneConsulta.Id_FichaIdentificacion = oneAgenda.Id_FichaIdentificacion;
oneConsulta.Fecha_Consulta = DateTime.Now;
NotaClinicaDAO InsertConsulta = new NotaClinicaDAO();
InsertConsulta.Insert(oneConsulta);
}
public ActionResult IndexAgendaFuncionario()
{
AgendaDAO daoAgenda = new AgendaDAO();
var horarios = daoAgenda.ListarHorarioAtendimento();
ViewBag.Horarios = horarios;
var agendamentos = daoAgenda.ListarAgendamentos();
ViewBag.Cont = agendamentos.Count();
ViewBag.Agenda = agendamentos;
ServicoDAO daoServico = new ServicoDAO();
var servico = daoServico.ListaServicos();
ViewBag.Servico = servico;
FuncionarioDAO daoFuncionarios = new FuncionarioDAO();
var funcionarios = daoFuncionarios.ListarFuncionarios();
int cont = funcionarios.Count();
ViewBag.ContFun = cont;
return(View(horarios));
}
private void ckbNotificar_CheckedChanged(object sender, EventArgs e)
{
CheckBox ckbNotificar = new CheckBox();
ckbNotificar = (CheckBox)sender;
int posicao = Convert.ToInt32(ckbNotificar.Name.Replace("ckbNotificar", ""));
agendaVO = new AgendaVO();
agendaVO = listAgenda[posicao];
AgendaDAO.AtualizarRegistro(agendaVO);
FlowLayoutPanel flpAgendamentos = (FlowLayoutPanel)(ckbNotificar.FindForm().Controls.Find("flpAgendamentos", false)[0]);
if (ckbNotificar.FindForm().Name == "frPrincipal")
{
AtualizaStatus(flpAgendamentos);
ExibeAgendamentos(flpAgendamentos, Enum_TipoExibicaoAgenda.hoje);
}
else if (ckbNotificar.FindForm().Name == "frAgendados")
{
if ((ckbNotificar.FindForm().Controls.Find("panSemana", false)) != null)
{
ExibeAgendamentos(flpAgendamentos, Enum_TipoExibicaoAgenda.semana);
}
else if ((ckbNotificar.FindForm().Controls.Find("panSemana", false)) != null)
{
ExibeAgendamentos(flpAgendamentos, Enum_TipoExibicaoAgenda.mes);
}
}
}
private void ptbCancelar_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Este agendamento foi cancelado?", "Questão", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
PictureBox ptbCancelar = new PictureBox();
ptbCancelar = (PictureBox)sender;
int posicao = Convert.ToInt32(ptbCancelar.Name.Replace("ptbCancelar", ""));
agendaVO = new AgendaVO();
agendaVO = listAgenda[posicao];
agendaVO.Status = 'N';
AgendaDAO.AtualizarRegistro(agendaVO);
FlowLayoutPanel flpAgendamentos = (FlowLayoutPanel)(ptbCancelar.FindForm().Controls.Find("flpAgendamentos", false)[0]);
if (ptbCancelar.FindForm().Name == "frPrincipal")
{
listAgenda.Remove(agendaVO);
AtualizaStatus(flpAgendamentos);
ExibeAgendamentos(flpAgendamentos, Enum_TipoExibicaoAgenda.hoje);
}
else if (ptbCancelar.FindForm().Name == "frAgendados")
{
if ((ptbCancelar.FindForm().Controls.Find("panSemana", false)) != null)
{
ExibeAgendamentos(flpAgendamentos, Enum_TipoExibicaoAgenda.semana);
}
else if ((ptbCancelar.FindForm().Controls.Find("panSemana", false)) != null)
{
ExibeAgendamentos(flpAgendamentos, Enum_TipoExibicaoAgenda.mes);
}
}
}
else
{
return;
}
}
public ActionResult IndexHomeFuncionario()
{
AgendaDAO daoAgenda = new AgendaDAO();
var agendamentos = daoAgenda.ListarAgendamentos();
ViewBag.Agendamentos = agendamentos;
var horarios = daoAgenda.ListarHorarioAtendimento();
ViewBag.Horarios = horarios;
var qtdAgendamentos = daoAgenda.ContaAgendamentos();
ViewBag.Agenda = qtdAgendamentos;
FuncionarioDAO daoFuncionarios = new FuncionarioDAO();
var funcionarios = daoFuncionarios.ListarFuncionarios();
ViewBag.contaFun = funcionarios.Count();
LucroAgendamentoDAO Lucro = new LucroAgendamentoDAO();
ViewBag.LucroMensal = Lucro.LucroMensal();
return(View(agendamentos));
}
public Status create(CreateAgenda createAgenda)
{
//初始化会议操作
meeting_initOperator(createAgenda.meetingID);
bool isUpdate = false;
//判断会议是否开启，如果开启，更新“议程更新状态”，数据设置更新状态
if (meeting_isOpening())
{
meeting_updateAgenda();
isUpdate = true;
}
else if (meeting_isOpended())//如果会议已结束，直接退出
{
return(Status.FAILURE);
}
AgendaDAO agendaDao = Factory.getInstance <AgendaDAO>();
MeetingDAO meetingDao = Factory.getInstance <MeetingDAO>();
Dictionary <string, object> wherelist = new Dictionary <string, object>();
//获取当前议程的个数
wherelist.Clear();
wherelist.Add("meetingID", createAgenda.meetingID);
List <AgendaVO> agendaVolist = agendaDao.getAll <AgendaVO>(wherelist);
//获取新议程的ID
int agendaID = AgendaDAO.getID();
//设置新的议程编号
int agendaIndex = agendaVolist == null ? 1 : agendaVolist.Count + 1;
//添加议程
AgendaVO agendaVo = new AgendaVO
{
agendaID = agendaID,
agendaName = createAgenda.agendaName,
agendaDuration = createAgenda.agendaDuration,
agendaIndex = agendaIndex,
meetingID = createAgenda.meetingID,
personID = createAgenda.userID,
isUpdate = isUpdate //判断是否属于会议中新加入的信息
};
if (agendaDao.insert <AgendaVO>(agendaVo) < 0)
{
return(Status.DATABASE_OPERATOR_ERROR);
}
else
{
if (meetingDao.increateDuration(agendaVo.meetingID, agendaVo.agendaDuration) < 0)
{
agendaDao.delete(agendaID);
return(Status.DATABASE_OPERATOR_ERROR);
}
}
return(Status.SUCCESS);
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="delegates"></param>
/// <returns></returns>
public Status deleteMultipe(List <int> delegates)
{
if (delegates == null || delegates.Count == 0)
{
return(Status.SUCCESS);
}
//用于出错后恢复数据
var backup = new List <DelegateVO>();
Status status = Status.SUCCESS;
DelegateDAO delegateDao = Factory.getInstance <DelegateDAO>();
AgendaDAO agendaDao = Factory.getInstance <AgendaDAO>();
foreach (int delegateID in delegates)
{
DelegateVO delegateVo = delegateDao.getOne <DelegateVO>(delegateID);
if (delegateVo == null)
{
status = Status.NONFOUND;
}
//初始化会议操作
meeting_initOperator(delegateVo.meetingID);
//判断会议是否开启，如果不是”未开启“，直接退出
if (!meeting_isNotOpen())
{
status = Status.MEETING_OPENING;
break;
}
Dictionary <string, object> wherelist = new Dictionary <string, object>();
//检查是否为主讲人，且是否存在主讲的议程，如果存在，直接返回
wherelist.Clear();
wherelist.Add("meetingID", delegateVo.meetingID);
wherelist.Add("personID", delegateVo.personID);
var tempAgenda = agendaDao.getAll <AgendaVO>(wherelist);
if (tempAgenda != null && tempAgenda.Count > 0)
{
status = Status.DELEGATE_USED;
break;
}
backup.Add(delegateVo);
if (delegateDao.delete(delegateID) < 0)//删除失败就 恢复数据，返回
{
status = Status.FAILURE;
break;
}
}
if (status != Status.SUCCESS)
{
foreach (var delegateVo in backup)
{
delegateDao.insert <DelegateVO>(delegateVo);
}
}
return(status);
}
public ActionResult Agendamentos()
{
AgendaDAO daoAgenda = new AgendaDAO();
var agendamentos = daoAgenda.ListarAgendamentos();
ViewBag.Agenda = agendamentos;
return(View(agendamentos));
}
public void loadToday()
{
var lAgenda = AgendaDAO.GetAll();
DateTime hoy = DateTime.Now;
lAgenda = lAgenda.Where(x => x.Inicio_Agenda.Date == hoy.Date).ToList();
bdgHoy.InnerText = lAgenda.Count.ToString();
rptProximas.DataSource = lAgenda;
rptProximas.DataBind();
}
public void Atualiza_listAgenda(DateTime data_ini, DateTime data_fim, char status1, char status2, char status3)
{
//listPanAgendamentos.Clear();
listAgenda = new List <AgendaVO>();
// select agendamentos
listAgenda = AgendaDAO.GetRegistros(String.Format("where a.data_hora between '{0}' and '{1}' and " +
"(a.status='{2}' or a.status='{3}' or a.status='{4}') " +
"order by a.data_hora",
data_ini.ToString(), data_fim.ToString(), status1, status2, status3));
}
public Status deleteMultipe(List <int> votes)
{
if (votes == null || votes.Count == 0)
{
return(Status.SUCCESS);
}
VoteDAO voteDao = Factory.getInstance <VoteDAO>();
VoteOptionDAO voteOptionDao = Factory.getInstance <VoteOptionDAO>();
AgendaDAO agendaDao = Factory.getInstance <AgendaDAO>();
Dictionary <string, object> wherelist = new Dictionary <string, object>();
foreach (int voteID in votes)
{
//获取表决信息
VoteVO voteVo = voteDao.getOne <VoteVO>(voteID);
if (voteVo == null)
{
continue;
}
//判断投票是否未开启,如果 不是”未开启“，直接退出
if (!IsNotOpen_Vote(voteVo.voteStatus))
{
return(Status.FAILURE);
}
//获取议程信息
AgendaVO agendaVo = agendaDao.getOne <AgendaVO>(voteVo.agendaID);
if (agendaVo == null)
{
continue;
}
//初始化会场操作
meeting_initOperator(agendaVo.meetingID);
//判断会议是否 未开启,如果 不是”未开启“，直接退出
if (!meeting_isNotOpen())
{
return(Status.FAILURE);
}
//删除选项
wherelist.Clear();
wherelist.Add("voteID", voteID);
voteOptionDao.delete(wherelist);
//更新其他投票的序号信息
voteDao.updateIndex(voteVo.agendaID, voteVo.voteIndex);
//删除当前投票
voteDao.delete(voteVo.voteID);
}
return(Status.SUCCESS);
}
public AgendaModel Salvar(AgendaModel oModel)
{
AgendaDAO oDAO = new AgendaDAO();
if (oModel.Codigo.HasValue)
{
return(oDAO.Alterar(oModel));
}
else
{
return(oDAO.Incluir(oModel));
}
}
public ActionResult AtualizarEstado(int id, string estado)
{
AgendaDAO dao = new AgendaDAO();
Agenda agendamento = dao.BuscarAgendamentoId(id);
agendamento.Estado = estado;
if (estado == "Cancelado")
{
dao.RemoverHorario(agendamento);
}
else
{
dao.AtualizarAgendamento(agendamento);
}
return(Json(true));
}
public List <Agenda> GetAgendaFrom(User _parObjLoggedUser)
{
try
{
var _objLstDatabaseAgendas = new AgendaDAO(new EntidadesContext()).Get(_parObjLoggedUser.Id);
var _objLstAgendas = new List <Agenda>();
foreach (var _objDatabaseAgenda in _objLstDatabaseAgendas)
{
_objLstAgendas.Add(DaoToModel(_objDatabaseAgenda));
}
return(_objLstAgendas);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult AgendarHorario(DateTime HoraSelecionada, DateTime Data, int ServicoId, int ClienteId)
{
Agenda agenda = new Agenda();
agenda.Horario = HoraSelecionada;
agenda.Data = Data;
agenda.ServicoId = ServicoId;
agenda.ClienteId = ClienteId;
agenda.Estado = "Agendado";
ViewBag.Agenda = agenda;
FuncionarioDAO daoFuncionarios = new FuncionarioDAO();
var funcionarios = daoFuncionarios.ListarFuncionarios();
int cont = funcionarios.Count();
ViewBag.Cont = cont;
AgendaDAO daoAgenda = new AgendaDAO();
int agendaProcura = daoAgenda.BuscarAgendamento(agenda.Horario, agenda.Data);
ViewBag.AgendamentoC = agendaProcura;
if (agenda.Data == null || agenda.Horario == null || agenda.ServicoId == null)
{
ModelState.AddModelError("agenda.CadastroEmBranco", "Não pode cadastrar um horário em branco");
}
if (agendaProcura == cont)
{
return(Json(false));
}
if (ModelState.IsValid)
{
return(Json(daoAgenda.AgendarHorario(agenda)));
}
else
{
ViewBag.Agenda = agenda;
ServicoDAO servicoDAO = new ServicoDAO();
ViewBag.Servico = servicoDAO.ListaServicos();
return(View("IndexAgenda"));
}
}
/// <summary>
/// 删除会议时使用
/// </summary>
/// <param name="meetingID"></param>
/// <returns></returns>
public Status deleteAll(int meetingID)
{
Dictionary <string, object> wherelist = new Dictionary <string, object>();
AgendaDAO agendaDao = Factory.getInstance <AgendaDAO>();
wherelist.Add("meetingID", meetingID);
List <AgendaVO> agendaVolist = agendaDao.getAll <AgendaVO>(wherelist);
if (agendaVolist != null)
{
DocumentService documentService = new DocumentService();
VoteService voteService = new VoteService();
foreach (AgendaVO agendaVo in agendaVolist)
{
documentService.deleteAll(agendaVo.agendaID);
voteService.deleteAll(agendaVo.agendaID);
agendaDao.delete(agendaVo.agendaID);
}
}
return(Status.SUCCESS);
}
//获取指定会议的议程
public Status getAll(int meetingID, out List <AgendaInfo> agendas)
{
agendas = new List <AgendaInfo>();
AgendaDAO agendaDao = Factory.getInstance <AgendaDAO>();
PersonDAO personDao = Factory.getInstance <PersonDAO>();
Dictionary <string, object> wherelist = new Dictionary <string, object>();
//获取指定会议的议程
wherelist.Add("meetingID", meetingID);
List <AgendaVO> AgendaVolist = agendaDao.getAll <AgendaVO>(wherelist);
if (AgendaVolist == null)
{
return(Status.SUCCESS);
}
foreach (AgendaVO agendaVo in AgendaVolist)
{
//获取主讲人信息
PersonVO personVo = personDao.getOne <PersonVO>(agendaVo.personID);
if (personVo == null)
{
return(Status.FAILURE);
}
//将信息插入到返回信息中
agendas.Add(
new AgendaInfo
{
agendaID = agendaVo.agendaID,
agendaName = agendaVo.agendaName,
agendaDuration = agendaVo.agendaDuration,
userName = personVo.personName,
meetingID = agendaVo.meetingID
});
}
return(Status.SUCCESS);
}
private void panConcluir_Click(object sender, EventArgs e)
{
#region Monta ClienteVO
ClienteVO clienteVO = new ClienteVO();
clienteVO.Id = ClienteId(txtNome.Text.Trim());
clienteVO.Nome = txtNome.Text.Trim();
clienteVO.Tel_cel = mkbTelCel.Text.Trim();
clienteVO.Email = txtEmail.Text.Trim();
clienteVO.Cpf = mkbCPF.Text.Trim();
clienteVO.Rg = txtRG.Text.Trim();
clienteVO.Endereco = txtEndereco.Text.Trim();
clienteVO.Bairro = txtBairro.Text.Trim();
clienteVO.Numero = txtNr.Text.Trim();
clienteVO.Cidade = txtCidade.Text.Trim();
clienteVO.Complemento = txtComplemento.Text.Trim();
#endregion
if (MessageBox.Show("Confirma o agendamento?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (new Carregando("Salvando Agendamento!"))
{
// 0 == Cliente Novo
if (VerificaClienteNovo(clienteVO.Nome) == 0)
{
try
{
ClienteDAO.InserirRegistros(clienteVO);
}
catch (Exception erro)
{
MessageBox.Show(erro.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
// 1 == Alteração de cadastro de cliente já existente
else
{
if (VerificaAlteracaoCliente(clienteVO.Id) == 1)
{
#region Mensagem
string msg = String.Format("Verifiquei você alterou dados do cliente: " +
"\n\nNome: {0}" +
"\nTel./Cel.: {1}" +
"\nEmail: {2}" +
"\nCPF: {3}" +
"\nRG: {4}" +
"\nEndereço: {5}" +
"\nN°: {6}" +
"\nBairro: {7}" +
"\nCidade: {8}" +
"\nComplemtento: {9}" +
"\n\nDeseja confirmar a atualização do cadastro?",
clienteVO.Nome,
clienteVO.Tel_cel,
clienteVO.Email,
clienteVO.Cpf,
clienteVO.Rg,
clienteVO.Endereco,
clienteVO.Numero,
clienteVO.Bairro,
clienteVO.Cidade,
clienteVO.Complemento);
#endregion
if (MessageBox.Show(msg, "Atualizar Cadastro?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
ClienteDAO.AtualizarRegistro(clienteVO);
MessageBox.Show("Cliente atualizado com sucesso!", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception erro)
{
MessageBox.Show(erro.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
return;
}
}
}
#region Monta AgendaVO
agendaVO.Id_cliente = clienteVO.Id;
agendaVO.Id_funcionario = funcionarioVOSelecionado.Id;
agendaVO.Id_venda = Convert.ToInt32(AgendaDAO.ExecutaSelect("select id from agenda order by id desc limit 1").Rows[0]["id"]) + 1;
agendaVO.Data = dtpData.Value;
agendaVO.Hora = Convert.ToDateTime(mkbHorario.Text);
agendaVO.Obs = "";
agendaVO.Status = 'P';
agendaVO.Itens = metodosAgendamento.listItens;
#endregion
AgendaDAO.InserirRegistros(agendaVO);
MessageBox.Show("Agendamento Salvo com sucesso!", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
public Status deleteMultipe(List <int> documents)
{
if (documents == null || documents.Count == 0)
{
return(Status.ARGUMENT_ERROR);
}
//出错后恢复数据
var backup = new List <FileVO>();
Status status = Status.SUCCESS;
FileDAO fileDao = Factory.getInstance <FileDAO>();
AgendaDAO agendaDao = Factory.getInstance <AgendaDAO>();
Dictionary <string, object> wherelist = new Dictionary <string, object>();
foreach (int documentID in documents)
{
//获取附件信息
FileVO fileVo = fileDao.getOne <FileVO>(documentID);
if (fileVo == null)
{
status = Status.NONFOUND;
break;
}
//获取议程信息
AgendaVO agendaVo = agendaDao.getOne <AgendaVO>(fileVo.agendaID);
if (agendaVo == null)
{
continue;
}
//初始化会议操作
meeting_initOperator(agendaVo.meetingID);
//判断会议是否 未开启,如果 不是”未开启“，直接退出
if (!meeting_isNotOpen())
{
return(Status.FAILURE);
}
//更新其他附件的序号信息
if (fileDao.updateIndex(fileVo.agendaID, fileVo.fileIndex) < 0)
{
status = Status.FAILURE;
break;
}
backup.Add(fileVo);
//删除当前附件
if (fileDao.delete(fileVo.fileID) < 0)
{
status = Status.FAILURE;
break;
}
}
if (status != Status.SUCCESS)
{
foreach (var fileVo in backup)
{
fileDao.insert <FileVO>(fileVo);
}
}
return(Status.SUCCESS);
}
public Status addFile(int agendaID, string fileName, long fileSize, string saveFileName)
{
int filesize = (int)((double)fileSize / 1024 + 0.5); //long转为int
AgendaDAO agendaDao = Factory.getInstance <AgendaDAO>();
AgendaVO agendaVo = agendaDao.getOne <AgendaVO>(agendaID);
if (agendaVo == null)
{
Log.DebugInfo("议程不存在");
return(Status.FAILURE);
}
//初始化会议操作
meeting_initOperator(agendaVo.meetingID);
bool isUpdate = false;
//判断会议是否开启，如果开启，更新“会议更新状态”，设置数据更新状态
if (meeting_isOpening())
{
meeting_updatefile();//这里file与document指代同一种事物
isUpdate = true;
}
else if (meeting_isOpended())//会议已结束,不允许添加
{
return(Status.FAILURE);
}
FileDAO fileDao = Factory.getInstance <FileDAO>();
Dictionary <string, object> wherelist = new Dictionary <string, object>();
//获取当前文件的个数
wherelist.Add("agendaID", agendaID);
List <FileVO> fileVolist = fileDao.getAll <FileVO>(wherelist);
//获取新文件的ID
int fileID = FileDAO.getID();
//设置新的文件编号
int fileIndex = fileVolist == null ? 1 : fileVolist.Count + 1;
//添加文件
FileVO fileVo = new FileVO
{
fileID = fileID,
fileName = fileName,
fileIndex = fileIndex,
fileSize = filesize,
filePath = saveFileName,
agendaID = agendaID,
isUpdate = isUpdate //判断是否属于会议中新加入的信息
};
Log.DebugInfo("待插入的文件路径:" + saveFileName);
int num = fileDao.insert <FileVO>(fileVo);
if (num < 0)
{
Log.DebugInfo("文件数据插入失败");
return(Status.FAILURE);
}
return(Status.SUCCESS);
}
public Status create(CreateVote vote)
{
//修正字符串
vote.voteName = vote.voteName.Trim();
vote.voteDescription = vote.voteDescription.Trim();
//检查参数格式
if (!checkFormat(vote.voteOptions))
{
return(Status.FORMAT_ERROR);
}
//验证当前用户的更新当前会议权限
AgendaDAO agendaDao = Factory.getInstance <AgendaDAO>();
AgendaVO agendaVo = agendaDao.getOne <AgendaVO>(vote.agendaID);
if (agendaVo == null)
{
return(Status.FAILURE);
}
//初始化会议操作
meeting_initOperator(agendaVo.meetingID);
bool isUpdate = false;
//判断会议是否开启，如果开启，更新"更新状态”,设置数据更新状态
if (meeting_isOpening())
{
meeting_updatevote();
isUpdate = true;
}
else if (meeting_isOpended())//如果会议已结束，直接退出
{
return(Status.FAILURE);
}
Dictionary <string, object> wherelist = new Dictionary <string, object>();
// 插入投票
VoteDAO voteDao = Factory.getInstance <VoteDAO>();
wherelist.Clear();
wherelist.Add("agendaID", vote.agendaID);
List <VoteVO> voteVolist = voteDao.getAll <VoteVO>(wherelist);
//设置新的投票编号
int voteIndex = voteVolist == null ? 1 : voteVolist.Count + 1;
// 先获取新的ID
int newVoteID = VoteDAO.getID();
if (voteDao.insert <VoteVO>(
new VoteVO
{
voteID = newVoteID,
voteIndex = voteIndex,
voteName = vote.voteName,
voteDescription = vote.voteDescription,
voteType = vote.voteType,
voteStatus = 0, // 未开
agendaID = vote.agendaID,
isUpdate = isUpdate
}) < 0)
{
return(Status.FAILURE);
}
// 插入投票选项列表
int index = 1;
VoteOptionDAO voteOptionDao = Factory.getInstance <VoteOptionDAO>();
if (vote.voteOptions != null)
{
HashSet <string> hs = new HashSet <string>(vote.voteOptions);
foreach (string voteOption in hs)
{
if (voteOptionDao.insert <VoteOptionVO>(
new VoteOptionVO
{
voteOptionID = VoteOptionDAO.getID(),
voteOptionName = voteOption,
voteOptionIndex = index,
voteID = newVoteID
}) < 0)
{
return(Status.FAILURE);
}
++index;
}
}
return(Status.SUCCESS);
}
