public void ActualizarSaldo(CajaGeneral caja, decimal valor) { string vl = valor.ToString("N2"); string vr = valor.ToString(); decimal v1 = Convert.ToDecimal(vl, CultureInfo.CreateSpecificCulture("es-ES")); vl = vl.Replace(',', '.'); vr = vr.Replace(',', '.'); int retorno = 0; string[] data = caja.FechaSaldo.Split('/'); string fecha = caja.FechaSaldo; if (data.Length > 1) { fecha = String.Format("{0}-{1}-{2}", data[2].Substring(0, 4), data[1], data[0]); } MySqlConnection conection = Conexion.ObtenerConexion(); MySqlCommand comando = new MySqlCommand(string.Format("update cajageneral set saldo = (saldo + '{0}') where fechaSaldo >= '{1}'", vr, fecha), conection); retorno = comando.ExecuteNonQuery(); comando.Dispose(); conection.Close(); return; }
public CajaGeneral LocalizarNuevoSaldo(string de) { string[] data = de.Split('/'); string fecha = de; if (data.Length > 1) { fecha = String.Format("{0}-{1}-{2}", data[2].Substring(0, 4), data[1], data[0]); } CajaGeneral cg = new CajaGeneral(); MySqlConnection cmd = Conexion.ObtenerConexion(); MySqlCommand comando = new MySqlCommand(String.Format("select * from cajageneral where fechaSaldo >= '{0}' limit 1;", fecha), cmd); MySqlDataReader cods = comando.ExecuteReader(); while (cods.Read()) { cg.IdCaja = cods.GetInt32(0); cg.FechaSaldo = cods.GetString(1); cg.Saldo = cods.GetDecimal(2); } cmd.Close(); return(cg); }
public int Insertar(CajaGeneral cg) { string vl = cg.Saldo.ToString("N2"); string vr = cg.Saldo.ToString(); decimal v1 = Convert.ToDecimal(vl, CultureInfo.CreateSpecificCulture("es-ES")); vl = vl.Replace(',', '.'); vr = vr.Replace(',', '.'); string f = String.Format("{0}-{1}-{2}", cg.FechaSaldo.Substring(6), cg.FechaSaldo.Substring(3, 2), cg.FechaSaldo.Substring(0, 2)); MySqlConnection conection = Conexion.ObtenerConexion(); MySqlCommand comando = new MySqlCommand(string.Format("Insert into cajageneral (fechaSaldo, saldo) values ('{0}','{1}')", f, vr), conection); int retorno = comando.ExecuteNonQuery(); comando.Dispose(); conection.Close(); return(retorno); }