public int bajaSalario(Salarios s) { Command.CommandText = "delete from salariominimo where idsalario = @idsalario"; Command.Parameters.Clear(); Command.Parameters.AddWithValue("idsalario", s.idsalario); return(Command.ExecuteNonQuery()); }
public int bajaSalario(Salarios s) { Command.CommandText = "delete from salariominimo where idsalario = @idsalario"; Command.Parameters.Clear(); Command.Parameters.AddWithValue("idsalario", s.idsalario); return Command.ExecuteNonQuery(); }
public int insertaSalario(Salarios s) { Command.CommandText = "insert into salariominimo (periodo, valor) values (@periodo, @valor)"; Command.Parameters.Clear(); Command.Parameters.AddWithValue("periodo", s.periodo); Command.Parameters.AddWithValue("valor", s.valor); return(Command.ExecuteNonQuery()); }
public int insertaSalario(Salarios s) { Command.CommandText = "insert into salariominimo (periodo, valor, zona) values (@periodo, @valor, @zona)"; Command.Parameters.Clear(); Command.Parameters.AddWithValue("periodo", s.periodo); Command.Parameters.AddWithValue("valor", s.valor); Command.Parameters.AddWithValue("zona", s.zona); return Command.ExecuteNonQuery(); }
public int actualizaSalario(Salarios s) { Command.CommandText = "update salariominimo set periodo = @periodo, valor = @valor where idsalario = @idsalario"; Command.Parameters.Clear(); Command.Parameters.AddWithValue("idsalario", s.idsalario); Command.Parameters.AddWithValue("periodo", s.periodo); Command.Parameters.AddWithValue("valor", s.valor); return(Command.ExecuteNonQuery()); }
public int actualizaSalario(Salarios s) { Command.CommandText = "update salariominimo set periodo = @periodo, valor = @valor, zona = @zona where idsalario = @idsalario"; Command.Parameters.Clear(); Command.Parameters.AddWithValue("idsalario", s.idsalario); Command.Parameters.AddWithValue("periodo", s.periodo); Command.Parameters.AddWithValue("valor", s.valor); Command.Parameters.AddWithValue("zona", s.zona); return Command.ExecuteNonQuery(); }
public List <Salarios> obtenerSalarios() { DataTable dtSalarios = new DataTable(); List <Salarios> lstSalario = new List <Salarios>(); Command.CommandText = "select idsalario, periodo, valor from salariominimo"; Command.Parameters.Clear(); dtSalarios = SelectData(Command); for (int i = 0; i < dtSalarios.Rows.Count; i++) { Salarios s = new Salarios(); s.idsalario = int.Parse(dtSalarios.Rows[i]["idsalario"].ToString()); s.periodo = DateTime.Parse(dtSalarios.Rows[i]["periodo"].ToString()); s.valor = decimal.Parse(dtSalarios.Rows[i]["valor"].ToString()); lstSalario.Add(s); } return(lstSalario); }
public List<Salarios> obtenerSalario(Salarios salario) { DataTable dtSalarios = new DataTable(); List<Salarios> lstSalario = new List<Salarios>(); Command.CommandText = "select idsalario, periodo, valor, zona from salariominimo where idsalario = @idsalario"; Command.Parameters.Clear(); Command.Parameters.AddWithValue("idsalario", salario.idsalario); dtSalarios = SelectData(Command); for (int i = 0; i < dtSalarios.Rows.Count; i++) { Salarios s = new Salarios(); s.idsalario = int.Parse(dtSalarios.Rows[i]["idsalario"].ToString()); s.periodo = DateTime.Parse(dtSalarios.Rows[i]["periodo"].ToString()); s.valor = decimal.Parse(dtSalarios.Rows[i]["valor"].ToString()); s.zona = dtSalarios.Rows[i]["zona"].ToString(); lstSalario.Add(s); } return lstSalario; }
public object obtenerSalarioValor(Salarios s) { Command.CommandText = "select valor from salariominimo where idsalario = @idsalario"; Command.Parameters.Clear(); Command.Parameters.AddWithValue("idsalario", s.idsalario); object dato = Select(Command); return dato; }