public override int Update(Entity entity, DataTransaction tran)
{
DataEntities.SpMedicoUpd sp = new DataEntities.SpMedicoUpd();
Entities.Medico item = entity as Entities.Medico;
sp.IdMedico = item.ID;
sp.Nombre = item.Nombre;
sp.ApellidoP = item.ApellidoP;
sp.ApellidoM = item.ApellidoM;
sp.Edad = item.Edad;
sp.FechaNac = item.FechaNac;
sp.EstadoCiv = item.EstadoCiv;
sp.Area = item.Area;
sp.Telefono1 = item.Telefono1;
sp.Telefono2 = item.Telefono2;
sp.Email = item.Email;
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.Medico Med = new Business.Medico();
valido = ValidarDatos();
if (valido == true)
{
Entities.Medico M = new Entities.Medico(IdMedico != 0);
M.ID = this.IdMedico;
M.Nombre = txtNombre.Text;
M.ApellidoP = txtApPaterno.Text;
M.ApellidoM = txtApMaterno.Text;
M.Edad = int.Parse(txtEdad.Text);
M.EstadoCiv = cmbEstado.Text;
M.Area = cmbArea.Text;
M.Telefono1 = txtTel.Text;
M.Telefono2 = txtTel2.Text;
M.Email = txtCorreo.Text;
M.FechaNac = dateTimePicker1.Value;
Med.Save(M);
this.Close();
}
}
public List <Entities.Medico> LsitaMedico(string Buscar)
{
List <Entities.Medico> list = new List <Entities.Medico>();
DataEntities.SpMedicoGrd sp = new DataEntities.SpMedicoGrd();
sp.Buscar = Buscar;
DataTable dt = sp.GetDataTable(this.ConnectionString);
foreach (DataRow dr in dt.Rows)
{
Entities.Medico item = new Entities.Medico(true);
item.ID = Utils.GetDataRowValue(dr, "IdMedico", 0);
item.Nombre = Utils.GetDataRowValue(dr, "Nombre", "");
item.ApellidoP = Utils.GetDataRowValue(dr, "ApellidoP", "");
item.ApellidoM = Utils.GetDataRowValue(dr, "ApellidoM", "");
item.Edad = Utils.GetDataRowValue(dr, "Edad", 0);
item.FechaNac = Utils.GetDataRowValue(dr, "FechaNac", DateTime.MinValue);
item.EstadoCiv = Utils.GetDataRowValue(dr, "EstadoCiv", "");
item.Area = Utils.GetDataRowValue(dr, "Area", "");
item.Telefono1 = Utils.GetDataRowValue(dr, "Telefono1", "");
item.Telefono2 = Utils.GetDataRowValue(dr, "Telefono2", "");
item.Email = Utils.GetDataRowValue(dr, "Email", "");
list.Add(item);
}
return(list);
}
private void Editar()
{
Entities.Medico Med = ObtenerEmpleadoSeleccionado();
if (Med != null)
{
EmpleadosEdit New = new EmpleadosEdit();
New.IdMedico = Med.ID;
New.ShowDialog();
LLenarGrid();
}
}
private void EliminarEmpleado()
{
Entities.Medico Med = ObtenerEmpleadoSeleccionado();
Business.Medico bo = new Business.Medico();
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.SpMedicoDel sp = new DataEntities.SpMedicoDel();
Entities.Medico item = entity as Entities.Medico;
sp.IdMedico = item.ID;
int rowsAffected = 0;
if (tran != null)
{
rowsAffected = sp.ExecuteNonQuery(tran);
}
else
{
rowsAffected = sp.ExecuteNonQuery(this.ConnectionString);
} return(rowsAffected);
}
public List <Entities.Medico> ComboMedico()
{
List <Entities.Medico> list = new List <Entities.Medico>();
DataEntities.SpMedicoCmb sp = new DataEntities.SpMedicoCmb();
DataTable dt = sp.GetDataTable(this.ConnectionString);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Entities.Medico item = new Entities.Medico(true);
item.ID = Utils.GetDataRowValue(dr, "IdMedico", 0);
item.NombreCompleto = Utils.GetDataRowValue(dr, "NombreCompleto", "");
list.Add(item);
}
}
return(list);
}
private void CargarDatos()
{
if (IdMedico != 0)
{
Entities.Medico Med = new Entities.Medico(true);
Med.ID = this.IdMedico;
Business.Medico bo = new Business.Medico();
bo.PrepareEntityForEdition(Med);
this.txtNombre.Text = Med.Nombre;
this.txtApPaterno.Text = Med.ApellidoP;
this.txtApMaterno.Text = Med.ApellidoM;
this.txtEdad.Text = Med.Edad.ToString();
this.txtTel.Text = Med.Telefono1;
this.txtTel2.Text = Med.Telefono2;
this.txtCorreo.Text = Med.Email;
this.cmbArea.SelectedText = Med.Area;
this.cmbEstado.SelectedText = Med.EstadoCiv;
}
}
public override void PrepareEntityForEdition(Entity entity)
{
Entities.Medico item = entity as Entities.Medico;
DataEntities.SpMedicoSel sp = new DataEntities.SpMedicoSel();
sp.IdMedico = 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.ApellidoP = Utils.GetDataRowValue(dr, "ApellidoP", "");
item.ApellidoM = Utils.GetDataRowValue(dr, "ApellidoM", "");
item.Edad = Utils.GetDataRowValue(dr, "Edad", 0);
item.FechaNac = Utils.GetDataRowValue(dr, "FechaNac", DateTime.MinValue);
item.EstadoCiv = Utils.GetDataRowValue(dr, "EstadoCiv", "");
item.Area = Utils.GetDataRowValue(dr, "Area", "");
item.Telefono1 = Utils.GetDataRowValue(dr, "Telefono1", "");
item.Telefono2 = Utils.GetDataRowValue(dr, "Telefono2", "");
item.Email = Utils.GetDataRowValue(dr, "Email", "");
}
}
