public PantallaGerencial() { InitializeComponent(); cta = new CADINDataSetTableAdapters.CasoTableAdapter(); ata3 = new CADINDataSetTableAdapters.Actividades3TableAdapter(); s1 = new BindingSource(); s2 = new BindingSource(); cdt = cta.GetData(); s1.DataSource = cdt; s2.DataSource = adt3; llenarActividades(); String q = "SELECT COUNT(*) FROM Caso"; SqlCommand comand; comand = new SqlCommand(q, cta.Connection); comand.Connection.Open(); comand.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(q, cta.Connection); SqlCommandBuilder builder = new SqlCommandBuilder(da); DataTable table = new DataTable(); da.Fill(table); System.Data.DataRow row = table.Rows[0]; txtotal.Text = row.ItemArray.GetValue(0).ToString(); comand.Connection.Close(); }
private void radioTodos_CheckedChanged(object sender, EventArgs e) { if (this.radioTodos.Checked) { dataTableCaso = tableAdapterCaso.GetDataByEmpresa(codigo); this.dataGridViewX1.DataSource = dataTableCaso; this.dataGridViewX1.Columns[1].Visible = false; } }
public Casos_View(int codigo) { InitializeComponent(); this.codigo = codigo; tableAdapterCaso = new CADINDataSetTableAdapters.CasoTableAdapter(); dataTableCaso = new CADINDataSet.CasoDataTable(); dataTableCaso=tableAdapterCaso.GetDataByEmpresa(codigo); this.dataGridViewX1.DataSource = dataTableCaso; this.dataGridViewX1.Columns[1].Visible = false; }
public Caso(Usuario u) { InitializeComponent(); this.u = u; cta = new CADINDataSetTableAdapters.CasoTableAdapter(); ata = new CADINDataSetTableAdapters.ActividadesTableAdapter(); ata2 = new CADINDataSetTableAdapters.Actividades2TableAdapter(); eta = new CADINDataSetTableAdapters.EmpresaTableAdapter(); s1 = new BindingSource(); s2 = new BindingSource(); cdt = cta.GetData(); adt = ata.GetData(); s1.DataSource = cdt; s2.DataSource = adt; if (s1.Position != -1) { txcod_Caso.DataBindings.Add("Text", s1, "cod_caso"); txCod_empr.DataBindings.Add("Text", s1, "cod_empr"); txNomb_solic.DataBindings.Add("Text", s1, "pers_solic"); txCargo.DataBindings.Add("Text", s1, "carg_pers_solic"); ipFech_soli.DataBindings.Add("Text", s1, "fech_solic"); txDesc_prob.DataBindings.Add("Text", s1, "desc_soli"); txDesc_solu.DataBindings.Add("Text", s1, "desc_solu"); if (s1.Position != -1) sliderNiv_solu.DataBindings.Add("Value", s1, "nive_solu"); if (s1.Position != -1) ckbCaso_cerr.DataBindings.Add("Checked", s1, "caso_cerrado"); txObservaciones.DataBindings.Add("Text", s1, "observaciones"); txCod_resp.DataBindings.Add("Text", s1, "cod_func_asig"); txResp_Caso.DataBindings.Add("Text", s1, "nomb_func_asig"); ipFech_solu.DataBindings.Add("Text", s1, "fech_solf"); dataGridViewX1.DataSource = s2; if (u.Admin) { chkbAdm.Visible = true; if (s1.Position != -1) chkbAdm.DataBindings.Add("Checked", s1, "caso_cerrado"); } s1.MoveFirst(); cargarNE1(); llenarActividades(); Cancelar(); } else { MessageBox.Show("No hay registros guardados"); Nuevo(); } }
private void dataGridViewX1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (superValidator1.Validate()) { if (modo) { // cta.Update(cdt.Rows[s1.IndexOf(s1.Current)]); ActualizarC(); this.dataGridViewX1.ReadOnly = true; } else { //s1.AddNew(); GuardarC(); cdt = cta.GetData(); s1.DataSource = cdt; s1.MoveLast(); modo = true; } //MessageBox.Show(e.RowIndex+""); //int index = s2.IndexOf(s2.Current); int index = e.RowIndex; Actividades act; //MessageBox.Show(dataGridViewX1[0, index].Value.ToString()); int cod_responsable = Convert.ToInt32(txCod_resp.Text); int cod_caso = Convert.ToInt32(txcod_Caso.Text); if ((dataGridViewX1[0, index].Value == null) || (dataGridViewX1[0, index].Value.ToString() == "") || (dataGridViewX1[0, index].Value.Equals(-1))) { System.Data.DataRow row = adt.NewRow(); act = new Actividades(true, row, cod_responsable, cod_caso); } else { //MessageBox.Show(dataGridViewX1[0, index].Value.ToString()); //System.Data.DataRow row = adt.Rows[index]; DataRow row= adt.FindBycod_actv((int)dataGridViewX1.Rows[index].Cells["cod_actv"].Value); act = new Actividades(false, row, cod_responsable, cod_caso); } act.ShowDialog(); llenarActividades(); } else MessageBox.Show("Revise los campos requeridos"); }
private void buttonX1_Click(object sender, EventArgs e) { if (superValidator1.Validate()) { if (modo) { // cta.Update(cdt.Rows[s1.IndexOf(s1.Current)]); ActualizarC(); this.dataGridViewX1.ReadOnly = true; } else { //s1.AddNew(); GuardarC(); cdt = cta.GetData(); s1.DataSource = cdt; s1.MoveLast(); modo = true; } int index = s2.IndexOf(s2.Current); System.Data.DataRow row; if (adt.Rows.Count > 0) { row = adt.Rows[index]; } else { row = adt.NewRow(); } int cod_responsable = Convert.ToInt32(txCod_resp.Text); int cod_caso = Convert.ToInt32(txcod_Caso.Text); Actividades act = new Actividades(true, row, cod_responsable, cod_caso); act.setUser(u.Cod_Usua); act.ShowDialog(); llenarActividades(); } else MessageBox.Show("Revise los campos requeridos"); }
public bool Guardar() { if (superValidator1.Validate()) { if (modo) { //cta.Update(cdt.Rows[s1.IndexOf(s1.Current)]); ActualizarC(); this.dataGridViewX1.ReadOnly = true; } else { //s1.AddNew(); //s1.MoveLast(); GuardarC(); } cdt = cta.GetData(); s1.DataSource = cdt; MessageBox.Show("Guardado"); Cancelar(); return true; } else MessageBox.Show("Revise los campos requeridos"); return false; }