public void LoadObject(int IdObject) { try { EmployeeBLL EmployeeBLL = new EmployeeBLL(); if (EmployeeBLL.GetIdEntity(IdObject) != null) { EmployeeML Employee = EmployeeBLL.GetIdEntity(IdObject); textBoxNumControl.Text = Employee.Id.ToString(); textBoxNombre.Text = Employee.Name.ToString(); textBoxApellidoP.Text = Employee.LastName.ToString(); DepartamentBLL DepartamentBLL = new DepartamentBLL(); DepartamentML Departament = DepartamentBLL.GetIdEntity(Employee.IdDepartament); textBoxDepartamento.Text = Departament.Name.ToString(); JobBLL JobBLL = new JobBLL(); JobML Job = JobBLL.GetIdEntity(Employee.IdJob); textBoxPuesto.Text = Job.Name; } else { cFAT100010 Alert = new cFAT100010("Información", "El empleado no existe", MessageBoxIcon.Information); Alert.ShowDialog(); } } catch (Exception ex) { MessageBox.Show(String.Format("LoadObject: {0}", ex), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonGuardar_Click(object sender, EventArgs e) { try { if (FormValidate()) { DepartamentML Departament = new DepartamentML(); Departament.Name = textBoxNombre.Text; Departament.Manager = textBoxEncargado.Text; Departament.Description = textBoxDescripcion.Text; if (IdDepartament > 0) { Departament.Id = IdDepartament; } DepartamentBLL.Save(Departament); cFMDE100010 FrmDataGrid = this.Owner as cFMDE100010; FrmDataGrid.LoadDataGridView(); cFAT100010 Alert = new cFAT100010("Información", "Información Guardado con exito!!", MessageBoxIcon.Information); Alert.ShowDialog(); Clear(); this.Close(); } } catch (Exception ex) { MessageBox.Show(String.Format("buttonGuardar_Click: {0}", ex.Message), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonEliminar_Click(object sender, EventArgs e) { try { if (dataGridViewDepartamento.RowCount > 0) { IdRowSelect = dataGridViewDepartamento.CurrentRow.Index; int idDepartament = Int32.Parse(dataGridViewDepartamento.Rows[IdRowSelect].Cells["Id"].Value.ToString()); cFAT100010 Alert = new cFAT100010("Información", String.Format("¿Desea eliminar el registro {0}?", idDepartament), MessageBoxIcon.Question); Alert.ShowDialog(); if (Alert.DialogResult == DialogResult.Yes) { DepartamentML Departament = new DepartamentML { Id = idDepartament, }; DepartamentBLL.Delete(Departament); dataGridViewDepartamento.Rows.Remove(dataGridViewDepartamento.CurrentRow); } } else { cFAT100010 Alert = new cFAT100010("Información", "No hay datos", MessageBoxIcon.Information); Alert.ShowDialog(); } } catch (Exception ex) { MessageBox.Show(String.Format("buttonEliminar_Click: {0}", ex), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Delete(DepartamentML departament) { try { DepartamentDAL.Delete(departament); } catch (Exception ex) { throw new Exception(String.Format("{0}.Delete: {1}", core, ex)); } }
private void buttonEliminar_Click(object sender, EventArgs e) { try { IdRowSelect = dataGridViewData.CurrentRow.Index; DepartamentML Departament = new DepartamentML(); Departament.Id = Int32.Parse(dataGridViewData.Rows[IdRowSelect].Cells["Id"].Value.ToString()); Departament.IdUserDelete = 1; DepartamentBLL.Delete(Departament); dataGridViewData.Rows.Remove(dataGridViewData.CurrentRow); } catch (Exception ex) { MessageBox.Show(String.Format("buttonEliminar_Click: {0}", ex), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public int Save(DepartamentML departament) { try { if (departament.Id == 0) { return(DepartamentDAL.Save(departament)); } else { return(DepartamentDAL.Update(departament)); } } catch (Exception ex) { throw new Exception(String.Format("{0}.Save: {1}", core, ex)); } }
public void Delete(DepartamentML Departament) { try { ModelDAL ModelDAL = new ModelDAL(); String Response = ModelDAL.DeleteModel(Departament, TableName, IdUserSession); SqlConnection Conexion = new SqlConnection() { ConnectionString = ConnectionString }; Conexion.Open(); SqlCommand cmd2 = new SqlCommand(Response.ToString(), Conexion); cmd2.ExecuteNonQuery(); Conexion.Close(); } catch (Exception ex) { throw new Exception(String.Format("{0}.delete: {1}", core, ex)); } }
public int Save(DepartamentML Departament) { ModelDAL data = new ModelDAL(); String Response = data.InsertModel(Departament, TableName, IdUserSession); SqlConnection Conexion = new SqlConnection { ConnectionString = ConnectionString }; using (SqlCommand cmd2 = new SqlCommand(Response.ToString(), Conexion)) { Conexion.Open(); int newID = (Int32)cmd2.ExecuteScalar(); if (Conexion.State == System.Data.ConnectionState.Open) { Conexion.Close(); } return(newID); } }
public DepartamentML GetDepartament(DataRow row) { try { if (row != null) { DepartamentML Departament = new DepartamentML() { Id = (row[DepartamentML.DataBase.Id] != DBNull.Value) ? int.Parse(row[DepartamentML.DataBase.Id].ToString()) : 0, Name = (row[DepartamentML.DataBase.Name] != DBNull.Value) ? row[DepartamentML.DataBase.Name].ToString() : string.Empty, Manager = (row[DepartamentML.DataBase.Manager] != DBNull.Value) ? row[DepartamentML.DataBase.Manager].ToString() : string.Empty, Description = (row[DepartamentML.DataBase.Description] != DBNull.Value) ? row[DepartamentML.DataBase.Description].ToString() : string.Empty }; return(Departament); } return(null); } catch (Exception ex) { throw new Exception(String.Format("{0}.GetDepartament : {1}", core, ex)); } }