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;
}
