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 buttonEliminar_Click(object sender, EventArgs e) { try { if (dataGridViewDataPuesto.RowCount > 0) { IdRowSelect = dataGridViewDataPuesto.CurrentRow.Index; int IdJob = Int32.Parse(dataGridViewDataPuesto.Rows[IdRowSelect].Cells[JobML.DataBase.Id].Value.ToString()); cFAT100010 Alert = new cFAT100010("Información", String.Format("¿Desea eliminar el registro {0}?", IdJob), MessageBoxIcon.Question); Alert.ShowDialog(); if (Alert.DialogResult == DialogResult.Yes) { JobML Job = new JobML { Id = IdJob, }; JobBLL.Delete(Job); dataGridViewDataPuesto.Rows.Remove(dataGridViewDataPuesto.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 int Save(JobML Job) { try { ModelDAL ModelDAL = new ModelDAL(); String Response = ModelDAL.InsertModel(Job, 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); } } catch (Exception ex) { throw new Exception(String.Format("{0}.save : {1}", core, ex)); } }
public void Delete(JobML Job) { try { JobDAL.Delete(Job); } catch (Exception ex) { throw new Exception(String.Format("{0}.Delete: {1}", core, ex)); } }
private void ButtonSave_Click(object sender, EventArgs e) { JobML job = new JobML { Id = 0, Name = textBoxNombre.Text, Description = textBoxDescripcion.Text, //IdUserInsert = 1 }; JobBll.Save(job); }
public int Save(JobML Job) { try { if (Job.Id == 0) { return(JobDAL.Save(Job)); } else { return(JobDAL.Update(Job)); } } catch (Exception ex) { throw new Exception(String.Format("{0}.Save: {1}", core, ex)); } }
public void Delete(JobML Job) { try { ModelDAL ModelDAL = new ModelDAL(); String Response = ModelDAL.DeleteModel(Job, 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 JobML GetEntity(DataRow row) { try { if (row != null) { JobML Job = new JobML() { Id = (row[JobML.DataBase.Id] != DBNull.Value) ? int.Parse(row[JobML.DataBase.Id].ToString()) : 0, Name = (row[JobML.DataBase.Name] != DBNull.Value) ? row[JobML.DataBase.Name].ToString() : string.Empty, Description = (row[JobML.DataBase.Description] != DBNull.Value) ? row[JobML.DataBase.Description].ToString() : string.Empty }; return(Job); } return(null); } catch (Exception ex) { throw new Exception(String.Format("{0}.GetEntity : {1}", core, ex)); } }
private void buttonGuardar_Click(object sender, EventArgs e) { try { if (FormValidate()) { JobML Job = new JobML(); Job.Name = textBoxPuesto.Text; Job.Description = textBoxDescripcion.Text; if (IdJob > 0) { Job.Id = IdJob; Job.Name = textBoxPuesto.Text; Job.Description = textBoxDescripcion.Text; //Job.IdUserUpdate = 1; } JobBLL.Save(Job); cFMPU100010 FrmDataGrid = this.Owner as cFMPU100010; 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), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }