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