public List <Entities.Agenda> ListaAgenda(string Buscar) { List <Entities.Agenda> list = new List <Entities.Agenda>(); DataEntities.SpAgendaGrd sp = new DataEntities.SpAgendaGrd(); sp.Buscar = Buscar; DataTable dt = sp.GetDataTable(this.ConnectionString); foreach (DataRow dr in dt.Rows) { Entities.Agenda item = new Entities.Agenda(true); item.ID = Utils.GetDataRowValue(dr, "IdContacto", 0); item.Nombre = Utils.GetDataRowValue(dr, "Nombre", ""); item.ApPaterno = Utils.GetDataRowValue(dr, "ApPaterno", ""); item.ApMaterno = Utils.GetDataRowValue(dr, "ApMaterno", ""); item.Telefeno1 = Utils.GetDataRowValue(dr, "Telefeno1", ""); item.Telefeno2 = Utils.GetDataRowValue(dr, "Telefeno2", ""); item.Email = Utils.GetDataRowValue(dr, "Email", ""); item.Direccion = Utils.GetDataRowValue(dr, "Direccion", ""); list.Add(item); } return(list); }
private void Editar() { Entities.Agenda Med = Obtener(); if (Med != null) { AgendaEdit New = new AgendaEdit(); New.IdContacto = Med.ID; New.ShowDialog(); LLenarGrid(); } }
private void Eliminar() { Entities.Agenda Med = Obtener(); Business.Agenda bo = new Business.Agenda(); if (Med != null) { DialogResult mnsj = MessageBox.Show("¿Desea eliminar el registro seleccionado?", "", MessageBoxButtons.YesNo); if (mnsj == DialogResult.Yes) { bo.Delete(Med); LLenarGrid(); } } }
public override int Delete(Entity entity, DataTransaction tran) { DataEntities.SpAgendaDel sp = new DataEntities.SpAgendaDel(); Entities.Agenda item = entity as Entities.Agenda; sp.IdContacto = item.ID; int rowsAffected = 0; if (tran != null) { rowsAffected = sp.ExecuteNonQuery(tran); } else { rowsAffected = sp.ExecuteNonQuery(this.ConnectionString); } return(rowsAffected); }
private void CargarDatos() { if (IdContacto != 0) { Entities.Agenda Med = new Entities.Agenda(true); Med.ID = this.IdContacto; Business.Agenda bo = new Business.Agenda(); bo.PrepareEntityForEdition(Med); this.txtNombre.Text = Med.Nombre; this.txtApPaterno.Text = Med.ApPaterno; this.txtApMaterno.Text = Med.ApMaterno; this.txtTel.Text = Med.Telefeno1; this.txtTel2.Text = Med.Telefeno2; this.txtCorreo.Text = Med.Email; this.txtDirecion.Text = Med.Direccion; } }
public override void PrepareEntityForEdition(Entity entity) { Entities.Agenda item = entity as Entities.Agenda; DataEntities.SpAgendaSel sp = new DataEntities.SpAgendaSel(); sp.IdContacto = item.ID; DataTable dt = sp.GetDataTable(this.ConnectionString); if (dt.Rows.Count == 1) { DataRow dr = dt.Rows[0]; item.Nombre = Utils.GetDataRowValue(dr, "Nombre", ""); item.ApPaterno = Utils.GetDataRowValue(dr, "ApPaterno", ""); item.ApMaterno = Utils.GetDataRowValue(dr, "ApMaterno", ""); item.Telefeno1 = Utils.GetDataRowValue(dr, "Telefeno1", ""); item.Telefeno2 = Utils.GetDataRowValue(dr, "Telefeno2", ""); item.Email = Utils.GetDataRowValue(dr, "Email", ""); item.Direccion = Utils.GetDataRowValue(dr, "Direccion", ""); } }
public List <Entities.Agenda> Combo() { List <Entities.Agenda> list = new List <Entities.Agenda>(); DataEntities.SpAgendaCmb sp = new DataEntities.SpAgendaCmb(); DataTable dt = sp.GetDataTable(this.ConnectionString); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { Entities.Agenda item = new Entities.Agenda(true); item.ID = Utils.GetDataRowValue(dr, "IdContacto", 0); item.Nombre = Utils.GetDataRowValue(dr, "NombreCompleto", ""); list.Add(item); } } return(list); }
public override int Update(Entity entity, DataTransaction tran) { DataEntities.SpAgendaUpd sp = new DataEntities.SpAgendaUpd(); Entities.Agenda item = entity as Entities.Agenda; sp.IdContacto = item.ID; sp.Nombre = item.Nombre; sp.ApPaterno = item.ApPaterno; sp.ApMaterno = item.ApMaterno; sp.Telefeno1 = item.Telefeno1; sp.Telefeno2 = item.Telefeno2; sp.Email = item.Email; sp.Direccion = item.Direccion; int rowsAffected = 0; if (tran != null) { rowsAffected = sp.ExecuteNonQuery(tran); } else { rowsAffected = sp.ExecuteNonQuery(this.ConnectionString); } return(rowsAffected); }
private void btnSave_Click(object sender, EventArgs e) { ValidarDatos(); bool valido; Business.Agenda Med = new Business.Agenda(); valido = ValidarDatos(); if (valido == true) { Entities.Agenda M = new Entities.Agenda(IdContacto != 0); M.ID = this.IdContacto; M.Nombre = txtNombre.Text; M.ApPaterno = txtApPaterno.Text; M.ApMaterno = txtApMaterno.Text; M.Telefeno1 = txtTel.Text; M.Telefeno2 = txtTel2.Text; M.Email = txtCorreo.Text; M.Direccion = txtDirecion.Text; Med.Save(M); this.Close(); } }