private void MyCmdGuardar_Click()
{
try
{
if ((string.IsNullOrEmpty(txtArea0)) || (string.IsNullOrEmpty(txtArea1)) || (string.IsNullOrEmpty(txtArea2)))
{
return;
}
string myArea = string.Empty;
string myDesc = string.Empty;
string myPrecintos = string.Empty;
string myElectivePositionID = "0";
string myDemarcationID = "0";
string myWhere = string.Empty;
myWhere = _IsInsert == false?cbArea_Item.Substring(0, 4) : "";
myArea = string.Concat(txtArea0, txtArea1);
myDesc = txtArea2;
foreach (Precintos p in lsValidPrecints.ToList())
{
myPrecintos += p.ToString().Split('-')[0].Trim() + "|";
}
bool myUpDate = false;
using (SqlExcuteCommand mySqlExe = new SqlExcuteCommand()
{
DBCnnStr = _DBEndososCnnStr
})
{
myUpDate = mySqlExe.MyChangeArea(_IsInsert, myArea, myDesc, myPrecintos, myElectivePositionID, myDemarcationID, myWhere);
if (myUpDate)
{
_MyAreasTable = mySqlExe.MyGetAreas(false);
cbArea.Clear();
foreach (DataRow row in _MyAreasTable.Rows)
{
cbArea.Add(row[0].ToString());
}
}
}
if (!myUpDate)
{
throw new Exception("Error en la Base de Data");
}
MyReset();
MessageBox.Show("Done...", "Save", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void MyCmdDelete_Click()
{
try
{
if ((string.IsNullOrEmpty(txtArea0)) || (string.IsNullOrEmpty(txtArea1)) || (string.IsNullOrEmpty(txtArea2)))
{
return;
}
var response = MessageBox.Show("!!!Do you really want to Delete this Area?\r\n" + cbArea_Item, "Deleting...", MessageBoxButton.YesNo, MessageBoxImage.Exclamation);
if (response == MessageBoxResult.No)
{
return;
}
string myWhere = string.Empty;
myWhere = cbArea_Item.Substring(0, 4);
bool myDelete = false;
using (SqlExcuteCommand mySqlExe = new SqlExcuteCommand()
{
DBCnnStr = _DBEndososCnnStr
})
{
myDelete = mySqlExe.MyDeleteArea(myWhere);
if (myDelete)
{
_MyAreasTable = mySqlExe.MyGetAreas(false);
cbArea.Clear();
foreach (DataRow row in _MyAreasTable.Rows)
{
cbArea.Add(row[0].ToString());
}
}
}
if (!myDelete)
{
throw new Exception("Error en la Base de Data");
}
MessageBox.Show("Done...", "Delete", MessageBoxButton.OK, MessageBoxImage.Information);
MyReset();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void MyInitWindow()
{
try
{
string myBorderBrush = ConfigurationManager.AppSettings["BorderBrush"];
if (myBorderBrush != null && myBorderBrush.Trim().Length > 0)
{
Type t = typeof(Brushes);
Brush b = (Brush)t.GetProperty(myBorderBrush).GetValue(null, null);
BorderBrush = b;
}
else
{
BorderBrush = Brushes.Black;
}
cbPartidos.Clear();
cbArea.Clear();
using (SqlExcuteCommand get = new SqlExcuteCommand()
{
DBCnnStr = DBEndososCnnStr
})
{
_MyAreasTable = get.MyGetAreas(true);
foreach (DataRow row in _MyAreasTable.Rows)
{
Area myArea = new Area();
myArea.AreaKey = row["Area"].ToString();
myArea.Precintos = row["Precintos"].ToString();
myArea.Desc = row["Desc"].ToString();
myArea.ElectivePositionID = row["ElectivePositionID"].ToString();
myArea.DemarcationID = row["DemarcationID"].ToString();
cbArea.Add(myArea);
}
_MyPartidosTable = get.MyGetPartidos(WhatIsModo);
foreach (DataRow row in _MyPartidosTable.Rows)
{
Partidos mypartido = new Partidos();
mypartido.Id = (int)row["Id"];
mypartido.PartidoKey = row["Partido"].ToString();
mypartido.Desc = row["Desc"].ToString();
mypartido.EndoReq = (int)row["EndoReq"];
mypartido.Area = row["Area"].ToString();
mypartido.Modo = int.Parse(row["Modo"].ToString());
//"Aspirante = 1"
//"Partido = 2"
if (WhatIsModo == 1)
{
if (mypartido.Modo == 1)
{
cbPartidos.Add(mypartido);
}
}
else
{
if (mypartido.Modo == 2)
{
cbPartidos.Add(mypartido);
}
}
}
}
cbPartidos.Sort();
MyReset();
}
catch (Exception ex)
{
MethodBase site = ex.TargetSite;
MessageBox.Show(ex.Message, site.Name, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void MyInitWindow()
{
try
{
string myBorderBrush = ConfigurationManager.AppSettings["BorderBrush"];
if (myBorderBrush != null && myBorderBrush.Trim().Length > 0)
{
Type t = typeof(Brushes);
Brush b = (Brush)t.GetProperty(myBorderBrush).GetValue(null, null);
BorderBrush = b;
}
else
{
BorderBrush = Brushes.Black;
}
cbArea = new ObservableCollection <string>();
lsAllPrecints = new ObservableCollection <Precintos>();
lsValidPrecints = new ObservableCollection <Precintos>();
cbArea_Item_Id = -1;
txtArea0 = "0";
txtArea1 = "0";
txtArea2 = string.Empty;
IsEnabled_CmdAddAllPrec = false;
IsEnabled_CmdAddPrec = false;
IsEnabled_CmdRemovePrec = false;
IsEnabled_CmdRemoveAllPrec = false;
IsEnabled_CmdEditar = false;
IsEnabled_CmdGuardar = false;
IsEnabled_CmdDelete = false;
IsEnabled_cmdAnadir = true;
IsEnabled_CmdCancel = false;
IsEditable_cbArea = false;
IsEnabled_txtArea0 = false;
IsEnabled_txtArea1 = false;
IsEnabled_txtArea2 = false;
IsEnabled_cbArea = true;
IsEnabled_CmdSalir = true;
Visibility_cbArea = Visibility.Visible;
Visibility_txtArea0 = Visibility.Hidden;
Visibility_txtArea1 = Visibility.Hidden;
Visibility_txtArea2 = Visibility.Hidden;
using (SqlExcuteCommand get = new SqlExcuteCommand()
{
DBCnnStr = DBEndososCnnStr
})
{
_MyAreasTable = get.MyGetAreas(false);
foreach (DataRow row in _MyAreasTable.Rows)
{
cbArea.Add(row[0].ToString());
}
_MyPrecintosTable = get.MyGetPrecintos();
this.View.lsAll.ItemsSource = lsAllPrecints;
this.View.lsValid.ItemsSource = lsValidPrecints;
MySetAllPrecinto(_MyPrecintosTable);
}
}
catch (Exception ex)
{
MethodBase site = ex.TargetSite;
MessageBox.Show(ex.Message, site.Name, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void MyRefresh()
{
try
{
cbArea.Clear();
cbPartidos.Clear();
using (SqlExcuteCommand get = new SqlExcuteCommand()
{
DBCnnStr = DBEndososCnnStr
})
{
_MyAreasTable = get.MyGetAreas(true);
foreach (DataRow row in _MyAreasTable.Rows)
{
Area myArea = new Area();
myArea.AreaKey = row["Area"].ToString();
myArea.Precintos = row["Precintos"].ToString();
myArea.Desc = row["Desc"].ToString();
myArea.ElectivePositionID = row["ElectivePositionID"].ToString();
myArea.DemarcationID = row["DemarcationID"].ToString();
cbArea.Add(myArea);
}
_MyPartidosTable = get.MyGetPartidos(WhatIsModo);
foreach (DataRow row in _MyPartidosTable.Rows)
{
Partidos mypartido = new Partidos();
mypartido.Id = (int)row["Id"];
mypartido.PartidoKey = row["Partido"].ToString();
mypartido.Desc = row["Desc"].ToString();
mypartido.EndoReq = (int)row["EndoReq"];
mypartido.Area = row["Area"].ToString();
mypartido.Modo = int.Parse(row["Modo"].ToString());
//"Aspirante = 1"
//"Partido = 2"
if (WhatIsModo == 1)
{
if (mypartido.Modo == 1)
{
cbPartidos.Add(mypartido);
}
}
else
{
if (mypartido.Modo == 2)
{
cbPartidos.Add(mypartido);
}
}
}
}
cbPartidos.Sort();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}