private void cargaInf(int idPros)
{
DataTable resultTable = new DataTable();
ListViewItem viewItem;
Models.Documentos docs;
string nombre, ap1, ap2, calle, colonia, noCasa, rfc, obs;
int numDoc = 1, idDoc, idEstatus;
Int64 tel, codPost;
streamDataList = new List <Models.Documentos>();
conn.LLenaDateTable(ref resultTable, "Exec proc_listaProspectos 2," + idPros);
nombre = resultTable.Rows[0]["desc_nombre"].ToString();
ap1 = resultTable.Rows[0]["desc_apellido1"].ToString();
ap2 = resultTable.Rows[0]["desc_apellido2"].ToString();
nombreInf.Text = nombre + " " + ap1 + " " + ap2;
calle = resultTable.Rows[0]["desc_calle"].ToString();
noCasa = resultTable.Rows[0]["desc_numero"].ToString();
colonia = resultTable.Rows[0]["desc_colonia"].ToString();
direccionInf.Text = "Calle. " + calle + ". #" + noCasa + " Col." + colonia;
tel = Int64.Parse(resultTable.Rows[0]["num_telefono"].ToString());
telInf.Text = tel.ToString();
codPost = Int64.Parse(resultTable.Rows[0]["num_codPost"].ToString());
cPInf.Text = codPost.ToString();
rfcInf.Text = rfc = resultTable.Rows[0]["desc_rfc"].ToString();
obsInf.Text = obs = resultTable.Rows[0]["desc_observ"].ToString();
idDoc = int.Parse(resultTable.Rows[0]["num_documentoProc"].ToString());
idEstatus = int.Parse(resultTable.Rows[0]["num_estatus"].ToString());
foreach (Models.Estatus item in stats.EstatusList)
{
if (item.Id_estatus.Equals(idEstatus))
{
estatusInf.Text = item.Desc_estatus;
break;
}
}
resultTable.Reset();
conn.LLenaDateTable(ref resultTable, "Exec proc_listaProspectos 3," + idPros);
foreach (DataRow dr in resultTable.Rows)
{
docs = new Models.Documentos(dr["desc_nombreDoc"].ToString(),
dr["desc_rutaDoc"].ToString(),
(byte[])dr["bin_documento"]);
streamDataList.Add(docs);
viewItem = new ListViewItem(numDoc.ToString());
viewItem.SubItems.Add(dr["desc_nombreDoc"].ToString());
listView3.Items.Add(viewItem);
numDoc++;
}
dataObjec = new Models.Prospecto(nombre, ap1, ap2, calle, noCasa, colonia, codPost, tel, rfc, streamDataList);
dataObjec.Obsrv = obs;
dataObjec.NumDocs = idDoc;
dataObjec.NumEstatus = idEstatus;
}
public void tabListadoInit()
{
listView2.Items.Clear();
stats = null;
dataObjec = null;
List <Models.Estatus> statsList = new List <Models.Estatus>();
DataTable result = new DataTable();
conn.LLenaDateTable(ref result, "Exec proc_actEstatus 3,0,0,0");
foreach (DataRow dr in result.Rows)
{
stats = new Models.Estatus(int.Parse(dr["id_estatus"].ToString()), dr["desc_estatus"].ToString());
statsList.Add(stats);
}
stats.EstatusList = statsList;
llenaListView2();
}
private void button1_Click(object sender, EventArgs e)
{
bool okValidation = true;
DataTable resultTable = new DataTable();
int resultInt;
string query = "";
earseErrors();
foreach (Control controlText in tabPage1.Controls)
{
if (controlText is TextBox)
{
okValidation &= ValidatingEmptyFields(controlText);
}
}
okValidation &= emptyDocuments();
if (okValidation)
{
resultInt = conn.ExecuteScalarInt("Exec proc_obtenDataDocs 1") + 1;
conn.LLenaDateTable(ref resultTable, "Exec proc_obtenDataDocs 2");
dataObjec = new Models.Prospecto(nombre.Text, apellido1.Text, apellido2.Text, calle.Text, numeroCasa.Text, colonia.Text, Int64.Parse(cP.Text), Int64.Parse(telefono.Text), rfc.Text, streamDataList);
listToTable(ref resultTable, dataObjec.DocsList, resultInt);
conn.BulkCopy(resultTable, "Documentos");
query = "Exec proc_capturaProspecto '" +
dataObjec.NombrePros + "', '" +
dataObjec.PrimerApe + "', '" +
dataObjec.SegundoApe + "', '" +
dataObjec.CallePros + "', '" +
dataObjec.NumeroCasa + "', '" +
dataObjec.Colonia + "', " +
dataObjec.CodePost + ", '" +
dataObjec.TelPros + "', '" +
dataObjec.rfc1 + "', " +
resultInt + ", " + 1 + "";
conn.Execute(query);
MessageBox.Show("La captura a sido exitosa.",
"Exitoso",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
dataObjec.clearProspecto();
}
}