public int agregarGamma(Gammas gam)
{
SqlCommand comando = new SqlCommand();
ArmarParametrosGammasAgregar(ref comando, gam);
return(ds.EjecutarProcedimientoAlmacenado(comando, "spAgregarGammas"));
}
private void ArmarParametrosGammasEliminar(ref SqlCommand Comando, Gammas gam)
{
SqlParameter SqlParametros = new SqlParameter();
SqlParametros = Comando.Parameters.Add("@CODGAMMAS", SqlDbType.VarChar);
SqlParametros.Value = gam.GetCodGammaGA();
}
public Gammas get(string cod)
{
DatosGamma dato = new DatosGamma();
Gammas gam = new Gammas();
gam.SetCodGammaGA(cod);
return(dato.GetGammas(gam));
}
public void LoadData()
{
try
{
var AlphaList = Alpharepo.GetAlphasAsync().Result.ToList();
ObservableCollection <Alpha> POData = new ObservableCollection <Alpha>();
foreach (var item in AlphaList)
{
POData.Add(item);
}
Alphas = POData;
var BetaList = Betarepo.GetBetasAsync().Result.ToList();
ObservableCollection <Beta> BetaData = new ObservableCollection <Beta>();
foreach (var item in BetaList)
{
BetaData.Add(item);
}
Betas = BetaData;
var GammaList = Gammarepo.GetGammasAsync().Result.ToList();
ObservableCollection <Gamma> GammaData = new ObservableCollection <Gamma>();
foreach (var item in GammaList)
{
GammaData.Add(item);
}
Gammas = GammaData;
var DeltaList = DeltaRepo.GetDeltasAsync().Result.ToList();
ObservableCollection <Delta> DeltaData = new ObservableCollection <Delta>();
foreach (var item in DeltaList)
{
DeltaData.Add(item);
}
Deltas = DeltaData;
var ThetaList = ThetaRepo.GetThetasAsync().Result.ToList();
ObservableCollection <Theta> ThetaData = new ObservableCollection <Theta>();
foreach (var item in ThetaList)
{
ThetaData.Add(item);
}
Thetas = ThetaData;
SelectedBeta = Betas.First(x => x.Id.Equals(1));
SelectedGamma = Gammas.First(x => x.Id.Equals(1));
SelectedAlpha = Alphas.First(x => x.Id.Equals(1));
SelectedDelta = Deltas.First(x => x.Id.Equals(1));
SelectedTheta = Thetas.First(x => x.Id.Equals(1));
SaveText = null;
}
catch (Exception e)
{
_logger.Error("Some error have AddRecordViewModel Load data , stacktarce =" + e.StackTrace);
_logger.Error("AddRecordViewModel error message is " + e.Message + " inner error is " + e.InnerException.Message);
}
}
public Gammas GetGammas(Gammas gam)
{
DataTable tabla = ds.obtenerTabla("Gammas", "Select * from Gammas where CodGamma=" + gam.GetCodGammaGA());
gam.SetCodGammaGA(tabla.Rows[0][0].ToString());
gam.SetNombGammaGA(tabla.Rows[0][1].ToString());
gam.SetDescripcionGA(tabla.Rows[0][2].ToString());
gam.SetEstadoCL(Convert.ToBoolean(tabla.Rows[0][3].ToString()));
return(gam);
}
private void OnAdd()
{
Gamma _gamma = new Gamma()
{
Name = NewGammaName
};
NewGammaName = "";
repo.AddGammaAsync(_gamma);
Gammas.Add(_gamma);
}
private void ArmarParametrosGammasAgregar(ref SqlCommand Comando, Gammas gam)
{
SqlParameter SqlParametros = new SqlParameter();
SqlParametros = Comando.Parameters.Add("@CODGAMMA", SqlDbType.VarChar);
SqlParametros.Value = gam.GetCodGammaGA();
SqlParametros = Comando.Parameters.Add("@NOMGAMMA", SqlDbType.VarChar);
SqlParametros.Value = gam.GetNombGammaGA();
SqlParametros = Comando.Parameters.Add("@DESCRIPCION", SqlDbType.VarChar);
SqlParametros.Value = gam.GetDescripcionGA();
SqlParametros = Comando.Parameters.Add("@ESTADOGAM", SqlDbType.Binary);
SqlParametros.Value = gam.GetEstadoCL();
}
public bool eliminarGammas(string cod)
{
//Validar si existente
DatosGamma dato = new DatosGamma();
Gammas gam = new Gammas();
gam.SetCodGammaGA(cod);
int op = dato.eliminarGammas(gam);
if (op == 1)
{
return(true);
}
else
{
return(false);
}
}
private void ResetUI()
{
SelectedBeta = Betas.First(x => x.Id.Equals(1));
SelectedGamma = Gammas.First(x => x.Id.Equals(1));
SelectedAlpha = Alphas.First(x => x.Id.Equals(1));
SelectedDelta = Deltas.First(x => x.Id.Equals(1));
SelectedTheta = Thetas.First(x => x.Id.Equals(1));
Zeus = null;
Hera = null;
BeginDate = null;
EndDate = null;
TargetDate = null;
Artemis = null;
Ares = null;
Athena = null;
Apollo = null;
Poseidon = null;
Remarks = null;
}
public bool agregarGammas(String nomb)
{
int cantFilas = 0;
Gammas gam = new Gammas();
gam.SetNombGammaGA(nomb);
DatosGamma dato = new DatosGamma();
if (dato.existeGammas(gam) == false)
{
cantFilas = dato.agregarGamma(gam);
}
if (cantFilas == 1)
{
return(true);
}
else
{
return(false);
}
}
private void OnDelete()
{
repo.DeleteGammaAsync(SelectedGamma.Id);
Gammas.Remove(SelectedGamma);
}
public List <List <string> > GetPDFDAta()
{
List <List <string> > ListOfRecord = new List <List <string> >();
foreach (var item in ReportRecords)
{
List <string> SingleRecord = new List <string>();
if (PdfFilterZeus)
{
SingleRecord.Add(item.Zeus);
}
if (PdfFilterStatus)
{
SingleRecord.Add(Statuses.First(x => x.Id.Equals(item.StatusID)).Name.ToString());
}
if (PdfFilterEndDate)
{
SingleRecord.Add(item.EndDate);
}
if (PdfFilterGamma)
{
SingleRecord.Add(Gammas.First(x => x.Id.Equals(item.GammaID)).Name.ToString());
}
if (PdfFilterBeta)
{
SingleRecord.Add(Betas.First(x => x.Id.Equals(item.BetaID)).Name.ToString());
}
if (PdfFilterAlpha)
{
SingleRecord.Add(Alphas.First(x => x.Id.Equals(item.AlphaID)).Name.ToString());
}
if (PdfFilterHera)
{
SingleRecord.Add(item.Hera);
}
if (PdfFilterDelta)
{
SingleRecord.Add(Deltas.First(x => x.Id.Equals(item.DeltaID)).Name.ToString());
}
if (PdfFilterBeginDate)
{
SingleRecord.Add(item.BeginDate);
}
if (PdfFilterPoseidon)
{
SingleRecord.Add(item.Poseidon);
}
if (PdfFilterAres)
{
SingleRecord.Add(item.Ares);
}
if (PdfFilterAthena)
{
SingleRecord.Add(item.Athena);
}
if (PdfFilterTheta)
{
SingleRecord.Add(Thetas.First(x => x.Id.Equals(item.ThetaID)).Name.ToString());
}
if (PdfFilterArtemis)
{
SingleRecord.Add(item.Artemis);
}
if (PdfFilterTargetDate)
{
SingleRecord.Add(item.TargetDate);
}
if (PdfFilterApollo)
{
SingleRecord.Add(item.Apollo);
}
ListOfRecord.Add(SingleRecord);
}
return(ListOfRecord);
}
public Boolean existeGammas(Gammas gam)
{
String consulta = "Select * from Gammas where Patente='" + gam.GetNombGammaGA() + "'";
return(ds.existe(consulta));
}
