public bool Insert(UsuarioTemporal usuarioTemporal) { var sql = "insert into usuarios_correo (nombre,apellido,correo_electronico,correo_copia,asunto,titulo,mensaje,estado) VALUES(@nombre, @apellido, @correo_electronico,@correo_copia, @asunto,@titulo, @mensaje,@estado)"; var parametros = new List <Parametro> { new Parametro("@nombre", usuarioTemporal.Nombre), new Parametro("@apellido", usuarioTemporal.Apellido), new Parametro("@correo_electronico", usuarioTemporal.CorreoElectronico), new Parametro("@correo_copia", usuarioTemporal.CCopy), new Parametro("@asunto", usuarioTemporal.Asunto), new Parametro("@titulo", usuarioTemporal.Titulo), new Parametro("@mensaje", usuarioTemporal.Cuerpo), new Parametro("@estado", Convert.ToInt16(usuarioTemporal.EstadoEnvio)) }; try { var resl = manejador.Execute(sql, parametros, CommandType.Text); return((resl == 0) ? false : true); } catch (Exception) { return(false); } }
public Boolean Update(Usuario user) { var sql = "UPDATE users SET number_id = @number_id,name=@name,user_name=@user_name,user_type=@user_type,lastname_p=@lastname_p,lastname_m=@lastname_m,phone_number=@phone_number," + "mail=@mail,notes=@notes,password=@password,updated_by=@updated_by,active=@active WHERE user_id = @user_id;"; List <Parametro> lst = new List <Parametro> (); lst.Add(new Parametro("@user_id", user.UsuarioId)); lst.Add(new Parametro("@number_id", user.MyCedula)); lst.Add(new Parametro("@name", user.MyNombre)); lst.Add(new Parametro("@user_name", user.UserName)); lst.Add(new Parametro("@user_type", (int)user.TipoUsuario)); lst.Add(new Parametro("@lastname_p", user.MyApellidoPaterno)); lst.Add(new Parametro("@lastname_m", user.MyApellidoMaterno)); lst.Add(new Parametro("@phone_number", user.MyTelefono)); lst.Add(new Parametro("@mail", user.MyMail)); lst.Add(new Parametro("@notes", user.MyNotas)); lst.Add(new Parametro("@password", user.MyClave)); lst.Add(new Parametro("@updated_by", user.UpdatedBy)); lst.Add(new Parametro("@active", Convert.ToInt16(user.MyActivo))); try { return((manejador.Execute(sql, lst, CommandType.Text) == 0) ? true : false); } catch (Exception) { throw new Exception($"No se ejecuto el query: {nameof(Update)}"); } }
public void Delete(double accountingEntryId) { var sql = "UPDATE accounting_entries SET active = FALSE " + "WHERE accounting_entry_id = @accounting_entry_id LIMIT 1"; try { //int totalActulizados; var cnt = manejador.Execute(sql, new List <Parametro> { new Parametro("@accounting_entry_id", accountingEntryId) }, CommandType.Text); } catch (Exception ex) { ///log.write(ex); throw new Exception($"No se pudo ejecutar el metodo {nameof(Delete)}"); } }
public bool InsertCompany(List <Compañia> compañias, Usuario asignacion, Usuario usuario) { int contador = compañias.Count; foreach (var compani in compañias) { ///agregar el ignore var sql = "INSERT INTO companies_permission (user_id,company_id,updated_by) VALUES (@user_id,@company_id,@updated_by) " + "ON DUPLICATE KEY UPDATE updated_by = @updated_by , updated_at = NOW(), active = 1"; var parametros = new List <Parametro> { new Parametro("@user_id", asignacion.UsuarioId), new Parametro("@company_id", compani.Codigo), new Parametro("@updated_by", usuario.UsuarioId) }; contador = (manejador.Execute(sql, parametros, CommandType.Text) == 1) ? contador - 1 : contador; } return((contador == 0) ? true : false); }
public Compañia Insert(Compañia company, string copiarMaestroCuenta, Usuario user) { var sql = "INSERT INTO companies(company_id,type_id,number_id,name,money_type,op1,op2,address,website,mail,phone_number1,phone_number2,notes,user_id)" + "VALUES(@company_id,@type_id,@number_id,@name,@money_type,@op1,@op2,@address,@website,@mail,@phone_number1,@phone_number2,@notes,@user_id);"; List <Parametro> lst = new List <Parametro>(); company.Codigo = NuevoCodigo(); lst.Add(new Parametro("@company_id", company.Codigo)); lst.Add(new Parametro("@type_id", (int)company.TipoId)); lst.Add(new Parametro("@number_id", company.NumeroCedula)); lst.Add(new Parametro("@name", company.Nombre)); lst.Add(new Parametro("@money_type", (int)company.TipoMoneda)); lst.Add(new Parametro("@address", company.Direccion)); lst.Add(new Parametro("@website", company.Web)); lst.Add(new Parametro("@mail", company.Correo)); lst.Add(new Parametro("@phone_number1", company.Telefono[0])); lst.Add(new Parametro("@phone_number2", company.Telefono[1])); lst.Add(new Parametro("@notes", company.Observaciones)); lst.Add(new Parametro("@user_id", user.UsuarioId)); lst.Add(new Parametro("@op1", ((company is PersonaJuridica) ? ((PersonaJuridica)company).MyIDRepresentanteLegal : ((PersonaFisica)company).MyApellidoPaterno))); lst.Add(new Parametro("@op2", ((company is PersonaJuridica) ? ((PersonaJuridica)company).MyRepresentanteLegal : ((PersonaFisica)company).MyApellidoMaterno))); try { if (manejador.Execute(sql, lst, CommandType.Text) != 0) { CrearMaestroCuenta(copiarMaestroCuenta, user, company); return(company); } else { throw new Exception("No se pudo insertar la compañia"); } } catch (Exception) { throw; } }
public void Update(Transaccion tr, long userid) { var sql = "UPDATE transactions_accounting " + "SET account_id = @account_id, " + "reference = @reference, " + "detail = @detail, " + "balance = @balance," + "balance_type = @balance_type, " + "money_type = @money_type, " + "money_chance = @money_chance, " + "bill_date = @bill_date," + "updated_by = @updated_by " + "WHERE transaction_accounting_id = @transaction_accounting_id"; List <Parametro> lst = new List <Parametro> { new Parametro("@account_id", tr.CuentaDeAsiento.Id), new Parametro("@reference", tr.Referencia), new Parametro("@detail", tr.Detalle), new Parametro("@balance", tr.Monto), new Parametro("@balance_type", (int)tr.ComportamientoCuenta), new Parametro("@money_type", (int)tr.TipoCambio), new Parametro("@money_chance", tr.MontoTipoCambio), new Parametro("@bill_date", tr.FechaFactura), new Parametro("@updated_by", userid), new Parametro("@transaction_accounting_id", tr.Id) }; try { var affectedRows = manejador.Execute(sql, lst, CommandType.Text); if (affectedRows == 0) { throw new Exception("No se actualizo ningun registro"); } } catch (Exception ex) { throw ex; } }
private void InsertName(string name) { manejador.Execute(SqlStringInsertName, new Parametro("@name", name)); }