private void MyCmdFind_Click() { try { using (SqlExcuteCommand get = new SqlExcuteCommand() { DBCeeMasterCnnStr = DBCeeMasterCnnStr }) { // _CanFind = true; txtNumCandidato = txtNumCandidato.PadLeft(7, '0'); if (!chkPartido) { DataTable myTable = get.MyGetCitizen(txtNumCandidato); bool mIsPartido = false; if (myTable.Rows.Count == 0) { int id = 0; int.TryParse(txtNumCandidato, out id); get.DBCnnStr = DBEndososCnnStr; myTable = get.MyGetPartidos(id.ToString()); if (myTable.Rows.Count == 0) { throw new Exception("Número invalido."); } else { mIsPartido = true; } } if (!mIsPartido) { txtNombre = myTable.Rows[0]["FirstName"].ToString() + " " + myTable.Rows[0]["LastName1"].ToString() + " " + myTable.Rows[0]["LastName2"].ToString(); switch (myTable.Rows[0]["Status"].ToString().Trim().ToUpper()) { case "A": txtStatusElec = "A"; break; case "E": // MessageBox.Show("Excluido","Error",MessageBoxButton.OK,MessageBoxImage.Error); txtStatusElec = "E"; break; case "I": txtStatusElec = "I"; //MessageBox.Show("Inactivo", "Error", MessageBoxButton.OK, MessageBoxImage.Error); break; default: txtStatusElec = "?"; break; } } else { // isPartido chkPartido = true; txtNombre = myTable.Rows[0]["Desc"].ToString(); txtEndoReq = myTable.Rows[0]["EndoReq"].ToString(); String area = myTable.Rows[0]["Area"].ToString(); IsChecked_rbCargos[0] = true; cbArea_Item_Id = FindByArea(area); } } else {//isPartido int id = 0; int.TryParse(txtNumCandidato, out id); get.DBCnnStr = DBEndososCnnStr; DataTable myTable = get.MyGetPartidos(id.ToString()); if (myTable.Rows.Count == 0) { throw new Exception("Número invalido."); } txtNombre = myTable.Rows[0]["Desc"].ToString(); txtEndoReq = myTable.Rows[0]["EndoReq"].ToString(); String area = myTable.Rows[0]["Area"].ToString(); IsChecked_rbCargos[0] = true; cbArea_Item_Id = FindByArea(area); } //txtApellido1 = myTable.Rows[0]["LastName1"].ToString(); //txtApellido2 = myTable.Rows[0]["LastName2"].ToString(); } } catch (Exception ex) { MethodBase site = ex.TargetSite; MessageBox.Show(ex.Message, site.Name, MessageBoxButton.OK, MessageBoxImage.Error); // _LogClass.MYEventLog.WriteEntry(string.Concat(ex.Message, "\r\n", site.Name), EventLogEntryType.Error, 9999); MyReset(); } }
public void MyCmdFind_Click() { try { MyReset(); using (SqlExcuteCommand get = new SqlExcuteCommand() { DBCeeMasterCnnStr = DBCeeMasterCnnStr, DBImagenesCnnStr = DBCeeMasterImgCnnStr }) { DataTable myTable; DataTable myTableImg; if (TxtElecNum.Trim().Length < 7) { TxtElecNum = TxtElecNum.Trim().PadLeft(7, '0'); } _CanFind = true; myTable = get.MyGetCitizen(TxtElecNum); myTableImg = get.MyGetCitizenImg(TxtElecNum); if (myTable.Rows.Count == 0) { throw new Exception("Número electoral invalido."); } TxtNombre = myTable.Rows[0]["FirstName"].ToString(); TxtPaterno = myTable.Rows[0]["LastName1"].ToString(); TxtMaterno = myTable.Rows[0]["LastName2"].ToString(); TxtPadre = myTable.Rows[0]["FatherName"].ToString(); TxtMadre = myTable.Rows[0]["MotherName"].ToString(); TxtUnidad = myTable.Rows[0]["SecondGeoCode"].ToString().PadLeft(2, '0'); TxtPrecinto = myTable.Rows[0]["FirstGeoCode"].ToString().PadLeft(3, '0'); string Fechanac = myTable.Rows[0]["DateOfBirth"].ToString(); if (!string.IsNullOrEmpty(Fechanac)) { TxtMes = Fechanac.Split('/')[0].Trim().PadLeft(2, '0'); TxtDia = Fechanac.Split('/')[1].Trim().PadLeft(2, '0'); TxtAno = Fechanac.Split('/')[2].Trim().Substring(0, 4); } switch (myTable.Rows[0]["Status"].ToString().Trim().ToUpper()) { case "A": IsChecked_Activo = true; break; case "E": IsChecked_Excluido = true; break; case "I": IsChecked_Inactivo = true; break; default: IsChecked_Activo = false; IsChecked_Excluido = false; IsChecked_Inactivo = false; break; } switch (myTable.Rows[0]["Gender"].ToString().Trim().ToUpper()) { case "F": IsChecked_SexF = true; break; case "M": IsChecked_SexM = true; break; default: IsChecked_SexF = false; IsChecked_SexM = false; break; } // 'DESPLIEGA LA FIRMA DEL ELECTOR if (myTableImg.Rows.Count > 0) { byte[] dataSignature = (byte[])myTableImg.Rows[0]["SignatureImage"]; MemoryStream strmSignature = new MemoryStream(); strmSignature.Write(dataSignature, 0, dataSignature.Length); strmSignature.Position = 0; System.Drawing.Image img = System.Drawing.Image.FromStream(strmSignature); BitmapImage bi = new BitmapImage(); bi.BeginInit(); MemoryStream ms = new MemoryStream(); img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); ms.Seek(0, SeekOrigin.Begin); bi.StreamSource = ms; bi.EndInit(); Source_image = bi; } else { Source_image = null; } // 'DESPLIEGA LA Photo DEL ELECTOR //byte[] dataPhoto = (byte[])myTable.Rows[0]["PhotoImage"]; //MemoryStream strmPhoto = new MemoryStream(); //strmPhoto.Write(dataPhoto, 0, dataPhoto.Length); //strmPhoto.Position = 0; //System.Drawing.Image imgPhoto = System.Drawing.Image.FromStream(strmPhoto); //BitmapImage biPhoto = new BitmapImage(); //biPhoto.BeginInit(); //MemoryStream msPhoto = new MemoryStream(); //imgPhoto.Save(msPhoto, System.Drawing.Imaging.ImageFormat.Jpeg); //msPhoto.Seek(0, SeekOrigin.Begin); //biPhoto.StreamSource = msPhoto; //biPhoto.EndInit(); //Source_imagePhoto = biPhoto; } } catch (Exception ex) { MethodBase site = ex.TargetSite; MessageBox.Show(ex.Message, site.Name, MessageBoxButton.OK, MessageBoxImage.Error); try { _LogClass.MYEventLog.WriteEntry(ex.ToString() + "\r\n" + site.Name, EventLogEntryType.Error, 9999); } catch { } } finally { } }
private void MyCmdFind_Click() { try { cbNotario_Item_Id = FindByNotario(txtNumElec); if (cbNotario_Item_Id < 0) { int FixNum = 0; int.TryParse(txtNumElec, out FixNum); cbNotario_Item_Id = FindByNotario(FixNum.ToString()); } if (cbNotario_Item_Id < 0) { using (SqlExcuteCommand get = new SqlExcuteCommand() { DBCeeMasterCnnStr = DBCeeMasterCnnStr }) { // _CanFind = true; txtNumElec = txtNumElec.PadLeft(7, '0'); DataTable myTable = get.MyGetCitizen(_txtNumElec); if (myTable.Rows.Count == 0) { throw new Exception("Número electoral invalido."); } txtNombre = myTable.Rows[0]["FirstName"].ToString(); txtApellido1 = myTable.Rows[0]["LastName1"].ToString(); txtApellido2 = myTable.Rows[0]["LastName2"].ToString(); switch (myTable.Rows[0]["Status"].ToString().Trim().ToUpper()) { case "A": txtStatusElec = "A"; break; case "E": // MessageBox.Show("Excluido","Error",MessageBoxButton.OK,MessageBoxImage.Error); txtStatusElec = "E"; break; case "I": txtStatusElec = "I"; //MessageBox.Show("Inactivo", "Error", MessageBoxButton.OK, MessageBoxImage.Error); break; default: txtStatusElec = "?"; break; } } } } catch (Exception ex) { MethodBase site = ex.TargetSite; MessageBox.Show(ex.Message, site.Name, MessageBoxButton.OK, MessageBoxImage.Error); _LogClass.MYEventLog.WriteEntry(string.Concat(ex.Message, "\r\n", site.Name), EventLogEntryType.Error, 9999); MyReset(); } }