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